How to increase the performance of a multiprovider?

[Former Member]

1.performaance for ods

2. while loading data in a cube, how to increase performance

Please search the forum before posting a thread

Edited by: Pravender on Feb 4, 2012 10:59 AM

[Former Member]

Hi

Please give the title relevant to post, so that you will get more replies.

DSO loading improvements:

1) do not use semantic groups in DTP unless it is required.

2) use serial extraction and immediate parallel processing in DTP execution tab.

3) periodically delete the change log table of DSO.

Info Cube:

1) delete index before loading and create it after loading is done.

2) first two points of DSO performance is applicable here

3) Compress the data based on business requirement(once in 15days or once in a month)

Regards,

Venkatesh

[former_member210615]

hi,

check the setting maintained for the data transfer , also check for following under setting "SID generation ",

also try Delete the Cube indexes while loading data to cube and then re built it, also try to optimize start /end routine codes.

you can Increase the number of parallel processing for that DTP and also try chaging Data packet size in the DTP(in tcode RSCUSTV6)

also if data loaded to infocube is in huge amount then you can try implement number range buffering as well

hope it helps

regards

laksh

[Former Member]

Hi,

Before loading data delete the index of the cube and after successful data load recreate it again.

Regularly delete the changelog table of DSO.

Edited by: Pradeepkdas on Feb 3, 2012 7:26 PM