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.