Account Expressions

Some functions require an Account Expression as an argument. In its simplest form, an Account Expression is a string that specifies the account to which Oracle Hyperion Financial Management applies the function.

The Account Expression characters are listed in the following table.

Table 10-2 Characters Used to Specify Dimensions in Account Expressions

Character	Dimension
A#	Account
I#	Intercompany Partner
C#	Custom
S#	Scenario
Y#	Year
P#	Period
W#	View
E#	Entity
V#	Value

To understand Account Expressions, consider the Clear function, which removes values from the dimension members specified in the function’s argument. In this example, the argument "A#Sales" is an Account Expression:

HS.Clear "A#Sales"
         

The A# characters represent the Account dimension, and the word Sales is the member name of the Account dimension to which Financial Management applies the Clear function. This Account Expression tells Financial Management to clear the data stored in the Sales account.

When you use an Account Expression, Financial Management applies the function to the intersection of the account that you specify in the Account Expression and the current members of these dimensions:

• Entity

• Period

• Scenario

• Value

• View

• Year

• Custom - Uses the CustomTopMember that was set for the account in the metadata. For example, if the Account Expression does not specify a member of the Custom 3 dimension, Financial Management uses all valid Custom 3 members as defined by the CustomTopMember specified for the account.

• Intercompany Partner - All valid ICP members.

You can override the Intercompany and Custom dimension defaults by specifying members in the Account Expression. Each dimension is represented by certain characters. When you include more than one dimension in an Account Expression, you must separate the dimensions with periods.

When you create an Account Expression, you do not have to specify all of these dimension members; you can specify the members to which to apply the function. For example, this line clears the intersection of the Sales account and the Hardware ICP:

HS.Clear "A#Sales.I#Hardware"