Skip to Content
0
Jun 06, 2018 at 10:42 AM

Custom measure to calculate whole project value through time dimension

68 Views

Dear Experts,

I've a requirement from a customer, which seems to be relatively basic.

We have a Périodic Model to plan budget projects , in which we have one dimension called PROJECT . each project has a property "YEAR_CREATED" allowing to refer the creation date of the project. Ex. 2015.10.

Each year, the need is to calculate the whole value of each project from the creation date to the current member of the time dimension.

To answer this, I'm trying to add a new MEASURES FORMULAS "PTG" (Project To Go), put, I'm facing trouble and not sure to well understand what is possible to do.

Please find below the code i'm trying to work with :

MEMBER [MEASURES].[PTG] AS

IIF([%INDICATORS_CAPEX%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC",
SUM(PERIODSTODATE([%PROJECT%].[CREATED_YEAR], [%TIME%].CURRENTMEMBER),
-[MEASURES].[/CPMB/SDATA),

IIF([%INDICATORS_CAPEX%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP",
SUM(PERIODSTODATE([%PROJECT%].[CREATED_YEAR], [%TIME%].CURRENTMEMBER),
[MEASURES].[/CPMB/SDATA])