MDX - means Multi Dimensional Expression, a key to all advanced functionality in Analysis Server
Books to read - to get more idea about OLAP DM(Dimensional Modelling)
1) Data warehouse Toolkit, A complete guide for DM - Ralf Kimbal, Willy Pubs
2) MDX - MDX Solutions for SQL2005 and HyperonSpace - George Spafford, Willy pubs
Slice - Members of One Dimension
Dice - Members of more than one dimension display
A cube can have up to 128 Dimensions
A MDX can have up to 64 axes
While fetching the level Name can't precede the member Name
KPI - KeyPerformanceIndicator - Why they are at back end, they are supposed to be at front face as they are similar to Dashboard.
Note: These exists from quite a long time in the industry, but are new from Microsoft's perspective and for the first time they have included
them in their product
Microsoft Dashboard Manager or KPI Manager
Scorecard - is the information that is WRT other information
drill through- Is another feature that every OLAP tool should support.
MOLAP - Is the +vesFastest storage ModeRetrival is Fast,-ve is Latency
ROLAP - will only create the Cube and the data is still there in RDBMS
HOLAP - Details data is still there in RDBMS, where as Aggregates are stored at Dimensional Model, in other words,in Cubes
Some of the SQL Server and BI collection of books:
SQL SERVER 2005 and BI Books Collections
1) MDX Solutions: with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase, Second Edition by George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi
2) Applied Microsoft Analysis Services 2005 : And Microsoft Business Intelligence Platform by Teo Lachev.
3) Professional SQL Server 2005 Integration Services by Brian Knight
4) The Microsoft Data Warehouse Toolkit : With SQL Server 2005 and the Microsoft Business Intelligence Toolset by Joy Mundy
5) Microsoft SQL Server 2005 Reporting Services 2005 by Brian Larson
6) The Rational Guide to Scripting SQL Server 2005 Integration Services Beta Preview (Rational Guides) by Donald Farmer (got this one a couple of weeks ago - great book!)
