OpenDataUnitSorted

Gets the data units to process during calculation, translation, or consolidation, with data sorted in the order specified. This function can be used in these types of rules:

• Calculation

• Translation

• Consolidation

Syntax

HS.OpenDataUnitSorted(POVExpression, <dimension to be sorted>, Ascending or Descending)

where POVExpression is a POV string, <dimension to be sorted> is a dimension name string, and can only be one of these six dimensions:

"Account" or "A", "ICP" or "I", "Custom1" or "C1", "Custom2" or "C2", "Custom3" or "C3" , or "Custom4" or "C4".

You must specify one of the following: Account, ICP, Custom1, Custom2, Custom3, Custom4.

The third parameter is a string value: "Ascending" or "A", or "Descending" or "D".

Examples

Set DataUnit= HS.OpenDataUnitSorted("S#Actual.E#Group1","C1","Ascending")