Skip to Content

Calculated value show ’-’ or not summarized on aggregated dimension member

Hi All,

I faced a calculation problems in SAC, our problem is the following:

  • gross value KPI show ‘-‘ every dimension member. The gross value calculate from gross price x unit, and I set details calculation, the aggregation type is sum.
  • if I switch off the Details calculations the KPI is calculating on leaf members, but show 0 on consolidated member
  • The main problem is, the gross price KPI isn’t additive key figure, so I set the aggregation type None. If I modify to SUM, the gross value calculating every dimension member, but the value isn’t correct on consolidated member.
  • Without currency the calculation works fine.

Could anybody help, what I have to set up or off, to calculate as desired?

KPI

Details calculation of

Details calculation on

sac-01.png (56.6 kB)
sac-02.png (85.7 kB)
sac-03.png (78.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 22, 2017 at 07:17 PM

    Hi Norbert,

    Please do not use the "Calculate on Details" calculation feature as it will be deprecated / not supported in the very near future.

    See the resolution in article 2527989 - Details cannot be calculated on IF formula in SAP Analytics Cloud (BOC)

    Use the exception aggregation 'SUM' with all required dimensions as exception aggregation dimensions. In your case you should add Country and Time as exception aggregation dimensions.

    Also please note the warning when you are looking at the local currency calculation:
    A value is only shown if all child nodes have the same unit or currency.

    See the following article on Exception Aggregation in SAP Analytics Cloud: Applying Aggregation in SAP Analytics Cloud

    Add comment
    10|10000 characters needed characters exceeded