Skip to Content
0

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

Nov 20, 2017 at 08:58 AM

61

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
John Leggio
Nov 22, 2017 at 07:17 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Norbert,

Also see this great overview on Price * Volume Formulas ( calculations ) in our online help guide:

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/78d550c8cb154c25b8e73810fabcddbc.html

0