Strategy ONE
Metric Validation
Metric Validation is an advanced VLDB property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.
Metrics are available for dynamic sourcing by default, but there are some data modeling conventions that 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 a more common join type, 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.
You can enable and disable dynamic sourcing for metrics by modifying the Metric Validation VLDB property. This VLDB property has the following options:
- Enable dynamic sourcing for metric (default): This option 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. 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. While the definition of the VLDB property at the project level defines a default for all metrics in the project, any modifications at the metric level take precedence over the project level definition. For information on defining a project-wide dynamic sourcing strategy, see the In-memory Analytics Help.
Levels at Which You Can Set This
Project and metric