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")