Author Topic: How to create calculations in the DMR model  (Read 470 times)

Offline Cognosnewbie26

  • Full Member
  • ***
  • Join Date: Jul 2020
  • Posts: 9
  • Forum Citizenship: +0/-0
How to create calculations in the DMR model
« 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?

Offline Deep750

  • Community Leader
  • *****
  • Join Date: Jun 2012
  • Posts: 83
  • Forum Citizenship: +1/-0
Re: How to create calculations in the DMR model
« Reply #1 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.

Offline Cognosnewbie26

  • Full Member
  • ***
  • Join Date: Jul 2020
  • Posts: 9
  • Forum Citizenship: +0/-0
Re: How to create calculations in the DMR model
« Reply #2 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.

Offline Cognosnewbie26

  • Full Member
  • ***
  • Join Date: Jul 2020
  • Posts: 9
  • Forum Citizenship: +0/-0
Re: How to create calculations in the DMR model
« Reply #3 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

« Last Edit: 16 Aug 2020 01:27:27 am by Cognosnewbie26 »