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