SAP Knowledge Base Article - Public

2717911 - Dimensions are not available when creating restricted measures in SAP Analytics Cloud (SAC)

Symptom

  • When creating restricted measures in SAP Analytics Cloud Stories, some of the dimensions are not avalailable.
  • This behavior appears, only in case of SAP Business Warehouse (BW) live data models.

Environment

  • SAP Analytics Cloud 2018.19.3
  • SAP Business Warehouse

Reproducing the Issue

  1. Logon to SAP Analytics Cloud.
  2. Create a new Story.
  3. Add a chart and select a BW live data model as the datasource.
  4. Add a new calculation.
  5. Select restricted measure.
  6. Select the required measure.
  7. Notice that some of the dimensions are not available when trying to select the dimensions.

Cause

  • It is not possible to create restricted measures in SAC from key figures already restricted in BW.

Resolution

  • The behavior is by design.
  • Dimension restrictions need to be managed either BW or SAC side, it is not possible to combine.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, key, figure, BW, , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0