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

Title: How to create calculations in the DMR model
Post 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?
Title: Re: How to create calculations in the DMR model
Post by: Deep750 on 10 Aug 2020 06:00:27 am
Should be straight forward, create the items in DMR-layer, and base the calculations on these items.
Title: Re: How to create calculations in the DMR model
Post by: Cognosnewbie26 on 10 Aug 2020 11:11:56 am
Should be straight forward, create the items in DMR-layer, 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.
Title: Re: How to create calculations in the DMR model
Post by: Cognosnewbie26 on 15 Aug 2020 09:44:11 pm
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