Select members based on attribute
I have a good understanding of Dimension Override. However I found the following requirement which appears to be challenging.
The user is selecting a Profit Center Node.
I would like to get a list of Cost Centers.
Profit Center is a property of Cost Center.
If the user was selecting a single profit center, with a very simple dimension override we can get the list of Cost Centers. However the user is able to select a Profit center Node containing several Profit Centers. Each Profit Center would have their corresponding list of Cost centers.
How could I get a list with all the cost centers that a user has indirectly selected by entering a Profit Center Node?
Any help greatly appreciated.