I am building a cube with more than 14 dimensions and some of the dimensions have 24000 to 30000 categories counts.users of this cube are nesting these dimensions and performance of the cube is decreasing. is there a way or memory setting that I can change and maintain the cube performance.Please help.....
You may increase the ReadCache size and start experimanting with manual partitioning.