I need to create a usefull app to build offline cubes.
My first phase was just to create a cube, so I use the "CREATE GLOBAL CUBE" statement.
The second was to allow the user to select which dimenstions and measures to be included, and I'm successfully using the "CREATE LOCAL CUBE" statement.
Now I want to take it a step further and allow the user to tinker around to limit the size of the cube.
I vaguely remember playing with a trial application a year ago or so that allow the user to limit the size of the
cube....how I cannot recall.
If any, what options are there in the mdx ddl?
Any ideas, suggestions?
Also, if someone need code or stuff on the first two issues I got right, just shout, and I'll post it. But sure that's simple enough for you guru's!
Thanx in Advance!