Viewing VLDB properties

VLDB properties (sometimes called VLDB settings) allow you to customize the SQL that MicroStrategy generates. You can manipulate things like SQL join types, SQL inserts, table creation properties, and so on. Use the VLDB Properties Editor to change the defaults to alter the syntax of a SQL statement and take advantage of unique, database-specific optimizations.

Some of the qualities that make these properties valuable are:

• Optimization: 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, may be manipulated separately from the SQL generated from another, similar report.

• Complete database support: VLDB properties allow you to easily incorporate and take advantage of new database platforms and versions.

For additional information, refer to the Advanced Reporting Help.

You can view and change VLDB properties by selecting VLDB Properties from the Template Editor's Data menu.

To view VLDB properties

1. Open the report template in the Template Editor. See Template Editor.

2. From the Data menu, choose VLDB Properties. The VLDB Properties Editor opens.

3. Under VLDB Settings, navigate to the desired VLDB option. When selected, the options and SQL, if applicable, appear in the right side of the dialog box.

Related Topics

• About report templates

• Creating a stand-alone template

• Template Editor

• Other report-related topics