I would like to experiment with creating a Dundas Data Cube from my Analysis Services Data Connector (MS SSAS) but I am running into some things that I am finding troublesome.
My Analysis Services database has over 200 dimensions and 200 measures, how can I add all of these at once? Do I seriously have to drag over 400 members one at a time into the ‘Selected x box’ ?
These all default to a way they would look in an mdx query, i.e. ‘[Measures].[Total Sales]’. How can I make them default to how they look when they are selected from the cube, i.e. ‘Total Sales’. I hope that I do not have to rename all of these.
How do I add multiple levels of a dimension/hierarchy? I have some hierarchies that go down several levels but I can only drag one level from the hierarchy into the “selected dimensions” area. It won’t let me drag in a second one.