Contents
Multidimensional Modeling (Adventure Works Tutorial) ................................................................................ 5
Analysis Services Tutorial Scenario ........................................................................................................................... 7
Install Sample Data and Projects for the Analysis Services Multidimensional Modeling Tutorial.... 9
Lesson 1: Defining a Data Source View within an Analysis Services Project.......................................... 13
Creating an Analysis Services Project ............................................................................................................... 14
Defining a Data Source .......................................................................................................................................... 14
Defining a Data Source View ............................................................................................................................... 16
Modifying Default Table Names ......................................................................................................................... 18
Lesson 2: Defining and Deploying a Cube ......................................................................................................... 19
Defining a Dimension ............................................................................................................................................. 20
Defining a Cube ........................................................................................................................................................ 22
Adding Attributes to Dimensions ...................................................................................................................... 23
Reviewing Cube and Dimension Properties ................................................................................................... 25
Deploying an Analysis Services Project............................................................................................................ 27
Browsing the Cube................................................................................................................................................... 29
Lesson 3: Modifying Measures, Attributes and Hierarchies ......................................................................... 30
Modifying Measures ............................................................................................................................................... 31
Modifying the Customer Dimension................................................................................................................. 32
Modifying the Product Dimension .................................................................................................................... 38
Modifying the Date Dimension........................................................................................................................... 42
Browsing the Deployed Cube .............................................................................................................................. 50
Lesson 4: Defining Advanced Attribute and Dimension Properties .......................................................... 51
Using a Modified Version of the Analysis Services Tutorial Project ...................................................... 52
Defining Parent Attribute Properties in a Parent-Child Hierarchy ......................................................... 56
Automatically Grouping Attribute Members ................................................................................................. 60
Hiding and Disabling Attribute Hierarchies ................................................................................................... 65
Sorting Attribute Members Based on a Secondary Attribute ................................................................. 71
Specifying Attribute Relationships Between Attributes in a User-Defined Hierarchy .................... 76
Defining the Unknown Member and Null Processing Properties .......................................................... 82
Lesson 5: Defining Relationships Between Dimensions and Measure Groups ..................................... 89
Defining a Referenced Relationship .................................................................................................................. 90
Defining a Fact Relationship ................................................................................................................................ 95
Defining a Many-to-Many Relationship .......................................................................................................... 99
Defining Dimension Granularity within a Measure Group...................................................................... 106
Lesson 6: Defining Calculations ............................................................................................................................ 116
Defining Calculated Members ........................................................................................................................... 118
评论3