This two-day course explores the logic and behavior of the MicroStrategy engine. Students learn how the engine generates Structured Query Language (SQL) for a variety of reporting scenarios. After an overview of the MicroStrategy engine architecture, students focus on the SQL generated by the MicroStrategy engine for common reporting requirements such as advanced metrics, set qualification filters, and analytical engine features.

Students also explore ways to tune and optimize the MicroStrategy engine through the use of VLDB (Very Large Database) properties. Students learn what VLDB properties are and how they can be defined at different levels of a MicroStrategy project. Students review the most commonly used VLDB properties in certain categories, such as indexing, joins, pre/post statements, query optimizations, and tables.

Throughout the course, students gain hands-on practice via a series of exercises.


Module 1: Introduction to the MicroStrategy engine

  • The MicroStrategy engine at a glance
  • SQL generation process

Module 2: Basic optimizations

  • Multipass SQL
  • Composing optimized SQL
  • Intermediate tables

Module 3: Templates

  • Attributes
  • Hierarchies
  • Consolidations
  • Custom groups
  • Custom group banding

Module 4: Metrics

  • Level metrics
  • Order of resolution: hierarchies in metrics
  • Nonaggregatable metrics
  • Conditional metrics
  • Transformation metrics
  • Nested metrics
  • Metric join types

Module 5: Filters

  • Attribute qualification
  • Set qualification

Module 6: The analytical engine

  • Report limits
  • Subtotals
  • Compound metrics
  • Evaluation order
  • Analytical functions

Module 7: Introduction to VLDB properties

  • VLDB properties defined
  • The VLDB properties editor

Module 8: VLDB Properties

  • Governing VLDB properties
  • Indexing VLDB properties
  • Joins VLDB properties
  • Pre/Post statements VLDB properties
  • Query optimizations VLDB properties
  • Select/insert VLDB properties
  • Tables VLDB properties
  • Dynamic sourcing VLDB properties
Print Friendly, PDF & Email