MicroStrategy ONE

Disabling dynamic sourcing for metrics

Metrics are available for dynamic sourcing by default, but some data modeling conventions should be considered when using dynamic sourcing.

In general, if metrics use outer joins, accurate data can be returned to reports from Intelligent Cubes through dynamic sourcing. However, if metrics use inner joins, which is more common, you should verify that the metric data can be correctly represented through dynamic sourcing.

If the fact table that stores data for metrics includes NULL values for metric data, this can cause metrics that use inner joins to return incorrect data when dynamic sourcing is used. This scenario is uncommon. If some metrics do fit this scenario, you can disable dynamic sourcing when these metrics are used in reports and Intelligent Cubes.

You enable or disable the disable dynamic sourcing for metrics by modifying the Metric Validation VLDB property. This VLDB property has the following options:

  • Enable dynamic sourcing for metric: This is the default option for metrics, which enables metrics for dynamic sourcing.

  • Disable dynamic sourcing for metric: This option disables dynamic sourcing for metrics. This setting should be used if your metric data is not modeled to support dynamic sourcing. For example, the inclusion of NULLs in fact tables that contain your metric data can cause incorrect data to be returned to reports from Intelligent Cubes through dynamic sourcing.

You can disable dynamic sourcing for metrics individually or you can disable dynamic sourcing for all metrics within a project. For information on defining default dynamic sourcing behavior for metrics, see Accessing the dynamic sourcing VLDB properties for a project.

The procedure below describes how to disable or enable dynamic sourcing for an individual metric.

Prerequisites

  • A metric has been created in a project.

To enable or disable dynamic sourcing for a metric

  1. In MicroStrategy Developer, browse to a metric, then right-click the metric and select Edit. The metric opens in the Metric Editor.

  2. From the Tools menu, point to Advanced Settings, and then select VLDB Properties. The VLDB Properties Editor opens.

  3. From the Tools menu, select the Show Advanced Settings option if it is not already selected.

  4. In the VLDB Settings list, expand Dynamic Sourcing, and then select Metric Validation.

  5. Clear the Use default inherited value check box.

  6. Select one of the options depending on whether you want to disable or enable dynamic sourcing for a metric:

    • Enable dynamic sourcing for metric: This is the default option for metrics, which enables metrics for dynamic sourcing.

    • Disable dynamic sourcing for metric: This option disables dynamic sourcing for metrics. This setting should be used if your metric data is not modeled to support dynamic sourcing.

  7. Click Save and Close to save your changes to VLDB properties and close the VLDB Properties Editor.

  8. Click Save and Close to save the attribute and close the Attribute Editor.