Solved: How to reduce Data Manager time

Former Member · ‎07-26-2011

Dear all,

I have a query which is showing 120 sec as Data manager time. Pls suggest the steps to reduce the Data manager time for this query.

Thanks

Former Member · ‎07-26-2011

In this link you may find the answer to all related questions:

Reducing data manager time can be achieved by:

- optimization of data model

- as far as possible: parallization of multi provider access

- Aggreates

Regards

Aban

Former Member · ‎09-02-2011

HI,

i have a problem with datamanager package,

when i am running the package status is showing error.

if i click details showing empty.

any one can help me regarding this, hw many ways that error will come. how many ways we can resolve.

Thanks

vikky

Former Member · ‎07-27-2011

Also check the ratio between number of record selected Vs No of records transferred. If it is high, go for aggregates.

Thanks,

Krishnan

former_member182470 · ‎07-26-2011

Hi,

You have to undertake some performance tuning measures like:----

1) Building Aggregates with high Valuation

2) Prefiling Cache

3) Cache settings in RSRCACHE

4) Query read modes with Delta cache settings in RSRT

5) Multiprovider

6) Indexes in Cubes(Performance tab)

Periodic Statistic checks in ST03

Regards,

Suman

How to reduce Data Manager time