SAP Knowledge Base Article - Public

2962011 - Stacked bar chart assigns colors incorrectly when not using unbooked data in SAP Analytics Cloud (SAC)

Symptom

The following behavioroccurs in SAP Analytics Cloud (SAC):

  • Stacked bar chart assigns colors incorrectly when not using unbooked data in SAP Analytics Cloud (SAC) with Live Data Connection against HANA DB.

Environment

  • SAP Analytics Cloud (Enterprise) 2020.14.11

Reproducing the Issue

  1. Create a Story using Live Data Connection against HANA Database
  2. Insert a Stacked Column Chart with unbooked data - the colors are applied correctly
  3. Insert a Stacked Column Chart with not unbooked data - the colors are applied incorrectly, starting from the second

Cause

  • There is unbooked data in the chart that gets a flag "showInLegend" set to false but still is assigned a color which makes it appear that the first color was skipped over.
  • This is cleared up when unbooked data is shown because it's no longer hidden.

Resolution

  1. Edit the story
  2. Click examine in the toolbar in the display category
  3. Click on the chart to view its data
  4. Create an exclude filter on the hidden data series

See Also

Your feedback is important to help us improve our knowledge base.

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,  color, chart, unbooked, booked , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , Problem

Product

SAP Analytics Cloud 1.0