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

SAP BW Tips by : Mani Sri

Fast Links:
Information about InfoCube Compression
Infocube Compression

Get help for your SAP BW problems
SAP BW Forum - 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

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

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.