on 01-01-2014 6:20 AM
Dear BPC Friends,
I am creating a COST CENTER and PROFIT CENTER report. In the selection client only want PROFIT CENTER and TIME.
In page key range, I have Account, DataSrc, RptCurrency, & Cost Center. The client want that based on the PROFIT CENTER selection, the Cost Center should be automatically pulled in the report.
For this I have created a Profit_Center property in Cost Center Dimension and tried using ‘EPMmemberporperty’. However, this function is not pulling the Cost Center associated Profit Center.
Any suggestion, how can I pull the IDs (i.e. Cost Center) based on the Profit_Center property in Cost Center dimension.
I am working on EPM 10 NW.
Thanks,
Rahul
Hi Rahul,
"In page key range, I have Account, DataSrc, RptCurrency, & Cost Center. The client want that based on the PROFIT CENTER selection, the Cost Center should be automatically pulled in the report."
You also have Profit Center on your page axis? And user want to select Profit center and Cost Center to be selected automatically?
Then you need a property for Profit Center dimension containing related Cost Center. For the rest look here:
"= EPMOlapMemberO(EPMMemberProperty("INFILE - SIM"; EPMMemberID($A$1); "PLANBE");"[BE].[PARENTH1].[BE1000]";"BE1000 - OOO ""United Press""";"";"000")
Where $A$1 - is the cell on page axis with the member having the property PLANBE - to be used as BE member"
B.R. 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 I do have Profit Center in page axis and user want to select Profit Center only and the related Cost Center need to come up automatically in page axis for report to show the data.
I am slightly confused about statement i.e “Then you need a property for Profit Center dimension containing related Cost Center. For the rest look here”
I already have Profit_Center property in Cost Center Dimension. My question is
1-
1- 1- Do I need to create Profit_Center property in Cost Center Dimension
OR
2- 2- Do I need to create Cost Center property in Profit Center.
I cannot create the second one, as there are multiple Cost Center associated with each Profit Center.
Thanks.
Rahul
Hi Rahul,
You are writing something controversial to your original requirements... I do not understand you:
"Yes I do have Profit Center in page axis and user want to select Profit Center only and the related Cost Center need to come up automatically in page axis for report to show the data."
This statement means that you have one to one relationship between Profit Center and Cost Cented (both on page axis)...
Then you write:
"I cannot create the second one, as there are multiple Cost Center associated with each Profit Center."
Please clarify!
B.R. Vadim
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.