Symptom
- Unable to edit Cross Calculations when adding linked model on the table in SAP Analytics Cloud (SAC)
- Unable to create Calculated dimension after adding linked model on the table in SAP Analytics Cloud
Environment
- SAP Analytics Cloud 2019.1.0
Reproducing the Issue
Scenario 1:
- Log on to SAC tenant.
- Create a story with Table on sample model [BestRunJuice_SampleModel].
- Add Linked Models to another model.
- Click Add Measures/Dimensions to add Cross Calculations from model [BestRunJuice_SampleModel].
=> The Cross Calculations shows grey and cannot be edited any more.
=> Calculated dimension buttion is also cannot be found.
Scenario 2:
- Log on to SAC tenant.
- Create a story with Table on sample model [BestRunJuice_SampleModel].
- Click Add Measures/Dimensions to add Cross Calculations from model [BestRunJuice_SampleModel].
- Add Calculation to the Cross Calculations.
- Set Filters for Cross Calculations by selecting only one value like [Account Values].
- Add Linked Models to another model.
=> In this case, Cross Calculations is still editable. - Repeat Step 5 but select all values to set Filters for Cross Calculations.
=> The Cross Calculations shows grey and cannot be edited any more.
Scenario 3:
- Log on to SAC tenant.
- Create a story with Table on sample model [BestRunJuice_SampleModel].
- Click Add Measures/Dimensions to add Cross Calculations from model [BestRunJuice_SampleModel].
- Duplicate the table and then Add Linked Models to another model on the copied table.
=> In this case, Cross Calculations is still editable. - Save the story and then re-open it in Edit mode.
=> The Cross Calculations on the copied table shows grey and cannot be edited any more.
Cause
Cross Calculations or calculated dimensions are not supported for blended tables
Resolution
This is currently by design. You can submit an enhancement request to require Cross Calculation supported for the blended on the customer influence site per SAP KBA 2424376.
See Also
- How to find User Assistance for SAP Analytics Cloud?
- Ask a question on the SAP Community!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
- 2424376 - How to create an enhancement request for SAP Analytics Cloud?
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, cross calculations, calculation, edit, unable, cannot, grayed, grey, table, link model, linked model , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem