Whitehorn / Zare / Pasumansky Fast Track to MDX

2. Auflage 2006
ISBN: 978-1-84628-182-2
Verlag: Springer
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 310 Seiten

Shows users and developers how to use MDX to effectively to provide relevant business information.

Autoren/Hrsg.

Whitehorn, Mark

Zare, Robert

Pasumansky, Mosha

Inhaltsverzeichnis

1;Contents;6
2;Foreword;10
3;Introduction;13
3.1;Why should you read this book?;13
3.2;What is MDX?;13
3.3;Who should read this book?;14
3.4;Who are we?;14
3.5;Bugs (sorry – readware anomalies);16
3.6;Acknowledgements;16
3.7;What do we cover?;17
3.8;What we don’t cover;17
3.9;Disclaimer;18
3.10;The ‘d’ word;19
3.11;What’s on the CD-ROM;19
4;Chapter 1 Readme.doc – definitions you need to know;22
4.1;Sample data;22
4.2;Italics;22
4.3;Introduction;22
4.4;Dimensions, measures, members and cells;23
4.5;Cranking up the complexity;27
4.6;Hierarchies and aggregations;29
4.7;Levels;31
4.8;Naming conventions;32
4.9;Tuples and sets;34
4.10;Exploring the differences between tuples and sets;39
4.11;Tuples don’t have to use a member from every dimension;44
4.12;Tuples and hierarchies;45
4.13;Sometimes measures behave like dimensions;45
4.14;Tuples revisited;46
4.15;Sets revisited;46
4.16;Measures revisited;46
4.17;Member properties;47
4.18;Summary;48
5;Chapter 2 How MDX is used;50
5.1;MDX queries;52
5.2;MDX expressions;52
6;Chapter 3 MDX queries;56
6.1;Using MDX for queries;57
6.2;SELECT, FROM, ON COLUMNS, ON ROWS;60
6.3;WHERE;71
6.4;Slicer;73
6.5;Summary;73
7;Chapter 4 MDX syntax;74
7.1;Brackets, braces and the odd dot and comma;74
7.2;Brackets [ ] – Dimension names and member names;74
7.3;Dots . – Separators;75
7.4;Braces ( ) – Tuples;75
7.5;Curly braces { } – Sets;76
8;Chapter 5 MDX expressions;79
8.1;Recap of cell naming;80
8.2;The concept of the current cell;82
8.3;Relative cell referencing;83
8.4;The practicalities – how to look at the data in a cube;86
8.5;1 Comparing values;90
8.6;3 Calculating values to date;98
8.6.1;The practicalities – how to create a calculated member;93
8.7;2 Comparing values between years;95
8.8;Summary;99
9;Chapter 6 Navigating the hierarchy;101
9.1;Children;103
9.2;Parent;104
9.3;Nesting functions;105
9.4;Outside the limits;106
9.5;Reality check;106
9.6;Descendants;111
9.7;Reality check;114
9.8;Ancestor;115
9.9;Siblings;116
9.10;Cousin;117
9.11;Summary;117
10;Chapter 7 Snapshot data analysis;120
10.1;The general problem;121
10.2;The general solution;122
10.3;The specific requirements;122
10.4;1 Average stockholding;122
10.5;2 Closing period;126
10.6;3 Maximum value;128
10.7;Why use Descendants?;129
10.8;Summary;130
11;Chapter 8 Moving averages;131
11.1;A simple moving average;132
11.2;A more complex moving average;136
11.3;Summary;139
12;Chapter 9 Filters;140
12.1;Summary;147
13;Chapter 10 Setting the default member;149
13.1;Defining a custom default member;150
13.2;Defining a different custom default member;154
13.3;Defining a fully dynamic custom default member;155
13.4;Default measures;157
13.5;Summary;158
14;Chapter 11 Member properties and dimension security;159
14.1;Member properties;159
14.2;Dimension security;161
14.3;Using member properties and dimension security;162
14.4;Summary;171
15;Chapter 12 Distinct Count;172
16;Chapter 13 Parent–Child dimensions;177
17;Chapter 14 Advanced data modeling – Custom Order, Custom Rollup, Custom Members;183
17.1;Problem 1: Custom Order – ordering of members in a hierarchy;185
17.2;Member Key Column and Member Name Column;187
17.3;Creating a custom order;189
17.4;Practical summary;193
17.5;Problem 1: Custom Order – ordering of members in a hierarchy;193
17.6;Problem 2: Custom Rollup – when the cube’s default behavior doesn’t do the right job;194
17.7;Practical summary;199
17.8;Problem 2: Custom Rollup – when the cube’s default behavior doesn’t do the right job;199
17.9;Problem 3: Custom Members – filling in missing information;199
17.10;Practical summary;203
17.11;Problem 3: Custom Members – filling in missing information;203
17.12;More about &;203
17.13;Summary;206
18;Chapter 15 Further advanced data modeling techniques;207
18.1;Write-enabled dimensions and working with data in other cubes;207
18.2;Problem 4: Write-enabled dimensions – allowing users to add a member to a dimension;208
18.3;Practical summary Problem 4: Write-enabled dimensions – allowing users to add a member to a dimension;213
18.4;Problem 5: Write-enabled dimensions – deriving values for a member using formulae;214
18.5;Practical summary;217
18.6;Problem 6: Missing data – bringing it in from other cubes;217
18.7;Practical summary;220
18.8;Summary;221
19;Chapter 16 Actions;222
20;Chapter 17 Server side color coding;233
20.1;Summary;240
21;Chapter 18 More about querying;241
21.1;Named sets;241
21.2;CROSSJOIN;242
21.3;NON EMPTY;247
21.4;From top to bottom;251
21.5;More than two dimensions – PAGES, SECTIONS, CHAPTERS;260
21.6;When logic and people collide...;262
21.7;Summary;271
21.8;Summary of the book;271
22;Appendix 1 Sample files;272
22.1;Where and what are the sample files?;272
22.2;CAB files;272
22.3;MDB files;273
22.4;TXT files;273
22.5;When to use which files;273
22.6;How to manage the files;274
22.7;Step-by-step guide to restoring an Analysis Service Database (containing one or more OLAP cubes) from a .CAB file;274
22.8;Data sources;277
23;Appendix 2 ProClarity;279
23.1;Installing ProClarity and connecting it to a cube;279
23.2;Using ProClarity’s MDX Editor;282
24;Index;283