When business users analyze data by using a multidimensional model, they use attributes primarily for grouping aggregate values in a report, or to filter values, as shown in Figure 1-12. In this example, SSAS calculates the sum of the Sales Amount With Tax measure for each State Province attribute member appearing on rows. An attribute member is a distinct value from the source column that is bound to the attribute. Figure 1-12 shows attribute members for the State Province attribute such as Alaska, California, and so on. Above the set of State Province members, you can see a filter applied based on another attribute, Sales Territory. Specifically, the filter...
- Chapter 1. Design a multidimensional business intelligence (BI) semantic model
- from Exam Ref 70-768 Developing SQL Data Models, First Edition
- Publisher: Microsoft Press
- Released: May 2017
Bookmark RJ 07/06/2017
Share this highlighthttp://www.safaribooksonline.com/a/exam-ref-70-768/7916936/