Forum Discussion

DDrider's avatar
DDrider
New Contributor III
4 months ago

Exceeding maximum row/column overrides

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.

Cube View
Reports
  • KarlT's avatar
    KarlT
    Contributor III
    2 months ago

    I think i would look at creating a dynamically calculated member that can be used in that column. This should allow you define more complex logic.