SAP Knowledge Base Article - Public

3085897 - Chart currency information disappears when using measures from different time period if data blending is defined in SAP Analytics Cloud (SAC)


  • The currency information in the chart will lost after adding measures from different time period.
  • Issue was reproduced when data source was defined with Data Blending: BW query (Direct Live Connection) linked with an Microsoft Excel File (File upload) within a story.
  • Matched Dimensions linked on: ID


  • SAP Analytics Cloud (Enterprise) 2021.07.17

Reproducing the Issue

  1. Login to SAC.
  2. Create a story based on SAP BW query with direct live connection.
  3. Insert a chart e.g. Bar/Column.
  4. Add Linked Models - select a dimension for linking the models
  5. In the Matched Dimensions - Link on: ID and Set.
  6. Add dimension from the Excel file.
  7. Add measure values from the primary SAP BW query:
    • dimension with metric ACT (-> year 2021)
    • dimension with metric PY (-> year 2020).
  8. Currency information will lost and not displayed in the chart.



This issue is currently under investigation by development.


This issue is currently under investigation by development.

See Also

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


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 , KBA , LOD-ANA-DES-COR , SAC Core story functionality - widgets, geo, design, etc , Problem


SAP Analytics Cloud 1.0