Skip to Content
author's profile photo Former Member
Former Member

Partitioning Inventory Cube

Hi,

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

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Oct 26, 2009 at 12:58 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

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

  • author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2009 at 07:14 PM

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

    Regards.

    Charly

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.