Skip to Content
0
Jun 29, 2011 at 10:11 PM

Re-Partitioning a cube

16 Views

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