Skip to Content

Re-Partitioning a cube

I have a cube that has 0CALMONTH data as follows, but no partitioning identified.

SQL

my_date # Fact Records

200705 3

200712 3

200805 1

200808 2

200810 4

200811 28

200812 8

200901 20

200902 18

200904 16

200905 22

200906 29

200907 58

200908 67

200909 99

200910 57

200911 47

200912 63

201001 82

201002 193

201003 186

201004 237

201005 125

201006 392

201007 606

201008 1218

201009 1552

201010 2175

201011 3573

201012 2649

201101 5538

201102 12616

201103 34800

201104 91420

201105 1678650

201106 3118399

201107 1190442

201108 406521

201109 81457

201110 31661

201111 9305

201112 3561

201201 3933

201202 2439

201203 2694

201204 2098

201205 1980

201206 1747

<snip>

In fact this actually goes to year 2025.

My question then is do I partition by 0calmonth and create that many partitions?

I am partitioning using RSA1 -> Add'l Functions -> Repartitioning

Mike

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jun 29, 2011 at 10:41 PM

    Micheal,

    You could partition the same but I think I vaguely remember that SAP BW restricts the number of partitions that you can create.

    If BW does not allow you to create that many partitions - you could create partitions for the most used data and have the rest going into the max and min partitions - but then if you are extracting data from this cube - this approach would not work because if the max and min parttions increase in size considerably - then even if you specify a month which needs to be pulled - the exttract from the cube will do a full scan on the fact table.

    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.