cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic Local Member Formulas

0 Kudos

I have created default report and report 001 and shared the row axis.

Reason for creating 2 report is default report has actual category and report 001 has forecast category.

I have Account in Row axis and time in col axis which has 12months

For one account alone I need to use local member formula. The formula I have used is EPMretreivedata and given the time range by selecting the column axis(time). Default report has 12 months(jan2017 to dec2017) in column and report "001" has different month(dec15). Now issue is local member formula works well in default report but it is not working properly for report 001 since the time in retrieve function is showing as jan2017(the first column in default report) and category in retrieve function is showing as actual.

Can anyone help me on this?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Please provide the clear report screenshot and local member config screenshot! Your description is not clear.

And in general it's a bad practice to use EPMretreivedata (slow reports).

P.S. Please correct your user name - "$endil V" is something unreal! Read forum rules: https://www.sap.com/community/about/rules-of-engagement.html

0 Kudos

if you see the sales amount is equal in jan2017 and dec2016 since report001 is taking jan2017 as time instead of dec2016.

former_member186338
Active Contributor
0 Kudos

Please correct primary tag and user name!

0 Kudos

HI Vadim, Already changed the name, am not able to change the primary tag (EPM add-in is not displaying in the drop down). May be it will work only if I post a new question.

former_member186338
Active Contributor
0 Kudos

"not able to change the primary tag" - looks like a new bug in Community platform. I will report in Using SAP.com

former_member186338
Active Contributor
0 Kudos

And about your question: why do you need local member at all?

Looking on your formula I can see only fixed member "300". Why it can't be selected as row axis member???

0 Kudos
Report "000" is for Actual category and Report "001" is for Forecast Category so I have used local member. If I use 2 categories in column axis then the same time(12 months) will be repeated twice, one set for actual and one set for forecast.
former_member186338
Active Contributor
0 Kudos

Sorry, but not clear. Please explain again with full details.