cancel
Showing results for 
Search instead for 
Did you mean: 

Partitioning Inventory Cube

Former Member
0 Kudos
74

Hi,

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

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

former_member184494
Active Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Regards.

Charly