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