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:
Post a Comment