August 9, 2012 at 3:37 am
Hi,
this is my first post here - but you forum has helped my many times regarding various issues with SSAS.
My problem is the following:
I have a pretty big cube, which uses data from various fact tables, thus I have various measure groups.
Some of those measure groups - which have a few dimensions in common but also differ in other dimensions used - belong to the same "topic". Let's have an example:
Measure Group 1: Car sales
Dimensions: Date, Country, model type (Porsche 911, Porsche Boxter, Porsche Cayenne etc.), engine type (diesel, gas, etc.), external_color, interior_color
Measures: units sold, sales value
Measure Group 2: Accessoire sales
Dimensions: Date, Country, accessoire type (bag, shirt, keychain etc.), material (leather, plastic etc.)
Measures: units sold, sales value
Measure Group 3: Production Costs
Dimensions: Date, account, factory (engine plant MEX, chassis plant USA, etc.)
Measures: Expenses in EUR
Measure Group 4: Marketing Costs
Dimensions: Date, account, type of expense (print ad, tv ad, radio ad, event sponsorship etc.)
Measures: Expenses in EUR
Now what we see is that there are two measure groups (#1 and #2), which have a different set of dimensions. That is because you cannot differentiate the sold cars by the material used or the accessoire type, but they are grouped by engine type or model name. On the other hand, you cannot group accessoire sales by engine types of by the model name, but you want to know which material is used and what type of accessoire it is (is it a bag, is it a shirt, is it a keychain, etc.). Also note that the number of dimensions is different in those two measure groups.
Imaging having 50 of those measure groups. Now what I want to do (but can't figure out how) is to "group the measure groups", e.g. I want to bring the various measure groups regarding sales together, bring the various measure groups regarding costs together etc. I started playing around with Displayfolders, which work just fine EXCEPT for the fact that they are created within a particular measure groups.
Is there any way to group measure groups into "folders" like one can group measures into "DisplayFolders" within each measure group?
My users use Excel 2010 to access the cube and thus I'd like to have this grouping in the "Pivot Table field list" panel.
Thank you for reading - I'm looking forward to any suggestions!
Best regards from Vienna, Austria,
Wolfgang
August 23, 2012 at 12:23 am
*bounce*
Anyone knows whether this is possible or not?
Thank you,
Wolfgang
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply