In this three-day course, participants gain a thorough understanding of the most powerful capabilities of MicroStrategy Desktop. Students learn how to create numerous types of advanced metrics, including level metrics, non-aggregatable metrics, and transformation metrics.
Students also discover ways to create different types of advanced filters, including attribute-to-attribute filters, joint element lists, and dynamic date filters. Students then learn about consolidations, custom groups, and advanced MicroStrategy OLAP Services™ features, such as Intelligent Cubes and derived elements.
The course concludes with report data options, drill maps, and other report developer tools, such as Find and Replace and the Project Documentation Wizard. Students gain hands-on practice through a series of exercises.
Topics:
Module 1: Introduction to Advanced Reporting
Module 2: Advanced metrics
- Level metrics
- Non-aggregatable metrics
- Transformation metrics
- Base formulas
- Conditional metrics
- Nested metrics
- Advanced subtotals
Module 3: Advanced filters
- Attribute-to-attribute filtering
- Joint element list
- Dynamic dates
- Pass through functions
- Qualify on metrics
- Relationship filters
