Partitioning and compression

[Former Member]

What happens during the partition of an InfoCube? I mean, how will the data be stored after partition? Is it possible to do compression after a cube is partitioned?

[former_member188975 · Accepted solution]

Hi Pooja,

Search the BI forums for posts by "Pizzaman"...you will get a great deal of excellent info on partitioning and compression.

Hope this helps...

[Former Member]

Once the F table is compressed ,data goes from F table to E table then u can no longer see data in F table.

When u partition ,u do it for the infocube based on two characteristics OCALMONTH or OFISCPER.The fact table is created on the database with one of the number of partitions corresponding to the value range. You can set the value range yourself.

see the below link for partitioning.

Hope it helps.

http://help.sap.com/saphelp_sem40bw/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

[Former Member]

Pooja,

Partition as in logical partition of the cube is just a logical way of grouping the data along the line of a particular infoobject to make data access faster (say by the fiscal year). So data is still stored in the cube but you will have different areas within in (logically) where data pertaining to a particular partition is stored. (Analogous to the logical partition on a hard disk)

Compression relates to the aggregates created on the cube which in a way have similar logic to partitions and I think a compression can still be done after partition though would would want to get a 2nd opinion on that.

Doniv