SAP Knowledge Base Article - Public

2805434 - Incorrect unit appears by default for calculated column based on two measures with different unit in SAP Analytics Cloud (SAC)

Symptom

  • Incorrect unit appears by default for calculated column based on two measures with different unit in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud 2019.10.6

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Open sample model [BestRunJuice_SampleModel].
  3. Set Units & Currencies for account [Quantity_Sold] as one new label, like "PC".
  4. 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".
  5. 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".
  6. 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.

Cause

  • This issue has been identified as limitation of current version.
  • Calculated column doesn't support unit calculation.

Resolution

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.

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, unit, currency, calculated, column, formula, bw, S4HANA, BW, S4HANA Cloud, partial , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Product Enhancement

Product

SAP Analytics Cloud 1.0 ; SAP S/4HANA Cloud 1905