Hi DMR Reporting Heros.

I have a report with a calculated Measure like this:

tuple( [Revenue] ;[2013] ) /
CASE caption( currentMember( [Umsatz].[Einzelhändler].[Einzelhändler] ) )
WHEN 'Germany' THEN 3
WHEN 'France' THEN 2
WHEN 'Finland' THEN 4
ELSE 1
END

How can I aggregate this over sets and calculate the %difference?

This is not correct:

Any Ideas?
The Report Spec you'll find attached. Please try it out.

thx Jens
P.S.optimally, the case should refer to an attribute.




------------------------------
Jens Bäumler
Senior Consultant and Trainer
Apparo Group
------------------------------
#CognosAnalyticswithWatson

Solution: Converting to a member using the member-function is working in this case:

member(
tuple( [Revenue] ;[2013] ) /
CASE caption( currentMember( [Umsatz].[Einzelhändler].[Einzelhändler] ) )
WHEN 'Germany' THEN 3
WHEN 'France' THEN 2
WHEN 'Finland' THEN 4
ELSE 1
END )


------------------------------
Jens Bäumler
Senior Consultant and Trainer
Apparo Group
------------------------------

Original Message:
Sent: Tue July 27, 2021 11:54 AM
From: Jens Bäumler
Subject: Aggregations in Crosstabs with calculated measures

Hi DMR Reporting Heros.

I have a report with a calculated Measure like this:

tuple( [Revenue] ;[2013] ) /
CASE caption( currentMember( [Umsatz].[Einzelhändler].[Einzelhändler] ) )
WHEN 'Germany' THEN 3
WHEN 'France' THEN 2
WHEN 'Finland' THEN 4
ELSE 1
END

How can I aggregate this over sets and calculate the %difference?

This is not correct:

Any Ideas?
The Report Spec you'll find attached. Please try it out.

thx Jens
P.S.optimally, the case should refer to an attribute.




------------------------------
Jens Bäumler
Senior Consultant and Trainer
Apparo Group
------------------------------
#CognosAnalyticswithWatson