Skip to Content
author's profile photo Former Member
Former Member

Automatically pulling Cost Center associated with Profit Center

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 01, 2014 at 09:35 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.