SAP Knowledge Base Article - Public

3491322 - SAC Hierarchy based on Import Connection shows Data Mismatch between

Symptom

Created a Hierarchy object in a Model based on Import connection.
Parent Child hierarchy based on our understanding of objects from the backend query.

All we can see is the data mismatch while creating a story in which we used Bar chart and pulled the hierarchy based dimension. The hierarchy drill looks ok but data validation shows discrepancy.

 

Environment

SAP ANALYTICS CLOUD

Reproducing the Issue

  1. Login to tenant
  2. Open the story with a Bar Chart created based on the Model with Hierarchy
  3. Compare the results in the Bar Chart with Data preview in BW 
  4. Similar results mismatch when we drill-down on the Bar Chart

Cause

The issue is Currently under Investigation by Development

Resolution

The issue is Currently under Investigation by Development

Keywords

KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud all versions