Dimension member filter in journals
We are currently implementing a consolidation solution and have the following business requirement to satisfy.
In the journal line item when the user selects a account from the selection we need to filter the dimension "flow" next to the account field based on a property that is maintained on the account dimension and this property is also available in the flow dimension. This filtering should preferably happen in the dimension member selection screen.
I did extensive searches to find a solution but to no avail. Does anybody knonw if this is possible somehow?