Version 2021

Opening the VLDB Properties Editor

You can change the VLDB settings for different levels using the VLDB Properties Editor. (Levels are described in Order of Precedence.) You can access the VLDB Properties Editor in several ways, depending on what level of MicroStrategy objects you want to impact with your VLDB property changes. For example, you can apply a setting to an entire database instance, or only to a single report associated with that database instance.

When you access the VLDB Properties Editor for a database instance, you see the most complete set of the VLDB properties. However, not all properties are available at the database instance level. The rest of the access methods have a limited number of properties available depending on which properties are supported for the selected object/level.

The table below describes every way to access the VLDB Properties Editor:

To set VLDB properties at this level Open the VLDB Properties Editor this way

Attribute

In the Attribute Editor, on the Tools menu, select VLDB Properties.

Database Instance

Choose one of the following:

In the Database Instance Manager, right-click the database instance you want to modify VLDB settings for, and choose VLDB Properties.
In the Project Configuration Editor, select the Database Instances: SQL data warehouses or the Database Instances: MDX data warehouses category, then click VLDB Properties.

Metric

In the Metric Editor, on the Tools menu, point to Advanced Settings, and then select VLDB Properties.

Project

In the Project Configuration Editor, expand Project definition, and select Advanced. In the Project-Level VLDB settings area, click Configure.

Report (or Intelligent Cube)

In the Report Editor or Report Viewer, on the Data menu, select VLDB Properties. This is also the location in which you can access the VLDB Properties Editor for Intelligent Cubes.

Template

In the Template Editor, on the Data menu, select VLDB Properties.

Transformation

In the Transformation Editor, on the Tools menu, select VLDB Properties. Only one property (Transformation Role Processing) is available at this level. All other VLDB properties must be accessed from one of the other levels listed in this table.

  • Only a single property, called Unbalanced or Ragged Hierarchy, can be set at the hierarchy level. This property's purpose and instructions to set it are described in the MDX Cube Reporting Help.
  • VLDB properties exist at the filter level and the function level, but they are not accessible through the VLDB Properties Editor.
  • All VLDB properties at the DBMS level are used for initialization and debugging only. You cannot modify a VLDB property at the DBMS level.

The VLDB Properties Editor has the following areas:

  • VLDB Settings list: Shows the list of folders into which the VLDB properties are grouped. Expand a folder to see the individual properties. The settings listed depend on the level at which the VLDB Properties Editor was accessed (see the table above). For example, if you access the VLDB Properties Editor from the project level, you only see Analytical Engine properties.
  • Options and Parameters box: Where you set or change the parameters that affect the SQL syntax.
  • SQL preview box: (Only appears for VLDB properties that directly impact the SQL statement.) Shows a sample SQL statement and how it changes when you edit a property.

When you change a property from its default, a check mark appears on the folder in which the property is located and on the property itself.