Chapter 10: Writing a New ScriptMDX Scripting


The world is a stage and most of us are desperately unrehearsed.
—Sean O'Casey, Playwright

Overview

We have already used some basic MDX script expressions to create calculated members in Chapter 8 and to define Key Performance Indicators (KPIs) and Actions in Chapter 9. To complete these tasks, we used the basics of MDX scripting. You probably need to employ more complex MDX scripts to meet the needs of your organization. Thus, we have Chapter 10.

In this chapter, we work to get a handle on the power of MDX scripts. We see how they can be used to perform powerful analysis on your organization's information. In addition to data analysis, we also use MDX scripts to set up security restrictions on a cube.




Delivering Business Intelligence with Microsoft SQL Server 2005
Delivering Business Intelligence with Microsoft SQL Server 2005: Utilize Microsofts Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A
ISBN: 0072260904
EAN: 2147483647
Year: 2007
Pages: 112
Authors: Brian Larson

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net