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
- Go to your fact, source or affected view
- Click on Data Viewer
- Click on Data Validation
- Go through the results. Click on Details to see the detailed error message
- Correct the errors or inconsistencies
- 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
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 |
SAP Knowledge Base Article - Public