SQL Generation and Data Processing: VLDB Properties

VLDB properties allow you to customize the SQL that MicroStrategy generates, and determine how data is processed by the Analytical Engine. You can configure properties such as SQL join types, SQL inserts, table creation, Cartesian join evaluation, check for null values, and so on.

VLDB properties can provide support for unique configurations and optimize performance in special reporting and analysis scenarios. You can use the VLDB Properties Editor to alter the syntax or behavior of a SQL statement and take advantage of unique, database-specific optimizations. You can also alter how the Analytical Engine processes data in certain situations, such as subtotals with consolidations and sorting null values.

Each VLDB property has two or more VLDB settings which are the different options available for a VLDB property. For example, the Metric Join Type VLDB property has two VLDB settings, Inner Join and Outer Join.

Some of the qualities that make VLDB properties valuable are:

• Complete database support: VLDB properties allow you to easily incorporate and take advantage of new database platforms and versions.
• Optimization: You can take advantage of database-specific settings to further enhance the performance of queries.
• Flexibility: VLDB properties are available at multiple levels so that the SQL generated for one report, for example, can be manipulated separately from the SQL generated for another, similar report. For a diagram, see Order of Precedence.

Modifying any VLDB property should be performed with caution only after understanding the effects of the VLDB settings you want to apply. A given VLDB setting can support or optimize one system setup, but the same setting can cause performance issues or errors for other systems. Use this manual to learn about the VLDB properties before modifying any default settings.

This section includes the following information: