Chapter 2
Analysis Manager from 500 Feet 25
Previewing Analysis Manager 26
Explore the console tree 46
Process a cube 46
Browse cube data 48
Chapter Summary 51
Chapter 3
Dimension and Cube Editors 53
Start the lesson 54
Working with a Standard Star Schema Dimension 54
Use the Dimension Editor 54
Choose how to sort members of a level 56
Add additional levels in the Dimension Editor 58
Create a ragged hierarchy 59
Working with a Standard Snowflake Dimension 60
Create a dimension from multiple tables 60
Allow duplicate names in a dimension 61
92
Allow data for non-leaf-level members 93
Manage levels within a parent-child dimension 95
Chapter Summary 98
Chapter 4
Advanced Dimensions and Cubes 101
Start the lesson 101
Creating a Finance Cube 102
Create an initial finance cube 101:
Refine the formatting of an Account dimension 104|
Use custom rollup operators 1051
Use a custom member formula 106j
Contents
Creating an Internet Tracking Cube 108
Create a cube from a measureless fact table 108
Enable drillthrough for a cube 109
Handle a very large, flat dimension 110
Link days to a Time dimension 112
Calculate distinct counts for a dimension 114
Creating a Forecast Cube 116
Create a Scenario dimension 117
181
Start the lesson 181
Creating Simple MDX Expressions 182
Create a calculated member using constant values 182
Display the name of the current member 185
Display the ancestor of a current member 188
Test a member name against a string 190
Display a member property for a member 192
Use an external function to convert a string to a number 193
Retrieving Values from Cells 196
Retrieve a value by specifying a single dimension 196
Retrieve a value by specifying two or more dimensions 198
Calculating Relative Contribution 203
Calculate contribution as a percent of the total 203
Calculate contribution as a percent of a parent 205
Check for an empty member ^ 206
Comparing Values over Time 207
Calculate growth from the previous period 207
Calculate growth from a parallel period 209
Chapter Summary 212
Chapter 7
MDX Sets 213
Start the lesson 213
Preparing to Create MDX Queries 214
Use a PivotTable list to understand MDX terms 214
Use the MDX Sample application 218
Creating Basic MDX Queries 222
Create a minimal MDX query 222
Add a set to the column axis 223
Add a set to a second axis 224
Create a set by using explicit member names, 226
Put two dimensions on one axis 227
Creating Calculations by Using Aggregation Functions
Цена: 300руб.
