Override

Use this option to specify different POV dimension members, formula calculations, or text for one or more consecutive columns or rows or to change a style. Use this option within a row or column definition.

Note:

To override cells that are not consecutive, you can enter the override in the Other field of the form options. You can enter multiple overrides by separating each override by a comma. The following example overrides three individual cells:

Override(1,1,string("455")),Override(3,3,string("23")),
Override(5,5,string("2234"))

You cannot use member lists with the Override option. You can apply multiple overrides to a cell, with the last value being used when there is a conflict. In most cases, you can also mix the overrides on a cell. For example, if an override on a row specifies a value for NumDecimals while an override on a column specifies a value for Scale, there is no conflict except if the same dimension is used. If you use a leading semicolon, you can mix values for Style.

You can also mix overrides where they intersect by including a semicolon after the Override keyword. Note that without the semicolon, the style defined for the row is used because row values supersede column values when they conflict in the form. To mix the overrides from the row and column definitions, you must include the semicolon on the row keyword.

Syntax

Override(StartCell,EndCell,Override)

Parameter

Description

StartCell

An integer value representing the override starting point. If the override is defined for a row, this parameter indicates the starting column where the override is applied. In this example, the override starts with column 2:

R2=A#Sales, Override(2,3,A#SalesTP)
EndCell

An integer value representing the override ending point. In the example above, the override ends with column 3.

Override

A POV. For example, to override with a different account, you specify A#newacct. To override with a different scenario and account, you specify A#newacct.S#newscenario.

You can also use these values or options with a POV override or by themselves:

Example

In the following override example, the system overrides columns 2 and 3 for row 2 with January as the period and the PriorSales amount instead of the sales amount for the month:

R2=A#Sales, Override(2,3,Y#2014.P#January.A#PriorSales)

In the following override example, the system overrides columns 2 and 3 for row 2 with a formula calculation of the average of Sales1, Sales2, and Sales3:

R2=A#Sales, Override(2,3,SCalc((A#Sales1+A#Sales2+A#Sales3)/3)

In the following override example, the system overrides columns 2 and 3 for row 2 with the read only option.

R2=A#Sales, Override(2,3,readonly)