SAP Knowledge Base Article - Public

3403901 - Fail to load line chart after selecting unbooked data in SAP Analytics Cloud(SAC)

Symptom

  • The line chart display normally with booked data, but failed to load if selecting unbooked data.
  • Error message: Readmode settings are inconsistent: dimension 'XXX' is requested with read mode 'BookedAndSpaceAndState' but at least one dimension on axis 'Rows' is requested with read mode 'Master'. Dimension 'XXX' will also be returned with read mode 'Master'.

Environment

SAP Analytics Cloud (SAC) 2023.16.16

Reproducing the Issue

  1. Login to SAC and go to the affected chart.
  2. Open the designer and see that dimension 'XXX' on X-axis, measures 'A' on Y-axis.
  3. Check "Unbooked Data" for the dimension 'XXX'.
  4. The chart will be loading for several minutes, then an error occurs: Readmode settings are inconsistent: dimension 'XXX' is requested with read mode 'BookedAndSpaceAndState' but at least one dimension on axis 'Rows' is requested with read mode 'Master'. Dimension 'XXX' will also be returned with read mode 'Master'.

Cause

  • Measure 'A'  is a restricted measure, which has dimension 'XXX' as context.
  • So the setting "unbooked data" is conflicted with the requirements from restricted measure calculation, which lead to this error.

Resolution

Uncheck 'unbooked data'.

See Also

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, story, widget, chart, line chart, unbooked data, restricted measure, calculation. , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud all versions