Dear all,
I'm using Cognos 10 Framework Manager and I need your help about a new measure calculation in my DMR View:
On my DMR view, I have :
- 2 measures [Nb Units] and [Unit Price]
- 1 calculated measure : Unit Price / Nb Units ([Avg Unit Price])
- 2 relative Time dimensions "YTD" and "YTD-1"
But, people wants this calculation measure on DMR view:
([Unit Price YTD] - [Unit Price YTD-1]) * [Avg Unit Price YTD-1]
How can I do that ? Hope this can be possible...
Thanks a lot !
Hello Benji,
If I got your question correctly, you can always create a calculation in report studio.
(
tuple([Unit Price],[YTD])
-
tuple([Unit Price],[YTD-1])
)
*
tuple([Avg Unit Price],[YTD-1])
-Cognos810
Quote from: cognos810 on 05 Nov 2014 06:48:50 PM
Hello Benji,
If I got your question correctly, you can always create a calculation in report studio.
(
tuple([Unit Price],[YTD])
-
tuple([Unit Price],[YTD-1])
)
*
tuple([Avg Unit Price],[YTD-1])
-Cognos810
Thanks you very much !
For you, [YTD] corresponds the entire dimension ?
I need drag an drop it into a query calculation ?
Thanks a lot
Hello Benji,
Ideally what I have used and have seen in several other places, [YTD] , [YTD-1] are all members of a dimension. If you could attach a screenshot of your expanded dimension(the view that you see in report studio) that could give me more clarity. But Yes, if you have [YTD] etc as a members then you would create a data item/query calculation with the expression I provided below. We are using the TUPLE function to get your calculation, which will only accept members.
-Cognos810