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.”

SAP BW Tips by : Mani Sri

Fast Links:
Information about InfoCube Compression
Infocube Compression

Get help for your SAP BW problems
Do you have a SAP BW Question?

SAP Books
SAP Business Warehouse, Functional, Basis Administration and ABAP Programming Reference Books

SAP BW Tips
SAP BW Tips and Business Information Warehouse Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.sap-img.com