SAP Knowledge Base Article - Public

3684762 - Data Validation for Datasphere Modeling

Symptom

  • Errors when previewing a view or analytic model
  • Less data shown in the preview
  • Issues with any type of Hierarchies
  • Text / Description is not shown or partially shown
  • Similar can be observed in SAC

Environment

  • SAP Datasphere
  • SAP Analytics Cloud

Reproducing the Issue

  • Preview in Analytic Model or
  • Selecting Hierarchy in Analytic Model or
  • Data Viewer in Graphical View or
  • Data Viewer in SQL View or
  • Running a SAC Story or Analyzer

Cause

There could be a variety of reasons for the issue you're experiencing. This KBA offers and shows how to use "Data Validation" tool to troubleshoot such issues.

Resolution

  1. Go to your fact, source or affected view
  2. Click on Data Viewer
  3. Click on Data Validation
  4. Go through the results. Click on Details to see the detailed error message
  5. Correct the errors or inconsistencies
  6. Data Validation Status shows the latest status. 

Our recommendation is to run "Data Validation" regularly to ensure that there is no any inconsistency or error, which can cause problems later.

Another example:

See Also

Help Portal - Collect Unassigned Fact Records for Inclusion in Aggregations and Visualizations

Keywords

validation, data validation, viewer, preview, hierarchy, inconsistency, hierarchy, invalid node, csn , KBA , DS-MD-VIW , Views , DS-MD-AM , Analytic Model , DS-MD-TAB , Tables , DS-MD , Modeling (Data Builder) , How To

Product

SAP Datasphere all versions

Attachments

Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png