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
If Possible Flattened the dimensions.
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