Loading

Limitations of Null Values in Dimensions in CRM Analytics

Data pubblicazione: Jun 14, 2023
Descrizione


Note: This article is not related to Null Handling in Measures. With "Null Measure Handling" enabled, Measures can support Null values. In the following examples, Null Measure Handling is enabled. For more information about this feature, see Handle Null Numeric Value.

 

Currently, Null values in Dimensions are not completely supported.

 

Dataset structure with Null Dimensions

When a record has no value (is Null) for a Dimension, that record does not exist in the index for that Dimension.

Example Source Data:

IDNameAmount
a01Alice 
a02 40
a03Carol30


In this example, the individual indexes will be populated as follows:


ID.dim

IndexValue
1a01
2a02
3a03


Name.dim

IndexValue
1Alice
3Carol


Amount.mea

IndexValue
1-
240
330


Note: All 3 records are present in the completely populated ID Dimension as well as the Amount Measure (contains a Null value). The Null value in the Name Dimension is not present.

 

Grouping, filtering, and ordering on a Dimension

When grouping, filtering, or ordering (sorting) on a Dimension, only values present in that Dimension will be included in the results. This means that records with a Null value in a Dimension will not appear in the results if that Dimension is used to group, filter, or order the query.

Performing any of these actions on the Name Dimension would result in the following output data:
 
IDName ^Amount
a01Alice-
a03Carol30

This can result in a perceived discrepancy in row count, "missing" data, and unexpected results for any calculations performed on the grouped, filtered, or ordered data.
 
Risoluzione


Recommendations

 
  • Add a defaultValue to dataflow or schema
Use the "defaultValue" override in the dataflow sfdcDigest Transformation  or external data schema to specify a value for the field in records where it is Null.
  • Use an ungrouped, unfiltered, or unordered lens or step for calculations
If displaying the value on a dashboard, include a widget powered by an ungrouped, unfiltered, or unordered version of the lens. This will allow the widget calculations to display the value including the Null records. Faceting will allow the calculations to adjust if selections are applied.
Numero articolo Knowledge

000381712

 
Caricamento
Salesforce Help | Article