cancel
Showing results for 
Search instead for 
Did you mean: 

LocMember of shared report will be overwritten

Former Member
0 Kudos

Hello experts

We have following situation:

2 reports are sharing the column axis (time dimension).

On the Standard Report 00 we have a different row dimension  than on Report 1. For both dimensions we need to show their proporty values, which is naturely for dimension 1 different than for dimension 2.

Our problem is that the system does not accept the formula for locMember from Report 1 and overwrites this with locMember of Report 00. This will give us an error because that property is not existing in DIM1.

Do you have a solution for this ?

Rgds

Tho

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Hi Tho,

You will need more complex local member formula! Create it in the first default report! Sample:

=IF(EPMReportID(EPMDIM_CURRENT_MEMBER(INACCT))="000",EPMMemberProperty("INFILE - SIM",EPMDIM_CURRENT_MEMBER(INACCT),"ACCTYPE"),EPMMemberProperty("ADVSALES - SIM",EPMDIM_CURRENT_MEMBER(INACCT),"IS_INPUT"))

Where:

"INFILE - SIM" and "ADVSALES - SIM" are connections for "000" and "001" reports.

INACCT - is the row axis dimension for the first report. You have also use it in the property formula for the second report!

"ACCTYPE" and "IS_INPUT" - properties for 2 different row axis dimensions in "000" and "001" reports.

Tested - working!

Vadim

P.S. The result of local member insertion will be:

=IF(EPMReportID(A8)="000"; EPMMemberProperty("INFILE - SIM"; EPMMemberID(A8); "ACCTYPE"); EPMMemberProperty("ADVSALES - SIM"; EPMMemberID(A8); "IS_INPUT"))

Message was edited by: Vadim Kalinin - P.S. added!

Answers (0)