Cube Spilt procedure

[raviB]

Hi All,

One the reporting cube is very big in our EP model- we would like to spilt the cube to curb the cube performance problem- could anyone share the best practices on this?
Regards,
Ravi

[Amritha]

If Possible Flattened the dimensions.

[StuartS]

Hello

Three options

1, Split up dimensions and use several D-Cubes - as suggested by previous poster.
2, Use Access Tables with NO DATA for cut down
3, You mentioned reporting D-Cube, Publish data and use Data Manager to create a mini warehouse.  Then cut down dimensions and D-Cube size.

Regards

Stuart