Partitioning Inventory Cube

[Former Member]

Hi,

is recommended partitioning the Inventory Cube with characteristic 0calmonth having it NonCumulative KF ?

Thanks.

[former_member184494 · Accepted solution]

The invrntory cube anyway can be compressed with a marker update - and usually the cube is left untouched with active data in the F Table...

So esentially if you are updating the marker when you compress the cube - I guess it should be okay to partition the cube also....

[Former Member · Accepted solution]

Hi Arun,

you are guess or sure ? If my partition, initially is for five year, after the five year what happens? Do I have to empty the cube and to recreate a new partition?

Thanks.

[Former Member · Accepted solution]

it's possible to perform compression on Inventory cubes. In referring to your question, what happens after 5 years, the remaining data is put into 1 big partion i.e. data from 6th year onwards pushed into 1 big partition. Here are the alternate options:

- Build separate cubes restricting to other characteristics Ex: Plant

- Build Multi-provider combining various base cubes

Performance would be much faster with the above approach.

Hope this helps.

Bala

[former_member184494 · Accepted solution]

When you partition a cube for five years - 7 partitions get created - one extra partition on each size ( lower + upper ) for instance if you have partitions from 2000 to 2004 - two extra partitions get created which will be:

1 for any value less than 2000 and 1 for any value greater than 2004...

Accordingly if you want to increase the number of partitions then you can use the repartitioning toolbox to increase the number of partitions without dropping data...

[Former Member]

Hi, thanks the same to everybody. I have already resolved.

Regards.

Charly