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

Partitioning E Fact Table

We have some InfoCubes that have never been compressed, some with as many as 1400 F Fact table partitions. The E Fact table is empty, but not currently partitioned. I would like to partition the E Fact tables by year and or month/year before beginning the InfoCube compression. When I go to the partition option in the menu, it shows me the data columns I would like to partition on, but they are all greyed out and I can not select any of them.

I assume this has to do with the fact that the E Fact table exists already (although empty). Is there a way to partition these E Fact tables at this point? I don't think I want to have the DBAs partition it at the Oracle level, like you would with an ODS table, because the BW wants to manage the creation of new partitions going forward.

Any thoughts?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 23, 2004 at 07:07 PM

    Hello John,

    partitioning can only be changed when the InfoCube is completely empty. Since you have to compress anyway, you could create another InfoCube with the same fields and use the data mart functionality to bring the 1400 requests over to this mirror InfoCube. This process will also compress the data into one request. Then drop the original InfoCube and change the partitioning. Now you can bring back the compressed data. You will have one request in the original F-table which can be "compressed" into the E-table quickly.



    SAP NetWeaver RIG, US BI

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Just to expound on what Marc has said... after you delete the data in your first cube(before you reload it from the temp cube), you will want to set up the correct partitions via the cube maintenance (it won't be grayed out once the data is delete).



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.