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.