What is MDX? MDX or Multi Dimensional Expression Language is a query language for relational databases. This course will explain the power of MDX Members, functions, and structures allowing end users to slice and dice data quickly and easily by business rules. It will also show how MDX integrates with reporting services to populate charts and reports.
Lesson 1:
- What Is MDX?
- Cube Structure
- Demo: Dimension Structure
- Demo: Queries
- Members, Tuples, and Sets
- Member Data
- Tuple
- Set
- MDX Functions
- Members Function
- Members Showing All
- Members Not Showing All
- Non Empty
- Demo: Members Function
- Demo: Sets of Tuples.
Lesson 2:
- Cross Join
- Time Intelligence
- Navigating Hierarchy
- Demo: Members & Cross Join
- Demo: Time Intelligence
- Managing MDX Calculations
- Add to Cube
- Demo: WITH Member
- Demo: Add Measure to Cube
- Reporting a Cube
- Reporting
- Reporting Services
- Demo: Reporting with Excel
- Demo: Reporting with SSRS
- Demo: Reporting with SSRS Cont..
