SAP Knowledge Base Article - Public

3209017 - Different measures can not be set to different scales in one chart in SAP Analytics Cloud (SAC)

Symptom

When setting different scales for different account measures selected in the measure input control in a specific chart in SAC, the scale of these different measures will all be displayed as the last scale value set for these account measures, regardless of what scales have been set for these measures before

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Create a bar chart containing Account Measure A, Account Measure B and Account Measure C in a story in SAC
  2. Add a measure input control for this chart
  3. Select Account Measure A, Account Measure B and Account Measure C into the measure input control
  4. In the styling panel, set Thousand Scale for Account Measure A, Million Scale for Account Measure B and Billion Scale for Account Measure C in order
  5. Observe that when switching among different account measures in the measure input control in this bar chart, the scales of Account Measure A, Account Measure B and Account Measure C will all become Billion

Cause

  • This is by design behaviour as of SAP Analytics Cloud
  • The Scale setting is a single property applied to a specific chart globally
    The last scale value set for the measure will override the scale previously set for measures in this specific chart
  • Changes of the value in the styling panel are written to story definition
  • Settings available in the styling panel are meant for the entire chart instead of any particular measure/dimension bindings

Resolution

Workarounds:

Option 1. Choose "auto-formatted" on the styling panel
Option 2. Modify the underlying model of the story, and set the scaling format for each account measure in this model, then create a chart in the story based on this model without modifying the Scale in the "Styling Panel"
Option 3. Use dual axis chart e.g Combination Column & Line and bind 1 measure to column axis and another to line axis, then they have ability to set different scales for each in the styling panel

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, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud , KBA , LOD-ANA-DES-CHART , SAP Analytics Cloud core charting , Problem

Product

SAP Analytics Cloud 1.0