GetCellTextWithLabel

Gets the cell text from the Point of View for the specified cell text label. This function can be used in these types of rules:

• Calculation

• Translation

• Consolidation

• Allocation

Syntax

HS.GetCellTextWithLabel("POVExpression", "CellTextLabel")

where POVExpression is a combination of members. If you do not specify a dimension, these default values are used.

• Account - [none]

• ICP - [ICP None]

• Custom1...4 - [None]

• Scenario - Current Scenario member

• Entity - Current Entity member

• Value - Current Value member

• Year and Period - Current member

CellTextLabel is either the default cell text label ([Default]) or one of the valid loaded cell text labels.

Note:

The default dimension member values apply when you use this function in Calculation rules. When used in Allocation, Translation, or Consolidation rules, you must specify the Account, ICP, and Custom1…4 members. The Scenario, Year, Period, View, Entity, and Value default to the current members.

Return Value

The cell text for the POV and cell text label specified.

Example

HS.GetCellTextWithLabel("A#Sales.I#[ICP None].C1#[None].C2#[None].C3#[None].C4#[None]","Rating")