Override Complex Calculations

When you apply dynamic calculations to both rows and columns the row formula takes precedence, whether it is a dynamic calculation member or cube view math.

Rows and columns contain several override properties by row:

• When you use the row override in the column it will use the column formulas for the specified rows.

• When you use the column override in the rows it will use the formulas for the specified columns.

Apply Overrides

1. In the cube view, select a column.

2. Select the Row Overrides tab to apply row overrides in the column.

3. Define the row range. Enter a row name or apply a range of row names to override the results for the specific rows in the column of the cube view.

4. Enter the member filter to override the value for the row range. This defines what dimension member data displays or specifies complex calculations for the row range.

5. Set the format for the row range, which includes selecting fonts, text colors, cell background color, grid lines, cell borders, and so on.

6. Select a value from the list parameter drop down list.