search for books and compare prices
Tables of Contents for Microsoft SQL Server 2000 Analysis Services
Chapter/Section Title
Page #
Page Count
Preface
ix
Part 1 Administration Fundamentals
A Data Analysis Foundation
3
22
Understanding Data Warehousing
4
8
The Purpose of a Data Warehouse
5
1
Dimensions in Data Analysis
5
4
Hierarchies in Data Analysis
9
3
The Structure of a Data Warehouse
12
5
A Fact Table
13
1
Dimension Tables
14
2
Alternative Dimension Table Structures
16
1
Understanding Analysis Services
17
6
Conceptualizing a Cube
18
1
Analysis Services Administrator Tools
19
1
Analysis Services User Tools
20
3
Chapter Summary
23
2
Analysis Manager from 500 Feet
25
28
Previewing Analysis Manager
26
5
Explore the console tree
26
1
Explore menu commands
27
2
Explore the detail pane
29
2
Preparing to Create a Cube
31
3
Review the data warehouse structure
31
1
Create a new OLAP database
31
1
Specify a data source
32
2
Designing a Cube by Using the Cube Wizard
34
12
Select the fact table and the measures
34
2
Create a dimension from a star schema table
36
2
Create a dimension from snowflake schema tables
38
3
Create a dimension from a parent-child table
41
2
Create a dimension from a date column
43
2
Name and save a cube
45
1
Processing and Browsing a Cube
46
5
Process a cube
46
2
Browse cube data
48
3
Chapter Summary
51
2
Dimension and Cube Editors
53
48
Start the lesson
54
1
Working with a Standard Star Schema Dimension
54
6
Use the Dimension Editor
54
2
Choose how to sort members of a level
56
2
Add additional levels in the Dimension Editor
58
1
Create a ragged hierarchy
59
1
Working with a Standard Snowflake Dimension
60
11
Create a dimension from multiple tables
60
1
Allow duplicate names in a dimension
61
3
Create an expression for a member name
64
2
Specify a default member
66
3
Create a detail-level member property
69
1
Create a summary-level member property
69
2
Working with Time Dimensions
71
8
Create a calendar date hierarchy
71
2
Set Time dimension properties
73
3
Create a fiscal date hierarchy
76
3
Working with a Cube
79
4
Use the Cube Editor
79
2
Add a shared dimension by using the Cube Editor
81
2
Working with Measures in a Cube
83
9
Create a derived measure
83
2
Specify the aggregation function for a measure
85
2
Create a calculated measure
87
2
Create a measure that calculates an average
89
2
Hide an internal measure
91
1
Working with a Parent-Child Dimension
92
6
Create a parent-child dimension
92
1
Allow data for non-leaf-level members
93
2
Manage levels within a parent-child dimension
95
3
Chapter Summary
98
3
Advanced Dimensions and Cubes
101
36
Start the lesson
101
1
Creating a Finance Cube
102
6
Create an initial finance cube
102
2
Refine the formatting of an Account dimension
104
1
Use custom rollup operators
105
1
Use a custom member formula
106
2
Creating an Internet Tracking Cube
108
8
Create a cube from a measureless fact table
108
1
Enable drillthrough for a cube
109
1
Handle a very large, flat dimension
110
2
Link days to a Time dimension
112
2
Calculate distinct counts for a dimension
114
2
Creating a Forecast Cube
116
11
Create a Scenario dimension
117
1
Create a cube from an empty fact table
118
1
Use only the top levels of a shared dimension
119
2
Enable write-back for a cube
121
1
Write values back to a cube temporarily
122
1
Write values back to a cube permanently
123
3
Dynamically add members to a dimension
126
1
Creating Virtual Cubes
127
8
Remove dimensions and measures from a cube
128
3
Combine measures from multiple cubes
131
1
Create calculated members in a virtual cube
132
3
Chapter Summary
135
2
Office 2000 Analysis Components
137
44
Start the lesson
138
1
Creating an Excel PivotTable Report
138
15
Establish a link from Excel
138
4
Browse a cube by using a PivotTable report
142
2
Drill down to member children in a PivotTable report
144
2
Add multiple dimensions to a single axis
146
2
Format a PivotTable report
148
2
Create a PivotChart report
150
3
Creating an Office PivotTable List
153
15
Create a PivotTable list from a PivotTable report
153
2
Manipulate levels in a PivotTable list
155
4
Manipulate subtotals in a PivotTable list
159
3
Design a PivotTable list in FrontPage
162
4
Create a restricted PivotTable list
166
2
Creating a Local Cube
168
9
Create a local cube from a PivotTable report
168
3
Create a local cube from a relational data source
171
2
Use the OLAP Cube Wizard to create a cube file
173
4
Chapter Summary
177
4
Part 2 Multidimensional Expressions
MDX Values
181
32
Start the lesson
181
1
Creating Simple MDX Expressions
182
14
Create a calculated member using constant values
182
3
Display the name of the current member
185
3
Display the ancestor of a current member
188
2
Test a member name against a string
190
2
Display a member property for a member
192
1
Use an external function to convert a string to a number
193
3
Retrieving Values from Cells
196
7
Retrieve a value by specifying a single dimension
196
2
Retrieve a value by specifying two or more dimensions
198
5
Calculating Relative Contribution
203
4
Calculate contribution as a percent of the total
203
2
Calculate contribution as a percent of a parent
205
1
Check for an empty member
206
1
Comparing Values over Time
207
5
Calculate growth from the previous period
207
2
Calculate growth from a parallel period
209
3
Chapter Summary
212
1
MDX Sets
213
32
Start the lesson
213
1
Preparing to Create MDX Queries
214
8
Use a PivotTable list to understand MDX terms
214
4
Use the MDX Sample application
218
4
Creating Basic MDX Queries
222
7
Create a minimal MDX query
222
1
Add a set to the column axis
223
1
Add a set to a second axis
224
2
Create a set by using explicit member names
226
1
Put two dimensions on one axis
227
2
Creating Calculations by Using Aggregation Functions
229
13
Create a calculated member as part of a query
229
1
Create a calculated member of a nonmeasure dimension
230
4
Create a cumulative total
234
4
Calculate discount dollars by using a member function
238
4
Chapter Summary
242
3
Part 3 Advanced Administration
Storage Optimization
245
24
Start the lesson
246
1
Specifying Options for Optimizing Storage
246
11
Understand Analysis server storage modes
246
1
Choose the correct storage mode
247
1
Understand Analysis server aggregations
248
1
Inspect aggregations for a single dimension
249
3
Inspect aggregations for two dimensions
252
3
Use the Storage Design Wizard
255
2
Managing the Pool of Potential Aggregations
257
9
Preparing for Usage-Based Optimization
257
1
Populate the usage log
258
1
View usage analysis reports
259
2
Use the Usage-Based Optimization Wizard
261
2
Consider the server cache
263
1
Manipulate the query log
264
1
Manage aggregations for a dimension
264
2
Chapter Summary
266
3
Processing Optimization
269
40
Start the lesson
269
1
Understanding OLAP Processing
270
13
How the Analysis Server Processes a Dimension
270
2
How the Analysis Server Processes a Cube
272
2
Watch the server process a database
274
2
Changing Data in a Warehouse
276
1
Set storage options for sample cubes
277
1
Browse data before updating the warehouse
278
1
Change the database data source
279
1
Browse data after updating the warehouse
280
3
Managing OLAP Processing
283
8
Incrementally update a dimension
283
3
Incrementally update a cube
286
1
Watch an incremental update double-count values
287
1
Incrementally update by using a separate fact table
288
2
Incrementally update by using a filter
290
1
Working with Partitions
291
11
Use a data slice when creating a new partition
293
4
Use a filter when editing an existing partition
297
2
Merge two partitions into one
299
3
Automating the Processing of a Database
302
6
Create a DTS package
303
1
Create an Analysis Services Processing Task
304
1
Send an e-mail message if the task fails
305
1
Save and schedule a DTS package
306
2
Chapter Summary
308
1
Dimension Optimization
309
22
Start the lesson
309
1
Optimizing Dimensions in a Cube
310
8
Process a cube without optimizations
310
1
Assign unique keys to the leaf levels of a dimension
311
3
Optimize a cube
314
4
Creating Virtual Dimensions
318
12
Create a single-level virtual dimension
318
3
Creating a Hierarchy in a Virtual Dimension
321
1
Add aggregations to the Sales cube
321
2
Create a Fiscal Year member property
323
1
Create a Fiscal Quarter member property
324
1
Create a Time Fiscal virtual dimension
324
2
Adjust the sort order of virtual dimension members
326
2
Test the performance with aggregations
328
2
Chapter Summary
330
1
Security
331
30
Start the lesson
331
1
Creating Security Roles
332
12
Create sample users and groups
332
3
Create a role for all users
335
3
Create roles at the database level
338
3
Manage database roles
341
3
Applying Security to a Dimension
344
11
Fully restrict a dimension
344
3
Restrict the members of a dimension
347
2
Control visual totals for a dimension
349
4
Create a default member for a role in a dimension
353
2
Applying Cell-Level Security to a Cube
355
4
Prevent values in cells from being read
355
3
Allow users to write to cells
358
1
Chapter Summary
359
2
Index
361