Cube Compression Behaviour

[Former Member]

Hello All.

If I have a load done (just 1 request) in a cube, adn I run a compression for that cube, will all records with the same characterisitcs values will be added to 1 record?

Thnaks and regards,

Alfonso.

[Former Member · Accepted solution]

Hello,

IN one single request, anyway the same char related combinations are combined and summarised.

compression of one and only one available request should not make any change in the summarised values.

Hope it helps..

thanks,

[Former Member · Accepted solution]

Hello Aby.

Should I understand then, that all my records will be summarized for all keyfigures when all chars are the same?

Regards,

Alfonso.

[edwin_harpino · Accepted solution]

hi Alfonso,

yes,

http://help.sap.com/saphelp_nw2004s/helpdata/en/ca/aa6437e7a4080ee10000009b38f842/frameset.htm

but not sure with single request compression since normally we do compression after certain amount of requests, you can check E table,

/bic/e[infocubename] or /bi0/e[infocubename],

check total records if reduce from added record.

hope this helps.

[Former Member · Accepted solution]

Hi,

if u r doing compression For single req, the same char related combinations are summarised...

Each Data load process in an InfoCube is uniquely identified using a request ID.

Using request ID's can have the effect that a data record with the same content (where all characters are the same except for the request ID) appears more than once in the fact table. The result is an unnecessary increase in the data volume, which reduces performance in Reporting, During compression, the compressed data records are moved from F fact table to E fact Table. And new records are stored in teh F- fact table.

-Shreya

[Former Member]

Hi Alfonso,

Each data load process within an InfoCube is uniquely identified using a request ID. Data records are aggregated within a request. So compression will not have any effect if it is just one request.

When you compress the multiple request ID's in an InfoCube,the request ID is set to null. Data records with the same dimension keys are aggregated. This is the advantage of Compression.

I hope the answer was helpful.

Regards,

Sumana

[Former Member]

Done some testing,

normally, if you compress 1 request, there is no reduction of records in /BIC/eXXXXXXX.

But, depends on your Cube I guess!

regards

Torsten

Message was edited by: Torsten