on 12-22-2014 8:37 AM
Hi,
I am trying to use local member that reference to cell in the shared report by row axis , by the value of the formula don't get updated correctly for the second report 001.
for the second report should display 001. I am using EPMReportID in to check to get report ID then I use a formula to get property.
the same issue if I use this formula : =EPMMemberProperty(, EPMMemberID(I8), "PARENTH1")
the members in the column axis are dynamic , means based on some selections, I use EPMAxisOverride to changes the members.
I tried to apply the solution adviced by Vadim in the discussion: http://scn.sap.com/thread/3640499 but its not getting updated for me.
may I miss something.
I find also a SAP Note : 1996732 - Local Members Attached to Shared / Multiple Reports
Please find in attach the scenario that I am testing .
Thank you for your help.
Regards
Mohamed Faouzi
Why cant you use Position or Members in local member formula instead of cell reference.?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim,
your answers are very useful but still testing .
its fine with EPMReportID alone .
when using this formula is not displaying anything , I am using two dimension in the column axis :
=IF(EPMReportID(EPMDIM_CURRENT_MEMBER(CATEGORY))="000",
EPMMemberProperty(, EPMDIM_CURRENT_MEMBER(CATEGORY),"CATEGAT"),
EPMMemberProperty(, EPMDIM_CURRENT_MEMBER(SALE), "CATEGBS"))
Thanks
I am using the formula only for column members axis.
its seems that second clause is not working when you have two different dimension.
I remove the formula EPMMemberProperty(, EPMDIM_CURRENT_MEMBER(SALE), "CATEGBS")
from IF statement and put text to display.
=IF(EPMReportID(EPMDIM_CURRENT_MEMBER(CATEGORY))="000",
EPMMemberProperty(, EPMDIM_CURRENT_MEMBER(CATEGORY),"CATEGAT"),"TEST")
its display data for the property of CATEGORY for the report 000
and TEST as text for the report 001
Mohamed
Ok, then use the following:
=IF(EPMReportID(EPMDIM_CURRENT_MEMBER(CATEGORY))="000",
EPMMemberProperty(, EPMDIM_CURRENT_MEMBER(CATEGORY),"CATEGAT"),
EPMMemberProperty(, EPMDIM_CURRENT_MEMBER(CATEGORY), "CATEGBS"))
You have to use CATEGORY instead of SALES!!!! The reference will be calculated using report "000" and used in second! This was mentioned in my original post...
Vadim
Thanks , very helpful , finaly is working .
its bit confusing for me the logic because we have to put the same dimension even in the second clause.
and I don't have the CATEGBASE in the dimension CATEGORY ??
how this system accept this formula without error message to say propperty not defined.
EPMMemberProperty(, EPMDIM_CURRENT_MEMBER(CATEGORY), "CATEGBS"))
Hi Mohamed,
But what is the issue with my solution? In the link you mentioned - column was the shared axis, and you have row shared axis...
By the way, what is the reason to have multiple reports?
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim,
Yes the row axis was shared.
I want to have two dimension DIM1 and DIM2 in the column that share the same row axis.
the members for the column dimensions are changing dynamically using
EPMAxisOverride formula.
I want to display below the column members the member's properties .
for this reason I decided to use local members.
for the first DIM1 are working but the second DIM2 which is in the report 001 its restart the reference to the first cell I8 of the DIM1 , so the data is not correct.
I start the test with EPMReportID wich reference to cell members in the column as you explained in your formula :
=IF(EPMReportID(EPMDIM_CURRENT_MEMBER(INACCT))="000",EPMMemberProperty("INFILE - SIM",EPMDIM_CURRENT_MEMBER(INACCT),"ACCTYPE"),EPMMemberProperty("ADVSALES - SIM",EPMDIM_CURRENT_MEMBER(INACCT),"IS_INPUT"))
as result it display always 000.
in the note they say is not working when refrence to cell .
Thanks
Mohamed
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.