cancel
Showing results for 
Search instead for 
Did you mean: 

Automatically pulling Cost Center associated with Profit Center

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

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