Help with EPMMemberProperty

[Former Member]

Hi Experts,

I have the below EPM report where i want to excract the "period" peoperty - MONTHNUMCY referring to column C5

I was able to exctract the Year as - =EPMMemberProperty(,$C$5,"YEAR")

Any ideas on how i can extract the peroid? Below is my TIME dimension

[former_member186338 · Accepted solution]

OK, now it's clear!

You have TIME in Row axis, not in Page axis!!!!

And the column for time members is "Fiscal Year" - "G"

Then, to get property "MONTHNUMCY" in "Period" column, you have to create local member:

=EPMMemberProperty(,EPMDIM_CURRENT_MEMBER(TIME),"MONTHNUMCY")

EPMDIM_CURRENT_MEMBER(TIME) will be replaced with a correct reference in "G" column.

Please read help:

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.35/en-US/f9bdca036faf1014878bae8cb...

"Displaying the type of accounts of the members displayed in the row axis

..."

[Former Member]

Yes Vadim, Now it makes sense! I also forgot to enable the Local member recognition 🙂

Thank you so much!

[former_member186338]

"I also forgot to enable the Local member recognition" - I do not recommend this option, very strange results in many cases! Create formula manually!

[Former Member]

Here you go Vadim

[Former Member]

Hi Vadim,

we are trying to split the TIME id of 2014.01 and put it separate in FISCALYEAR and PERIOD.

This TIME ID we are deriving from the page axis TIME - 2014.TOTAL

Hope this helps

?

[former_member186338]

Sorry, but still unable to understand, what you are doing!

"split the TIME id of 2014.01 and put it separate in FISCALYEAR and PERIOD." - looks meaningless for me!

Can you show your report setup - screenshot of "Edit report"

I want to see your page, row and column axis

[former_member186338]

To get property from concatenated member:

=EPMMemberProperty(,"[TIME].[PARENTH1].["&$G9&"."&RIGHT("0"&$H9,2)& "]","MONTHNUM")

$G9 - Year cell, $H9 - Monthnum cell

[Former Member]

HI Vadim, I would like to see the period values coming from 2014.TOTAL.

STeps:

1) Input The Time = for Ex: 2014.TOTAL

2) The field in report FISCAL YEAR populates, using the formula - EPMMemberProperty(,$C$5,"YEAR")

3) Which formula can i use to populate the field PERIOD in the report? The output should be as above, from 1-12.

I was wondering if we could use MONTHNUMCY porperty somehow, but it is blank for 2014.TOTAL.

Hope this helps in your question.

Thanks!

[former_member186338]

lavanyam_07

Sorry again, but how the PERIOD is related to report line????

Why it's 1,2,3..12??? Why it's not 7,2,5,1,8....???

Row axis dimensions are: Account, Chanel, Product Line and Interco - TIME dimension is in Page axis

Unable to understand!

[Former Member]

HI Vadim,

My Select TIME prompt in report has 2014.TOTAL.

I was easily able to bring the 'year' field through - EPMMemberProperty(,$C$5,"YEAR")

But i cannot use the same formula to bring the PERIOD, as MONTHNUMCY is blank for 2014.TOTAL.

I just wanted to know if there is any other way to populate the PERIOD field in report based on the pompt value - in this case 2014.TOTAL

[former_member186338]

"I just wanted to know if there is any other way to populate the PERIOD field in report based on the pompt value - in this case 2014.TOTAL" - sorry, but what do you want to see in this column??? For 2014.TOTAL??? Instead of empty cell?

[former_member186338]

What do you mean by "TIEM ID"???

If you want to get property from some fixed TIME ID you can:

=EPMMemberProperty(,"[TIME].[PARENTH1].[2014.03]","MONTHNUMCY")

where "[TIME].[PARENTH1].[2014.03]" - full member ID

[Former Member]

Ok Vadim, but this 2014.03 needs to be dynamic based on the Select Time we give as Input in the Selection box above.

Anyway of doing this?

[former_member186338]

lavanyam_07

Sorry, but I am unable to understand you!

If you are talking about TIME selection in $C$5 then

=EPMMemberProperty(,$C$5,"MONTHNUMCY")

Or some other cell???

[Former Member]

Hi Vadim,

I need the report to look like this

[former_member186338]

Do you want to create member ID concatenating Fiscal Year and Period?

[former_member186338]

And by the way, you TIME dimension is configured incorrectly!

PERIOD property has to be inline with Fiscal Year - MONTHNUM:10 PERIOD: OCT etc...

[former_member186338]

Sorry, but on your screenshot the formula is incorrect:

=EPMMemberProperty(,[TIME],"MONTHNUMCY")

What do you mean by "[TIME]"???

Has to be reference to the cell, containing TIME member ID!

Like $C$5 in the formula: =EPMMemberProperty(,$C$5,"YEAR")

P.S. and for 2014.TOTAL this property is empty

[Former Member]

Yes Vadim, i know it is empty. I was wondering if there is any way to bring in MONTHNUMCY poperty by referencing the TIEM ID Ex: For 2014.01, MONTHNUMCY =1 should be brought in the Period cell)