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

Increasing the partitions of infocube

Hi All,

The infocubes in our production environment are partitioned on the basis of 0CALMONTH. While in designing phase we partitioned it for 2 years (ie 26 partitions.

We now have to increase the number of partitions. The data is present in the cubes for past 2 years. Can anyone please suggest as to how come overcome this issue.

Note : We are on BW3.0b and database is Oracle 9i.

Thanx in advance

Ajay

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2005 at 04:39 PM

    I think you'll find copying the cube a fairly fast process. Not sure how many millions of rows you're talking about, and it is system dependent, but unless you're talking 50 million+, bet you could do it in a day.

    You can also look dropping indexes and having number range buffering on when loading to the copy will help.

    The reload from the copy to the prod cube will probably be even faster.

    Also - if you have not compressed the current prod cube, compress it first (specifying zero elimination, depending on the data, can also cut volume)and cut the time down for this process.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Don't know what release of Oracle you are running, but Look at turning on Monitoring. You can set a threshold for a percentage change in the number of rows in a table ( or partition in this case ) and it will only be analyzed when the number of rows added exceeds the threshold. That way the old partitions will not continue to be analyzed. Another option would be to develop your own analyze script/process and only analyze the active partitions.

      Do you compress the 300 million row table? use zero elimination when you do?

      IMHO, the issue of creating a multicube in this case only makes sense if:

      - the queries are regulary run across years (assuming you would create cubes by year(s)) that would take advantage of parallel processing

      - the volume of data returned to the OLAP processor is modest, since if the row count exceeds more than 30,000 rows xfered, the OLAP processor will terminate parallel processing anyway (some change to this in 3.1 SP19)

      - you don't have a boatload of queries to redo. Multicubes from the beginning doprovide some query flexibility for tolerating cube changes, but most shops don't have the time to go back and redo lots of queries that already exist.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2005 at 07:55 AM

    I would create a copy of the InfoCube, fill it from the original cube via Export DataSource, clear the original one, increase the partitions and load the data back. As far as I know there are no standard ways to expand the partitions and I would frown from meddling with table entries or DB commands.

    Best regards

    Dirk

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Ajay,

      another idea. Create a copy of the cube, partition it for the next years and join both cubes under the same MultiProvider. Then copy the queries to the MultiProvider and switch the Update rules to the new Cube. Then you fill all the data in the new cube and leave the old one as it is.

      Best regards

      Dirk

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2005 at 11:26 AM

    hi Ajay

    I have a idea

    1. Keep Cube ( say A )as it is as you can not increase partisions.

    2. Create another cube where here after data will be stored say it is as B

    3. Create Multi Cube ( C)

    4. Report will use a ABAP routine after or before depend on the business which will on the basis of selection criteria searches data in a or b .. make it to know.

    advantages

    no need to do any Cube creation or copy cube data

    disadvantges

    need to have a logic how --> look up the request or cube ..

    Who did implemented

    ex SAP PT Proto

    take care

    Kumar Vuppala

    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.