Friday, November 23, 2007

How to Compress InfoCube Data

How Info cube compression is done?

v\:* {behavior:url(#default#VML);}o\:*
{behavior:url(#default#VML);}w\:* {behavior:url(#default#VML);}.shape
{behavior:url(#default#VML);}
Create aggregates for that infocube

-----------------------------------------------------------------------------------

I guess what the question was how we can compress a data inside a cube, I assume that's usually done through by deleting the Request ID column value.
This can be done through Manage - > Compress Tab.

-----------------------------------------------------------------------------------

Go to RSA1
Under Modeling --> Choose InfoProvider --> InfoArea and then --> Select your InfoCube

Right Click on your infocube --> from context menu --> choose Manage

Once you are in manager data Targets screen:
Find out the request numbers – decide till what request id you want to compress

Go to Collapse tab – under compress --> choose request ID and click Release

The selected request ID and anything below will be compressed.

What is happening behind the scene is “After the compression, the F fact table contains no more data.
Instead, the compressed data now appear in the E fact table.”

No comments:

Blog Archive