search for books and compare prices
Tables of Contents for Microsoft Olap Solutions
Chapter/Section Title
Page #
Page Count
Acknowledgments
xii
Foreword
xiii
Introduction
xvi
OLAP Structures and OLAP Services
1
26
General OLAP Structures
1
2
Introduction to Multidimensional Domain Structure Diagrams
3
1
OLAP Services Dimensions
3
12
Overview: The Structure of a Dimension
4
2
Multiple Dimensional Hierarchies in OLAP Services
6
3
The All Level and All Member
9
1
Members in a Dimension
10
1
Member Properties (Attributes)
11
1
Dimension Types
12
2
Time versus Regular Dimensions and Levels
14
1
Cubes and Measures
15
8
Regular Cubes
17
2
Virtual Cubes
19
3
Similarities and Differences between Cube Measures and Level Properties
22
1
Formulas
23
1
Linkage of Structures to RDBMS Schemata
24
2
Summary
26
1
Microsoft OLAP Services Architecture
27
20
Core Component Architecture and Platforms
28
2
Storage and Query Processing Architecture
30
15
Fundamentals of Stored Aggregates in OLAP Services
30
2
Calculation Architecture
32
2
Partition Architecture, Storage, and Querying
34
6
Definitions, Storage, and Processing
40
3
Dimensions and Processing
43
1
Cubes and Processing
43
2
Client/Server Processing
45
1
Summary
46
1
Database Design Basics
47
34
Steps for Creating an OLAP Services Database
48
1
Know Your Data and What You're Trying to Understand
48
20
The Required Data Must Exist and Aggregate with SUM, COUNT, MIN, or MAX Functions
50
1
Dimension Data Must Exist in Appropriate Table Form
51
5
Desired Dimension Data Must Exist
56
3
Dimensions Must Have Members at All Aggregate Levels
59
6
All Facts in a Table Must Relate to the Same Level of Members in a Dimension
65
3
Section Summary
68
1
Design OLAP Services Dimensions and Cubes
68
11
Dimension and Cube Names
69
1
Shared versus Private Dimensions
69
1
Multiple Hierarchies
70
2
Member Properties
72
1
Virtual Dimensions
73
1
Virtual Cubes
74
2
Partitions
76
3
Summary
79
2
The Basics of Building a Database with the OLAP Manager
81
48
Creating an OLAP Services Database
81
2
Creating Dimensions: Levels, Members, and Hierarchies
83
23
Creating a Standard Dimension
84
8
Editing Dimension Properties
92
8
Creating a Time Dimension
100
2
Member Properties
102
1
Processing Dimensions
102
2
Virtual Dimensions
104
2
Creating a Cube: Bringing It All Together
106
21
Selecting a Fact Table, Measures and Dimensions
106
3
Refining the Cube Definition
109
7
Creating Calculated Members and/or Private Dimensions
116
3
Designing Aggregations and Processing the Cube
119
2
Adding Partitions
121
6
Summary
127
2
Introduction to MDX
129
36
The Very Basics
131
2
How Metadata Entities Are Named in MDX
133
3
Delimited and Multi-part Names
133
1
Names versus Unique Names
134
2
The MDX Data Model
136
4
Data Model: Tuples and Sets
136
3
Data Model: Queries
139
1
Simple MDX Construction
140
6
,(comma) and: (colon)
140
1
.Members
141
1
CrossJoin
142
2
Filter
144
1
Order
145
1
Dimensional Calculations as Calculated Members
146
8
Calculated Members and WITH Sections in Queries
148
1
Formula Precedence
149
5
Named Sets
154
2
MDX Queries: More Detail
156
8
Axis Numbering and Ordering
156
1
Removing Empty Slices from a Query Axis
157
1
Querying for Member Properties
158
2
WITH Section
160
1
Querying Cell Properties
160
1
MDX Cube Slicers
161
3
What MDX Sorely Lacks
164
1
Summary
164
1
Context and Data in MDX Evaluation
165
16
Cell Context and Resolution Order in Queries
166
5
Cell Context in Set Functions
169
1
Infinite Recursion: A Frequent ``Gotcha'' Related to Calculation Context
169
2
Non-Data: Invalid Numbers, NULLs, and Invalid Members
171
6
Invalid Calculations: Divide by Zero and Numerical Errors
171
1
Semantics of Empty Cells
172
2
Invalid Locations
174
3
Precedence of Cell Properties with Calculated Members
177
2
Precedence of Display Formatting with Calculated Members
177
1
Data Types from Calculated Cells
178
1
Summary
179
2
MDX Function and Operator Reference
181
36
Numerical Calculations
182
7
Aggregation Functions
182
7
Comparison, Logical, and Conditional Operators
189
18
Specifying Tuples and Sets
190
4
Basic Set-related Operators
194
5
Data-based Filtering of Sets
199
2
Ordering Sets
201
4
Measure Values
205
1
Property Values
206
1
OLAP Metadata
207
2
String and Name Functions
209
2
Array Creation
211
1
MDX DDL Statements
211
5
Summary
216
1
MDX Dimensional Reference Functions
217
28
Context-free and Context-dependent Sets of Members
218
15
Context-free Individual Members
220
1
Same Level
221
6
Referencing Lower Levels
227
5
Higher Levels
232
1
MDX Drill-related Functions
233
10
Summary
243
2
MDX Application Topics
245
36
Commonly Required Straightforward Expressions
246
11
Ratios between Levels in a Hierarchy
247
1
Averages
248
2
Different Aggregations along Different Dimensions
250
2
Moving Aggregates within a Level
252
1
Filling in Blanks
253
4
Advanced Manipulations: Queries and Expressions
257
15
Ratios between Levels for Members in a Report
257
5
Hierarchical Sorting That Skips Levels in the Hierarchy
262
1
Including All Tuples with Tied Ranking in Sets
263
1
Pareto Analysis and Cumulative Sums
264
5
One Formula Calculating Different Things in Different Places
269
2
Logical Aggregations (For Any, For Each, For None)
271
1
A Sample Analysis
272
8
Summary
280
1
Maintaining Applications
281
26
The Nature of Change
282
6
Synchronizing Updates with the Data Source
282
3
Including New Data
285
1
Changing Existing Data
285
3
Implementing Change
288
9
Dimensions
289
1
Cubes
290
7
Techniques for Managing Change
297
5
Correction Transactions
298
4
Design Changes
302
3
Summary
305
2
Optimization
307
28
Data Source
308
2
Indices
309
1
Views versus Tables
309
1
Dimension and Cube Design
310
5
Table Joins
310
1
Key Data Type and Size
310
1
Unique Members
311
1
Member Key Columns in the Cube Definition
312
1
Level Aggregations
313
1
Calculated Members
314
1
OLAP Storage Options
315
3
Aggregations
318
11
How OLAP Services Determines Aggregations
319
4
Optimizing Aggregations
323
6
Query Processing
329
1
MDX Expressions
330
4
Server Settings
334
1
Summary
334
1
Advanced Cube and Database Design
335
22
Line-item Dimensions
336
8
Regular Dimension and Measures Dimension
337
2
Representing Line Items
339
5
Closing the Loop: Writing Analytical Results Back to an RDBMS
344
8
OLE DB and Tabular Results for MDX Queries
344
3
DTS Basics
347
3
Example Query and Flow
350
2
Masking the Application Ranges of Measures in Virtual Cubes
352
4
Summary
356
1
Security
357
10
Security Architecture
357
2
Authentication
359
1
Designing for Security
359
5
Hiding Measures
360
1
Hiding Levels of Detail
361
1
Hiding Slices
362
2
Implementing Security
364
2
Summary
366
1
Extending OLAP Services through External Functions
367
14
Overview of Using External Functions with MDX
368
1
Argument and Return-type Details
369
5
Passing Arrays of Values to External Functions
370
4
MDX Functions for Use with External Functions
374
3
SetToStr, TupleToStr
375
1
Members, StrToSet, StrToTuple
375
2
Additional Considerations for External Functions
377
1
Loading and Using Libraries
378
2
USE LIBRARY Syntax
378
1
Loading the Library
379
1
Disambiguating Duplicated Function Names
379
1
Summary
380
1
Tutorial 1: Health Care Benefits Analysis
381
54
Analyze Needs
382
1
Current Workflow
382
1
Desired Model
382
1
Analyze Data
383
12
Identify Dimensions
383
1
Identify Measures
384
2
Identify Calculations
386
1
Identify/Create Dimension Data Source Tables/Views
387
6
Identify/Create Fact Tables/Views
393
2
Design Dimensions and Cubes
395
7
Create a Database
402
1
Select a Data Source
402
6
Build Dimensions
408
8
Building Single-table Dimensions
409
4
Building Multiple-table Dimensions
413
2
Building a Time Dimension
415
1
Processing the Dimensions
416
1
Create the Base Cubes
416
10
The Population Cube
417
7
The Utilization Cube
424
1
The Claims Paid Cube
424
1
The Claims Submitted Cube
425
1
Build the Virtual Benefits Cube
426
8
Creating the Virtual Cube
427
1
Adding Calculated Members
428
6
Summary
434
1
Tutorial 2: Grocery Store Frequent Shopper Program
435
48
Analyze Needs
436
1
Current Workflow
436
1
Desired Model
436
1
Analyze Data
437
9
Identify Dimensions
437
2
Identify Measures
439
1
Identify Calculations
440
2
Identify/Create Dimension Data Source Tables/Views
442
3
Identify/Create Fact Tables/Views
445
1
Design Dimensions and Cubes
446
8
Create a Database
454
4
Select a Data Source
458
1
Build Dimensions
459
9
Building Single-table Dimensions
459
4
Building Multiple-table Dimensions
463
2
Building the Time Dimension
465
2
Processing the Dimensions
467
1
Create the Base Cubes
468
10
The Sales Cube
468
6
The Visits Cube
474
2
The Customer Count Cube
476
1
The Product Count Cube
477
1
Build the Virtual Frequent Shopper Cube
478
3
Creating the Virtual Cube
481
1
Summary
481
2
Appendix A: Intrinsic Cell and Member Properties
483
4
Appendix B: Glossary
487
6
Appendix C: About the CD-ROM
493
4
Index
497