Tuesday, September 27, 2016

Derived / Extracted measure in report studio using cognos dynamic cube


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