4 weeks ago
Hi all. I am building a report that requires more overrides than the standard cube view template allows for.
10 rows of this report require overrides to the scenario dimension for one column. These rows have either multiple dimension intersections (e.g. A#Net_Income:U7#Modeling:U8#Top) or exist as GetDataCell calculations. Each of these rows needs the scenario dimension overrode.
Using column overrides is not an option as these rows already use the 4 column override options for variance columns. I have tried pasting multiple rows in one override property, but if the override controls more than one row it erases the dimension intersections specified on the row (e.g. turns the above dimension intersection into the standard report POV members instead of the specified members).
How can I apply the overrides for these rows? If cube views allowed for more than 4 column overrides this would be as simple as adding more fields, but I am out of fields to input.
Thanks in advance.