- Incorrect unit appears by default for calculated column based on two measures with different unit in SAP Analytics Cloud (SAC)
- SAP Analytics Cloud 2019.10.6
Reproducing the Issue
- Log on to SAC tenant.
- Open sample model [BestRunJuice_SampleModel].
- Set Units & Currencies for account [Quantity_Sold] as one new label, like "PC".
- Create a story with Table on this sample model to show measures [Gross_Margin] and [Quantity_sold] at least.
=> In the table, values of [Gross_Margin] will have unit as "$", and values of [Quantity_sold] will have unit as "PC".
- Add one Calculated Measure with Formula as ["BestRunJuice_SampleModel":Gross_Margin]/["BestRunJuice_SampleModel":Quantity_sold]
=> Its values are shown in the table with Unit/Currencies as "$/PC".
- Add a calculated column with similar formula as the calculated measure in step 5.
=> By default, only "PC" is shown as unit of the calculated column, instead of expected unit "$/PC".
=> This issue of partial unit could be reproduced on Live Data model (BW & S4HANA), on which the underlying data source has two measures with different unit.
- This issue has been identified as limitation of current version.
- Calculated column doesn't support unit calculation.
This feature to support unit calculation in calculated column has been added into the roadmap of SAC product plan, which may be available in future release.
Workaround: Use Edit Formatting Option on the calculated column and then set Unit manually.
- How to find User Assistance for SAP Analytics Cloud?
- Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
- SAP Analytics Cloud > Learning > Guided Playlists
Your feedback is important to help us improve our knowledge base.
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, unit, currency, calculated, column, formula, bw, S4HANA, BW, S4HANA Cloud, partial , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Product Enhancement