Create Custom Measure in BPC 7.5 MS

[Former Member]

I have a need to do some reporting on contract revenue and costs that are loaded into our BPC environment. My current set of measures are Periodic, QTD and YTD. I need a measure that would be Inception to Date (ITD). It would show all the contract revenue and cost for all years up to the current month I have selected.

Is this somehow possible? I have seen some posts regarding half year and prior 12 month measures but nothing regarding ITD.

If anyone could help me with this I would greatly appreciate it.

Sincerely,

Steve

[Former Member]

Hi Steve,

one possible but not very scientific method would be to simply create a measure that adds up the last 2400 periods. This would be 200 years (based on 1 year = 12 months).

To set this up use a prior 12 months measure and replace the timeframe.

BR,

Arnold