on 02-08-2012 12:00 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.