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, Web PDF
ISBN: 978-1-84628-182-2
Verlag: Springer
Format: PDF
Kopierschutz: 1 - PDF Watermark
OLAP (On-Line Analytical Processing) is the most powerful business intelligence tool currently available and Microsoft's Analysis Manager makes OLAP cubes incredibly easy to build and deploy. However, the real power of OLAP lies in its ability to help solve real-life business problems; to release that power users need to use the language that controls the cubes and allows them to be queried. That language is MDX (Multi Dimensional eXpressions). Fast Track to MDX provides all the necessary background needed to write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop MDX skills to the point where they can solve real business problems.
Zielgruppe
Professional/practitioner
Autoren/Hrsg.
Weitere Infos & Material
Readme.doc — definitions you need to know.- How MDX is used.- MDX queries.- MDX syntax.- MDX expressions.- Navigating the hierarchy.- Snapshot data analysis.- Moving averages.- Filters.- Setting the default member.- Member properties and dimension security.- Distinct Count.- Parent-Child dimensions.- Advanced data modeling — Custom Order, Custom Rollup, Custom Members.- Further advanced data modeling techniques.- Actions.- Server side color coding.- More about querying.
