You can have up to four overrides for your column and four overrides for your row. These can be used to change the display for a given column or row. In this example, two columns for the Flash Scenario (Col1) vs. Budget (Col2) are needed. If Row1 is being used by the Net Sales Account (e.g. A#60999), and it needs to be compared to the Flash Net Sales which is a different account (e.g. A#FlashNetSales), then you would use a column override.
Row/Column Range
Type a column name to display a different value in the Cube View. You need to use the name of your rows or columns. The row range isn't looking for a numerical order, it's looking for the actual name of the rows and columns in your Cube View. In this example, Col1 would be typed to show a different value for Flash Scenario Column.
TIP: Your Row Range can be a single row or column. To apply to multiple rows or columns, use a comma-separated list or use a hyphen to define a range.
Member Filter
Type the Member Filter to override the value for the columns or rows. In this example, type A#FlashNetSales to override the results from A#60999.
The override results will display the value from A#FlashNetSales in Col1 for the Flash Scenario.
Cell Format
See Cube View Formatting.
List Parameter
See List Parameter under Data earlier in this section.
