ContainsCellTextWithLabel

Determines if the cell contains cell text for the specified label and updates the cell text information. This function can be used in these types of rules:

• Calculation

• Translation

• Consolidation

• Allocation

Syntax

HS.ContainsCellTextWithLabel("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 entries apply when you use this function in Calculation rules. When used in Allocation, Translation, or Consolidation rules, you must specify the full sub-cube Account/ICP/Customs POV. The Scenario, Year, Period, View, Entity, and Value dimensions default to the current members.

Return Value

A Boolean expression that is True if the specified data cell contains cell text for the cell text label specified; False otherwise.

Example

In this example, if the specified cell does not contain cell text for the cell text label specified, then statements between the If...Then and End If lines are executed.

If HS.ContainsCellTextWithLabel ("A#Sales.C1#Prod1.C2#Region1", "Rating") = "False" then ... End If