Query Generation

No PostgreSQL specific customizations were made for this feature.

The SQL engine is the component that generates the SQL for a report in MicroStrategy project.

The SQL engine has two major concerns when generating SQL. The first is to understand what a report is asking for and how to find data for it. The second is to generate the optimal SQL statement to return the desired data.

SQL statements are generated according to the specifics of the template, filter, and metric objects associated with that pass. A simple SQL pass has several separate component clauses (SELECT, FROM, WHERE, GROUP BY) that are “filled in” by the template, filter, and metric definitions. 

MicroStrategy has several VLDB settings on different levels including Project, DBMS, DB Role, Report, Template, and Metric. Many of these settings will take effect on query generation. VLDB settings are updated via Developer. Some important VLDB settings will be introduced in later sections, such as Sub Query and SQL Server Query Execution (and Pre\Post).

VLDB Setting via Developer (DB Role level)

To generate a correct and optimal SQL query, MicroStrategy also defines default patterns specifically, including functions and syntax supported, which can be found in DATABASE.PDS.

Functions

VLDB Syntax Setting