I would use one of the text fields on the UD1 profit centers to store the AcqYear and filter on that.
Use a combobox and bound parameter or an input param to display the years, then use the parameter to drive the where in the member filter for the row in your cube view. e.g. .Where(Text1 = |!pm_acg_year!|)
Another way to do it would be to create a stat account that holds a 1 in the year of acquisiton for the profit center. Then use column based suppression via a cv extender rule: Is there a way to suppress a row in a cube view based on values in another row using conditional formatting? - OneStream Community (onestreamsoftware.com)
Hey Robb, thanks for the reply.
The problem with these solutions is that the subtotal's won't be correct? So we'd have to create manual subtotals in the cube views?
