Skip to Content
0

Dynamic Local Member Formulas

Jan 05 at 09:25 AM

104

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Jan 05 at 09:35 AM
0

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

Show 8 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0

Please correct primary tag and user name!

0
Former Member
Vadim Kalinin

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.

0

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

0
0

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
Former Member
Vadim Kalinin
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.
0

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

0