IsValidDest

Determines if the specified point of view is a valid destination. This function can be used in these types of rules:

• Calculation

• Translation

• Consolidation

• Allocation

  Note:

  This function does not check to see whether the cell is a calculated cell.

Syntax

HS.IsValidDest("POVExpression")

where POVExpression is a point of view. If you do not specify a dimension, these default values are used:

• Account - Current Account member if used in Sub Consolidate subroutine. Otherwise, account is required.

• Custom and ICP - Current member is used in Sub Consolidate subroutine. Otherwise, the TopMember for the account is used.

• Scenario - Current Scenario member

• Entity - Current Entity member

• Value - Current Value member

• Year and Period - Current member

Return Value

A Boolean that is True if the specified point of view is a valid destination; False otherwise.

Example

In this example, if the specified destination is valid, then all statements between the If...Then and End If statements are executed.

If HS.IsValidDest("A#Sales.I#CT.C1#P1.C2#R1.C3#[None].C4#[None]") = TRUE Then

  ...

End If