SAP EPM ADD-IN Custom measures based on TIME

[former_member697627]

Hi Experts,

I have a calcuated measure that contains the following code :

SUM(PERIODSTODATE([%TIME%].[%TIMEYEARLEVEL%],CLOSINGPERIOD(YEAR([%TIME%].[%TIMEBASELEVEL%]))), ABS([MEASURES].[/CPMB/SDATA]))

It is working perfectly, it is retrieving data from january 2021 to December 2021.

I need to change this function slightly in order to get data from january 2021 to current month (October 2021)

Do you have any suggestions ,

Thank you,

Soumaya

[former_member186338]

Very strange measure... What's the idea behind:

ABS(...)???

What is your model storage type?

Show detailed sample screenshot!

[former_member697627]

The idea behind is to return an absolute value, no matter what the GL_ACCOUT type IS, if it bothers you, you can ignore it, that is not the heart of my problem.

It is a BPC Planning Model, but what i'm looking to do is only applicable for output reports.

[former_member186338]

"to return an absolute value" - no, it will return SUM of absolute values, making result meaningless!

"It is a BPC Planning Model" - I am asking about storage type! Is it correct to assume storage type as PERIODIC?

Screenshot of the required report is needed!

"I need to change this function slightly in order to get data from january 2021 to current month" - what do you mean?? YTD?

[former_member697627]

No it is not periodic, it returns the measure only one time as you can see one the picture below

report.png

What i need is not a YTD, because as i understood, on BPC if you want to calculate a YTD you need to select the member on which you want to calculate the value, what i need is for the measure to find the current month dynamically so i don't have to select anything but the year.

Hope that i made it clearer for you

[former_member186338]

Sorry, but I do not reply to the posts with "Insert File" instead of correct "Insert Image"! Absolutely bad idea.

[former_member697627]

Here is the image instead 🙂

[former_member186338]

Sorry, but I am unable to understand what you are talking about...

Custom measure is some MDX based formula defined on the model level. And it's not related only to EPM reports (web reports can also use custom measures).

Measure calculation is based on the particular intersection of all dimensions.

BPC model can be PERIODIC or YTD by storage type (PERIODIC - you are able to save periodic values for P&L accounts, YTD - YTD values). Measures for PERIODIC and YTD model are different!

[former_member697627]

It is a custom measure that i created specifically for this report in order to response to a specific business need, this measure will only be called from this epm report.

What i need is to imitate a YTD behaviour but i need it's ending point to be based on the current month without the need for a user's selection.

[former_member186338]

Sorry, but measure don't look on user selection!

Asking 3rd time - what is your model storage type?

Provide a screenshot of the required result

(months in columns, measures in rows - standard measure and custom measure, some account in page axis)