If want to create new measure in dyanamic cube cognos while reporting in cognos.
like below.
Please note don't take level don't take description so its better to take Key to calculate extracted measures.
---
CASE WHEN
[Main Service - Key] = 'ACCOMODATION'
THEN [Inputed Quantity]
ELSE 0
END
----
No comments:
Post a Comment