COGNOiSe.com  The IBM Cognos Community
IBM Cognos Analytics Platform => Cognos Analytics => Framework Manager => Topic started by: Cognosnewbie26 on 07 Aug 2020 04:39:07 pm

Hello,
I wanted to create a calculation in the DMR model which is basically calculating the variance% of amounts between current year and prior year. For e.g
Amount of CY  Amount of PY
 * 100
Amount CY
How do I achieve this?

Should be straight forward, create the items in DMRlayer, and base the calculations on these items.

Should be straight forward, create the items in DMRlayer, and base the calculations on these items.
Question is how? Sorry I am still trying to figure out FM.
I have a measure dimension and time dimension. Where should these items go? In Measure dimension? Somebody said I should use tuples.
I am literally struggling with dimensional functions.
Would really appreciate some help.

So for the uninitiated ones like me thought I would post my progress here.
I was able to create a standalone calculation in my DMR layer
using tuples.
I tried adding the same calculation to my Measure Dimension but it does not work why? Can anyone please tell me why and how to make it work?
Note: For some reason I am not able to add my code here