ReviewStatus

Gets the review status for the specified point of view. This function can be used in these types of rules:

Calculation
Translation
Consolidation
Allocation

Syntax

HS.ReviewStatus("S#Scenario.Y#Year.P#Period.E#Entity.V#Value")
HS.ReviewStatus("")

Note:

Use a blank string ("") to apply this function to the current member.

Table 75. Syntax for ReviewStatus Function

Parameter	Description
Scenario	Name of a valid Scenario dimension member.
Year	A valid year
Period	A valid period.
Entity	Name of a valid Entity dimension member.
Value	Name of a Value dimension member.

Return Value

A string that specifies the review status for the member. Valid review statuses are as follows:

Not Started
First Pass
Review Level 1-10
Submitted
Approved
Published
Not Supported

Example

In this example, if the review status of the specified point of view is Submitted then statements between the If...Then and End If statements are executed:

If HS.ReviewStatus("") = "Submitted" Then
  ...
End If