Skip to main content

Order of tables appear in the SQL generated by the MicroStrategy SQL Generation Engine

Order of tables appear in the SQL generated by the MicroStrategy SQL Generation Engine

By default, the MicroStrategy SQL Generation Engine orders the tables in the following way(FMRL):

  1. Fact Tables
  2. Metric Qualification (MQ) Tables
  3. Relationship Tables
  4. Lookup Tables

Comments

Post a Comment