Skip to Content
0

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

Nov 02, 2016 at 09:11 PM

35

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers