Local Members Attached to Shared / Multiple Reports

[former_member597393]

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

[former_member222556 · Accepted solution]

Why cant you use Position or Members in local member formula instead of cell reference.?

[former_member186338 · Accepted solution]

Hi Obaid,

Please test before posting! EPMReportID requires reference to the cell with EPMOlapMemberO formula (in this case - column axis member). Position or specific member are related to the report data area...

Vadim

[former_member597393 · Accepted solution]

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

[former_member186338 · Accepted solution]

Sorry,

Please explain - do you have 2 dimensions in column axis of both reports or???

On your screenshot I can see only one dimension in column axis per report...

Please, show you real report!

Vadim

[former_member597393 · Accepted solution]

Hi Vadim,

I am using one dimension in column axis per report :

In report 000 :  I have ONLY the dimension CATEGORY

In report 001 : I have ONLY the dimension SALE

the members are dynamic not fix base on user selection.

Mohamed

[former_member186338 · Accepted solution]

P.S. By the way, the formula EPMDIM_CURRENT_MEMBER(DIMNAME) works ONLY for members shown on row or column axis - NOT page axis. If you want to get property of the member in page axis - use fixed reference like $A$2

Vadim

[former_member186338 · Accepted solution]

Another question - do you have different connections for 2 reports? Different models?

Vadim

[former_member597393 · Accepted solution]

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

[former_member186338 · Accepted solution]

Please, answer my question:

"Another question - do you have different connections for 2 reports? Different models?"

[former_member597393 · Accepted solution]

I have only one connection for both reports

and one model for both report.

[former_member186338 · Accepted solution]

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

[former_member597393 · Accepted solution]

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"))

[former_member186338 · Accepted solution]

The reference substitution (from EPMDIM_CURRENT_MEMBER(CATEGORY) to actual - for example B8) is done for the first report only. The second report is using the same relative reference - same row, current column.

Vadim

[former_member186338]

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

[former_member597393]

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

[former_member186338]

What dimension name you have in the column axis for report "000"? - real name?

"By the way, what is the reason to have multiple reports?" - please, answer!

Vadim

[former_member186338]

For the first report ("000") you have to define local member:

Where PLANTYPE is column axis dimension name of the first report ("000")

Result:

Vadim

[former_member597393]

Hi Vadim,

Thanks.

I tested is working , I want to add header on top of the column members that display the category type.

I cannot achieve this with local member.

in your schreen shot row6 .

Thanks

[former_member186338]

Sorry, but looks like none of my answers are useful...

And about headers - you can hide original column axis headers and create your custom headers using additional local members with the method I explained:

=IF(EPMReportID(EPMDIM_CURRENT_MEMBER(xxx))="000",...

Vadim