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

selection based on property values in EPM report BPC10

Hi ,

I have a requirement to display values based on the selection of properties from different dimension

Below are the two dimension with properties.

COMP_CODE ID REG A1 AMS A2 AMS E1 EMEA E2 EMEA

ENTITY ID CC DEPT 11 A1 FIN 22 A1 IT 33 E1 OPERATION 44 E1 IT 55 E1 HR

Output for selection

Region need list achieved via EPMdimension propertYvalues() Ccode need list need list based on the reference of region selection .Ex: if AMS is selected should show A1 and A2 in the list DEPT need list need list based on the reference of CCODE selection.Ex,if A1 is selected the list should show FIN and IT Entity unique value based on Ccode and DEPT should give entity ID. Ex:CCODE=A1 and Dept=IT then ID=22

request your help in the user selections for EPM report

Thanks

Aamer

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on May 11, 2015 at 07:04 AM

    Hi,

    For CCode and Entity use filter value based on Excel reference in EPMContextMember .

    For Dept use EPMDimensionPropertyValues.

    Hope it helps..

    regards,

    Raju

    Add a comment
    10|10000 characters needed characters exceeded

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.