Private Onsite | 2 Days Classroom
Advanced MDX – Performance, Optimization, and the MDX Script
Enhance your knowledge of MDX functions and sets and learn effective use of the MDX Script. Explore strategies to monitor and optimize MDX.
During this course you will learn how to analyze and optimize the performance of MDX calculations, you will understand the situations where MDX can be modified to improve performance and those situations where other strategies must be used, you will learn how to re-write MDX calculations so that they will work with specific client applications, how to use all the MDX functions, the MDX Script to create complex business logic and how to create complex Date Calculation Hierarchies.
Main Benefits
Analyze and optimize the performance of MDX calculations.
Re-write MDX calculations so that they will work with specific client applications.
Use the MDX Script to create complex business logic.
Use all the MDX functions.
Use the MDX Script to create complex Date Calculation Hierarchies.
Upcoming Dates
There are no scheduled classes for this course at the moment. Please, send us an information request to find out more.
Course Delivery Options
Private Onsite.
2 Days Classroom.
The course will take place in a classroom with no more than 20 students in order to maintain a good level of interactivity.
Pre-requisites
NOTE: This is an Advanced MDX course. If a student is unfamiliar with MDX before they take this course, they are unlikely to receive much benefit from it.
After this Course
Module 1: Advanced Functions
LAB: Using LinkMember and recursion
Module 2: Advanced Set Topics
LAB: Referencing the Set on the Rows
Module 3: The MDX Scripting
LAB: Writing MDX Script Code
Module 4: Building a Time Calculation Hierarchy
LAB: Adding New Time Calculations
Module 5: MDX Performance Analysis
LAB: Examining Cache Behavior
Module 6: Enabling Block Computation
LAB: Fixing Calculations to Use Block Computation
Lab 05 B: Actions and Perspectives
Lab 05 C: Translations
Module 7: Other Calculation Performance Strategies
LAB: Using MDX Calculation Performance Enhancement Strategies
Module 8: Using Subselects and Subcubes
LAB: Using MDX Calculation Performance Enhancement Strategies
Module 8: Storage Modes, Aggregation Designs, and Proactive Caching
Lab 08 A: Aggregations and Partitions
Lab 08 B: Partitions in the Tabular Model
Module 9: Security
Lab 09 A: Security in Multidimensional Models
Lab 09 B: Security in Tabular Models
Module 10: Scalability and Performance
Lab 10: Query Troubleshooting
Module 11: Basic Maintenance and administration
Lab 11 B: Deploying SSAS Databases (Tabular Model)
Do you want more info about these courses?