SAP Knowledge Base Article - Public

3325959 - No data is displayed when adding a dimension to a table/chart using a model based on a Salesforce Data Source

Symptom

When crating a story using a model based on a Salesforce Data Source, no data is displayed once a dimension is added to a table or chart. 

Environment

SAP Analytics Cloud 2023.2.11

Reproducing the Issue

  1. Access the SAP Analytics Cloud tenant 
  2. Create or access a model based on a Salesforce Data Source 
  3. Create a Story/Analytic Application and add either a table or a chart 
  4. Add Measures and Account Dimensions to your widget, if required
    Note that the widget is populated with data
  5. Add any Dimension
    Note that no data is displayed 

Cause

The Hierarchy of the dimension in use is empty. Thus, if you add this dimension to your Story, the empty hierarchy is added resulting in no data visible in the widgets.

Resolution

  • Go to the dimension in the Builder Panel and change the presentation view to Flat Presentation.

Otherwise, try to adjust the Hierarchy with the Parent Node and Members and re-test the scenario.

See Also

Keywords

SAP Analytics Cloud, SAC Salesforce, Model, Story, Table, Chart, Measures, Account, Generic, Dimension, no Data, Empty. , KBA , LOD-ANA-ML , SAC Modelling , How To

Product

SAP Analytics Cloud all versions