Data Compression

[Former Member]

Dear All,

Although I know that in an infocube when we compress the data I know that the E fact table is filled which doesnot keep track of requests. But I would like to know technically what happens to the data. How is it compressed? Is it aggregated or are all the blank value records omitted?

Regards,

Ratish

ratish_prem@yahoo.com

[Former Member · Accepted solution]

Hi Ratish,

Check these:

http://www.sap-img.com/business/infocube-compression.htm

Check the explanation by Pizzaman:

Also check:

Bye

Dinesh

[Former Member]

How is it compressed?

It removes the request ids and aggregated the data. For eg:

121 sales1 600

134 sales4 200

121 sales1 500

120 sales2 300

120 sales2 000

The above reecords will be aggregated like following

sales1 1100

sales4 200

sales2 300

So it does mean it will aggergate also blank value records will be ommited.

Assigns pts if helpful

thanx

[Former Member]

Hi,

yes the data will be aggregated because if you have a record with the same characteristic values in two different requests, by removing the request ID (compressing), it will be aggregated in one record.

0 / blank values could be removed during compression if you enable the option "with zero elimination" in the collapse tab of the manage cube screen.

hope this helps...

Olivier.