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 11-42 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