Collect Unassigned Fact Records for Inclusion in Aggregations and Visualizations

The Missing Hierarchy Nodes data validation rule can generate files to create an unassigned hierarchy node to collect records in a fact that point to nodes that are missing from an associated Hierarchy with Directory, and make them available for inclusion in your aggregations and visualizations.

Open your entity with a semantic usage of fact.
Run the data validation including the Missing Hierarchy Nodes rule.
Click Details to open the dialog and then click Download CSN to download the .csn file containing the generated views.
Go to the Data Builder start page and click  (Import) Import Objects from CSN/JSON File to import the generated views into your space.

For more information, see Importing Objects from a CSN/JSON File.

Review and modify the generated views as appropriate:

View	Purpose
Business Name: Validation Results for Missing Hierarchy Nodes in `<hierarchy>` Technical Name: `<hierarchy>`_VALIDATION	Lists missing nodes identified by the rule. [optional] Open this view and use the Data Viewer to see the list of missing nodes (see Viewing Object Data).
Business Name: Unassigned Nodes in `<hierarchy>` Technical Name: `<hierarchy>`_MISSING	Places these missing records in a root `Unassigned` hierarchy node. [optional] To improve performance, you can persist the data in this view (see Persist Data in a Graphical or SQL View). We strongly recommend that you schedule persistence regularly to ensure that recent records are assigned promptly.
Business Name: Enhanced `<hierarchy>` Technical Name: `<hierarchy>`_ENHANCED	Unions the records for your hierarchy with directory and those that are `Unassigned` (and collected in `<hierarchy>`_MISSING) to ensure that all records canbe included in your aggregations and visualizations. [required] You must modify your dimension, which has an association to `<hierarchy>`, and ensure that it points instead to this view.
Business Name: Enhanced `<dimension>` Technical Name: `<dimension>`_ENHANCED	[if `<dimension>` is shared from another space] Encapsulates the shared dimension and replaces it as the link between the fact and the hierarchy. [required] You must modify your fact so that its association points to this dimension.

View

Purpose

Business Name: Validation Results for Missing Hierarchy Nodes in <hierarchy>

Technical Name: <hierarchy>_VALIDATION

Lists missing nodes identified by the rule.

[optional] Open this view and use the Data Viewer to see the list of missing nodes (see Viewing Object Data).

Business Name: Unassigned Nodes in <hierarchy>

Technical Name: <hierarchy>_MISSING

Places these missing records in a root Unassigned hierarchy node.

[optional] To improve performance, you can persist the data in this view (see Persist Data in a Graphical or SQL View). We strongly recommend that you schedule persistence regularly to ensure that recent records are assigned promptly.

Business Name: Enhanced <hierarchy>

Technical Name: <hierarchy>_ENHANCED

Unions the records for your hierarchy with directory and those that are Unassigned (and collected in <hierarchy>_MISSING) to ensure that all records canbe included in your aggregations and visualizations.

[required] You must modify your dimension, which has an association to <hierarchy>, and ensure that it points instead to this view.

Business Name: Enhanced <dimension>

Technical Name: <dimension>_ENHANCED

[if <dimension> is shared from another space] Encapsulates the shared dimension and replaces it as the link between the fact and the hierarchy.

[required] You must modify your fact so that its association points to this dimension.

Save and deploy your changes.
Review your analytic model or SAP Analytics Cloud story to ensure that your aggregations and visualizations now display correctly with a suitable Unassigned category.

Note

If, over time, you modify your fact records to point to existing hierarchy nodes (or provide new hierarchy nodes for the values in your fact records), then the value of your unassigned node will be reduced accordingly.