Cube Reload and rollup ?

[Former Member]

Hello BW Experts,

I have a cube A. There are two requests Req1 and Req2. on day 1 i have loaded the req1.1 and req2.1 and rollup done for roll.req1.1 and roll.req2.1. Now i have to reload the req1.r and req2.r. so what is the procedure to be followed? and how to do the rollup for roll.req1.r and roll.req2.r

1) delete the req2.1

2) delete the req1.1

3) anything to do with the rollups of req1 and req2???

4) reload the req1.r

5) reload the req2.r

6) i am supposing the rollups is happneing automatic??? or anything to be done to do the rollups.

Q1) please let me know what i have to do in steps 3 and 6 ?

Q2)is the sequence above mentioned correct ? is there anything i am missing.

Q3) is rollup done automatically ? how to verify it ?

suggestions appreciated.

Thanks,

BWer

[edwin_harpino]

hi BWer,

to check if you scheduled automatic roll up,

tab 'roll up', and if there is job scheduled,

BI_AGGR*. or you may include the roll up in process chain ?

http://help.sap.com/saphelp_nw2004s/helpdata/en/9a/33853bbc188f2be10000000a114084/frameset.htm

hope this helps.

[dielom]

Hi BWer,

Q1) When you delete the requests, the aggregates are calculated again (rollup). if you reload the requests, it depends of how rollup is made, if its automatic or you should start it manually. you will see this with the requests.

Q2) the sequence seems to be correct

Q3) you can check the rollup when you manage the infocube, in the requests page, the fifth column (Rollup Status) it should have a check.

Hope it helps.

Regards,

Diego Lombardini

[Former Member]

Thanks Diego,

is there a setting which says it is automatic rollup?

suggestions appreciated

Thanks,

BWer

[edwin_harpino]

hi BWer,

so you have found the setting in infocube->manage->environement->automatic setting

[Former Member]

Hi,

For automatic rollup :

IC->Manage->Rollup tab->Environment->Automatic Request Processing.

In there you'll find check box for automatic roll up of requests.

Cheers,

Kedar