MicroStrategy ONE

Defining metric-specific VLDB properties

Steps to set VLDB properties for a metric

VLDB (Very Large DataBase) properties allow you to alter the syntax of a SQL statement and take advantage of the unique, database-specific optimizations. Metric-specific VLDB properties that can be set at the metric level are listed below.

  • Integer Constant in Metric determines whether to add a ".0" after an integer.

  • Metric Join Type defines the default action for joining the metric to other metrics. For more information, see Setting join types for metrics.

  • Null Check indicates how to handle arithmetic operations with null values.

  • Zero Check indicates how to handle division by zero or when to check for zeros in the denominator during division calculations.

  • Null Checking for Analytical Engine determines whether a null value is interpreted as zero when the Analytical Engine performs calculations.

  • Subtotal Dimensionality Aware enables subtotaling based on the dimensionality of a metric.

You can set additional VLDB properties at other levels, such as the report and project levels. For information on how the levels work together and more details about the metric-specific VLDB properties, see the VLDB Properties chapter of the Advanced Reporting Help. For details on all the VLDB properties, see VLDB Properties chapter of the System Administration Help.

Prerequisite

This procedure assumes you have created a metric. For instructions, see Creating metrics.

To define VLDB properties for a metric

  1. Open an existing metric in the Metric Editor. (How?)

  2. On the Tools menu, point to Advanced Settings, then choose VLDB Properties. The VLDB Properties Editor opens.

  3. Expand the folder containing the VLDB property to change:

    • Null Checking for Analytical Engine and Subtotal Dimensionality Aware are located in the Analytical Engine folder.

    • Integer Constant in Metric, Metric Join Type, Null Check, and Zero Check are located in the Metrics folder.

  4. Select the VLDB property to change. The current values for that setting are displayed and, if applicable, the corresponding SQL code.

  5. To change the property, clear the Use default inherited value check box, then select the correct option.

    For information on the various properties, refer to the VLDB Properties chapter of the Advanced Reporting Help.

  6. When you have made all the changes to the VLDB properties, click Save and Close. You are returned to the Metric Editor.

  7. Save the metric.