IBM Controller Parameters

You can use the following parameters in Controller.

Acc

Account.

Example: 1010

Act

Actuality.

Example: AC, BU, P1

Auto JrnType (EType)

Automatic journal type.

Example: <blank>, 61

CComp

Counter company.

Example: 1100 - Enter any counter company regardless of security restrictions set on companies.

CDim

Counter dimension.

Example: FR1 (Only Dim1 can be counter dimension), <blank>

Cell

Cell reference.

Example: sheet1!$A$2

ClosVer

Closing version

Example: REPO

Comp

Company code.

Example: 1000

ConsType

Consolidation type.

Example: LE, O1, OP

ContVer

Contribution version.

Example: BASE

CurrCode

Currency code.

Example: SEK

CurrType

Currency type.

Example: LC, LE, O1

Dim1 (same for Dim2-4)

Extended dimension 1.

Example: FR1, <blank>

Form

Form.

Not applicable in the IBM® Cognos® Controller Link for Microsoft Excel, only used by the report generator as a default.

Group Persp.

Group Perspective.

Example: 1000 - Enter any group.

Optional/Index

Index, the system rows/columns.

Example: Can be Blank or an index number, for example 1, 2 or 3. Index can only be used in the report generator.

Interval

Period Interval.

Example: 1,2,3,4,6,12, YTD (Year To Date) or NPY (Number of Periods per Year)

IsClosVer

Is Closing Version.

Example: If selected, sClosVer is returned If not selected, sBType is returned

IsContVer

Is Contribution Version.

Example: Requires T (True) or F (False) as input. If nothing is entered, T is used as default. Note that if a T or Blank is entered here then ContVer requires a contribution version.

JournalNo

Journal number.

Example: 0-999

Jrn/Type (Btype)

Journal Type.

Example: <blank>, U

Local/Group

Text in local language/group language. Used in fText().

Example: Returns the text entered in Local or Group, depending on what language selection has been chosen.

MovementExt

Movement extension.

Example: CB, 010

Per

Period.

Example: 0112, in YYMM format

PeriodFormula

A period's relation to the current reference period

Example: Nxxxx, Pxxxx, -x, +x, +0 where x can be: +/- 5 * NPY at monthly actuality +/- 5 * NPW at weekly actuality

RateType

Currency rate type.

Example: The available rate types are:B (Closing rate), M (Closing Yr rate), D (Average period rate).

RowNo

Row number.

Example: 1-20