aggregate performance

[Former Member]

Hi, Experts,

I never be understand the roll up process.

I have a cube with several aggregates ( one aggregate per company code)

new I just loading one infopackage ( for one company), just 2400 records so it takes one minute finished loading, but roll up this request take 2 hours still not finished.

for my expactation, this request only impact one aggregate. even I manually de-active and active this aggregate is not time consuming, why it take so long.

by the way, notes 778709 I have already implemented.

[edwin_harpino]

hi,

check oss note 534630 - Parallel processing of Change Run ? setting :

Transaction SPRO > SAP Reference IMG > BW Customizing Implementation Guide > Business Information Warehouse > General BW Settings > Parameters for aggregates > Block size parameters

[Former Member]

Thanks A.H.P

But my problem on transcation data.

[edwin_harpino]

hi,

yes, your message '...<i>but roll up this request take 2 hours still not finished</i> ...', deal with aggregate ? so can try to set the aggregate block size ?

[Former Member]

I check the setting of my system, the block size is blank. what's figure I should put in ?

thanks

[Former Member]

by the way, I check job job of BI_AGGR. I found all of aggregates are impact in roll up process. but I only load one company data which should only impact one aggregate.