Skip to Content
avatar image
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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

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

    Regards,

    Marc

    SAP NetWeaver RIG, US BI

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

      Regards,

      Troy