Skip to Content
0
Former Member
Nov 02, 2016 at 09:11 PM

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

109 Views

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.