Skip to Content
avatar image
Former Member

EPMDIMENSIONOVERRIDE with Dynamic property filter based on other dimension member node as selection.

Lets say I have two dimensions Costcenter and Profitcenter.

Costcenter dimension has a property PCENTER which has the assigned profit center.

I want to create input template where the user selects a Profit center using EPMCONTEXTMember or EPMSELECTMEMBER and the report should bring in all the costcenter that are assigned to the profit centers. The tricky part is the user can select a Profitcenter node and the report should expand with all the costcenter assigned to all of the profitcenters that fall under the node.

Is there a way to get the list of all profitcenter under a selected node in a text so I can pass it to EPMDIMENSIONOVERRIDE

Any help or tips is greatly appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers