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 routine. Otherwise, account is required.
Custom and ICP - Current member is used in Sub Consolidate routine. Otherwise, top member 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