on 10-24-2014 10:22 AM
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
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
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.