cancel
Showing results for 
Search instead for 
Did you mean: 

Plz guide me through manual Compression and Roll up process

Former Member
0 Kudos

I have pulled data from DSO to Cube. There are aggregates maintained here. now i have to do the compression(in infocube and in aggregate)and roll up (in cube and in aggregate)steps. can u plz guide me step wise..

Thank you

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi Ramya,

Call T-Code RSA1> Search for your Info Cube > Click on Manage and follow the below mentioned steps for

Roll up

1. Click on Roll up Tab in 'Manage Info Provider' Screen

2. By default 'Request ID' in Roll up section will be filled with latest Request ID of the data loaded. All the requests before your latest request with be Rolled up.

3. Click on execute > click on Display external Jobs (Next to execute button) and monitor it.

4. Once the Roll Up job Completes successfully > Click on Requests Tab in the Manage Info Provider Screen > you will find a tick mark in Roll up status, which confirms your task.

Compression

1. Click on Collapse Tab in 'Manage Info Provider' Screen

2. By default 'Request ID' in Collapse section will be filled with latest Request ID of the data loaded. All the requests before your latest request with be Compressed.

3. Click on Release > click on Display external Jobs (Next to Release button) and monitor it.

4. Once the Compression job Completes successfully > Click on Requests Tab in the Manage Info Provider Screen > you will find a tick mark in Compression status, which confirms your task.

Hope this helps.

Regards

Sai

former_member188080
Active Contributor
0 Kudos

Hi,

refer to following thread

http://forums.sdn.sap.com/thread.jspa?threadID=438431

you need to go to tab mentioned in RSA1 in Infocube manage..

and then specify the request ID uptil where u can carry out the compression..

and you can take a call in case you want to do it for the request before one week..

then u can carry out aggregates and roll up..once compressed and aggregated you have to do deletion through selective deletion mode only..

so careful..

also you can compress aggregates as well

if u have BIA index no need to do anything ..

Thanks and regards

Kiran

mr_v
Active Contributor
Former Member
0 Kudos

Dear Ramya,

For making our SCN community more useful, please search the forum before posting a thread to avoid redundancy.

Hope you understand. Thanks.

Best Regards, @{

Edited by: Arun Bala G on Feb 8, 2012 1:27 AM

Former Member
0 Kudos

Hi Ramya,

First do the roll up and then perform the compression.

1) Roll Up:

--> search for your cube in RSA1

--> right click and manage

--> take the request number for which you want to do roll up from request tab

--> now click on "Roll up" tab

--> give the request ID and click on execute.

Now you can see the job in SM37 and monitor it till it gets complete.Once it is completed you can see tick mark for your request in request tab(under roll up status column).

2) Compress:

follow the same process, but need to all the above steps in "Collapse" tab

Regards,

Venkatesh