We've got a datawarehouse, with data marts for each client. On each client's db are a few cubes. I need to write some kind of vb app, that allow the user to browse to a cube, then allow them to create a "sub-set" of the "live" cube on their local machine.
Figured out DSO well enough to let users browse servers, databases, cubes, process cubes etc.
Figured that I need to use PivotTable service and/or ADO MD to let the the user create a local cube.
Thing is, I do not want to "hard code" any mdx or whatever in the application. The application should allow the user to select what measures, dimensions, etc, to be included in the local cube.

Any help will be most appreciated.