Cube Partition???

[gotike]

Hi,
I have couple of clarification..
i have a cube above 2GB,i would like to split it,if anybody can tell the steps to split the cube..and after completion of splitting, i would like to see the result of all cubes data in to the one report,how to do ..??please any advices..

Thanx in advance..

Regards
Reddy.

 

[GJParker]

As far as I know you can't create one report from multiple cubes, If you want to split the cube look in the help on how to create Cube Groups.

HTH

Gary Parker
Systems Support Analyst
Manchester, England

 

[flex13]

Cubes larger than 2Gb can be built ... there have been a couple of threads on this topic search on multifilecubethreshold.

Basically, this setting in the trnsfrmr.ini file is set to 0 (meaning stop building at 2GB). This value should be set based on the number of consolidated records that are being read in to the cube. Then, this number should be divided by three which is a good starting point.

For example, 28,000,000 rows creates a cube of just under 2GB. You know that an extra 2.1 million rows have just been added and you're sure that the cube size will increase past teh 2GB limit. Set the multifilecubethreshold to 10,000,000.

This will create an mdc file and FOUR mdp files because you now have 30,100,000 rows of data and your setting was 10,000,000. So one mdp file will equate to the amount of rows equal to the multifilecubethreshold value.

All reports created from the original MDC will still work AS LONG AS the mdp files are in the same directory as the main mdc file.

 

[flex13]

If you are already using this technique and you are in fact inquiring about a different way to split the cubes into smaller cubes, then cube groups is teh way to go ... but you won't be able to report off of them like they were one cube.