Consolidation Method

Table 33. Consolidation Method Properties

Property Label

Value Description

 Property Name
Alias

Member description (maximum of 80 characters)

To use the Alias property, you create an Alias dimension, define properties, and associate the Alias dimension with another dimension. For example, you can create an Alias dimension with the values English, French, and Italian and then associate the Alias dimension with the Consolidation Method dimension.

 Alias

Control

Specifies the threshold that corresponds to the type of control to be used by the calculation routine. Specify one of these values for this property:

  • Blank

  • No

  • Limited

  • Full

 Control

Is Holding Method

Specifies if the consolidation method is used for the holding company.

Specify Y to use the method for the holding company or N to use a different method for the holding company.

 IsHoldingMethod

Name

Name for the consolidation method (required)

Names can contain up to 80 characters, including spaces, and cannot start with a space or contain these characters:

  • Ampersand ( & )

  • Asterisk ( * )

  • At sign ( @ )

  • Comma ( , )

  • Curly brackets ( { } )

  • Double quote ( “ )

  • Minus sign ( - )

  • Number sign ( # )

  • Period ( . )

  • Plus sign ( + )

  • Semicolon ( ; )

  • Slash mark ( / )

 Name

Percent Consol

Specifies the consolidation percentage applied by the ownership calculation routine.

Specify one of these values:

  • POWN

  • POWNMIN

  • PERCENTAGE

    Note:

    If you select PERCENTAGE as the value, you must enter a value for the Percent Consol Value property.

 PercentConsol

Percent Consol Value

Specifies the consolidation percentage value applied by the ownership calculation routine.

Note:

This property is used by system only if PERCENTAGE is the value for the Percent Consol property.

Specify a value between 1 and 100.

 PercentConsolValue

To Percent Control

Specifies the upper boundary of the range for percent control. Used for the ownership calculation routine.

Specify a value between 0 and 100.

Note:

One of the method records must have a value of 100.

 ToPercentControl

To Percent Control Compare

Specifies if the upper boundary of the range of percent control is included in the range. Used for the ownership calculation routine and the To Percent Control property. This property is optional if the Used By Calc Routine property is N.

Specify < or <= for this property.

 ToPercentControlComp

Used By Calc Routine

Specifies if the method is used for the automatic ownership calculation routine.

Specify Y to use the method for ownership calculations or N not to use the method for ownership calculations.

 UsedByCalcRoutine