Custom Measure SAP BPC 10.0

[Former Member]

Hi experts,

I'm trying to create a custom measure to display cumulated values over all years. Which means if I have a time dimension that contains for example these years : 2013, 2014, 2015, 2016 with all levels (Months, Quarters, Years)

I need to calculate the cumulative values from 2013.01 until Now, not YTD or QTD

How can I achieve that ?

I'm using SAP BPC 10.0 NW SP05

Thanks

Maha

[Former Member · Accepted solution]

Hello Maha,

Ex:-ur starting month is 2013.01 go to this

SUM([%TIME%].[2013.01]:[%TIME%].CURRENTMEMBER)

Go to SE38, type program name (UJA_MAINTAIN_MEASURE_FORMULA)create a new custom measure--->Save---->Refresh Meta data in Excel.

Hope Helful !!

[former_member186338 · Accepted solution]

Hi Ravi,

What was the idea to repeat my answer?

Vadim

[Former Member · Accepted solution]

Hello Mr.Vadim,

If it meets your's, pl ignore !!This case I went in my past actually.

Anyhow Thanks for your reply,here I got more confidence on mine,by comparing to your(experts) explanation.

[Former Member]

Thank you Vadim and Ravi

It works.

Regards

Maha

[former_member186338]

Hi Maha,

Please use search, it was discussed number of times!

Vadim

[former_member186338]

Like: