Skip to Main Content
MDX Solutions: With Microsoft® SQL Server™ Analysis Services 2005 and Hyperion® Essbase, Second Edition
book

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
March 2006
Intermediate to advanced content levelIntermediate to advanced
744 pages
16h 7m
English
Wiley
Content preview from MDX Solutions: With Microsoft® SQL Server™ Analysis Services 2005 and Hyperion® Essbase, Second Edition

Chapter 8. Using the Attribute Data Model of Microsoft Analysis Services

So far you have learned the MDX language and the various ways of creating and applying calculations to solve common business problems. MDX was first introduced by Microsoft along with SQL Server Analysis Services 7.0 in 1998. Since its introduction several OLAP providers such as Hyperion Essbase and SAP have started supporting MDX. Microsoft's Analysis Services 2005 supports the MDX per the OLE DB for OLAP specification, along with its own extensions to enrich the data retrieval from the multidimensional database within Analysis Services 2005.

Analysis Services 2005 combines the power of OLAP with a fair amount of flexibility of relational reporting, providing a unified model to the end users. In this chapter, you will first learn how Analysis Services 2005 is able to provide you the functionality of relational and OLAP databaseswith the help of Unified Dimensional Model (UDM). We will discuss how a multidimensional database is modeled using the dimensions and cubes within Analysis Services. The calculation model of Analysis Services 2005 is primarily based on attributes, which are entities that are part of the dimensions, and the relationships between the attributes. Analysis Services 2005 introduces MDX scripts, an entity that holds all the calculations that are to be applied to a cube. You will be introduced to the attribute-based calculation model, and MDX scripts in this chapter. You will learn properties ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Professional SQL Server™ Analysis Services 2005 with MDX

Professional SQL Server™ Analysis Services 2005 with MDX

Sivakumar Harinath, Stephen R. Quinn
Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

Sivakumar Harinath, Matt Carroll, Sethu Meenakshisundaram, Robert Zare, Denny Guang-Yeu Lee
Microsoft® SQL Server™ 2008 Analysis Services Unleashed

Microsoft® SQL Server™ 2008 Analysis Services Unleashed

Irina Gorbach, Alexander Berger, Edward Melomed

Publisher Resources

ISBN: 9780471748083Purchase book