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:

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”, “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”)