Building dimension hierarchies
Analysis Services hierarchies specify the navigation path for browsing dimension data. There are two types of hierarchies: attribute and user-defined hierarchies. For example, in the promotion dimension we just created, we immediately have a hierarchy for each attribute: Promotion Name, Start Date, End Date, English Promotion Category, English Promotion Type, Discount Percent, Minimum Quantity, and Maximum Quantity. Attribute hierarchies contain two levels.
The top-level is referred to as the All level and includes the aggregated value for all the members included in the attribute. For example, the English Promotion Category attribute hierarchy's All level will show the aggregate value of sales for all the promotion ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
