Disconnect physical measure groups from metadata transferred to clients
Measure groups are inflexible in terms of grouping related measures into logical collections. It is very rarely the case that related measure neatly fall into the same fact table in the data source view. This is confusing for end users doing ad-hoc analysis and reporting against a SSAS dimensional models through most end user tools (such as Excel pivot tables or Report Builder 2.0). To them measures often seem to fall into arbitrary "categories" with no logic behind the distribution of measures.
Upvotes: 13<=-=Aug 13 2009 2:51AM=-=>
…so basically you are talking about a “display folder” property for measures?! Good idea…<=-=Aug 13 2009 5:25AM=-=>
Yes pretty much :)<=-=Aug 26 2009 10:59AM=-=>
Thank you for this feedback. We will consider your suggestion for an upcoming release of SQL Server.