Home > SQL Server > MDX: Queries and Scripts

MDX: Queries and Scripts
for SQL Server & Oracle's Hyperion Essbase

Course Code:	SQSMDX
Duration:	3 days
Level:	Beginner-to-intermediate
Platforms:	Microsoft SQL Server 2005/2008 and Oracle's Hyperion Essbase 9.
Audience:	OLAP cube developers/administrators and SQL Server Reporting Services (SSRS) developers.
Prerequisites:	Completion of our course SQL Server 2005/2008 Analysis Services or equivalent knowledge.
Summary:	This course is designed for OLAP (cube) developers and administrators and SQL Server Reporting Services (SSRS) developers. Emphasis is placed on using MDX queries and scripts to: Return data to client applications from OLAP cubes Format query results Perform cube design tasks, such as defining calculated members, named sets, scoped assignments and Key Performance Indicators (KPIs) Perform administrative tasks such as cell security
Objectives:	Upon completion of this presentation, the delegate should be able to use MDX queries to extract information from OLAP cubes and use MDX scripts to create calculated members, KPIs, actions, etc.
Format:	Hands-on (about 60%).
Detailed Outline

Course Schedule