Exp

Puts data into a combination of Account, ICP, and Custom1...4 members. This function can be used in these types of rules:

• Calculation

• Translation

• Allocation

Syntax

HS.Exp "DestPOV = Expression"

Table 11-20 Syntax for Exp Function

Parameter	Description
DestPOV	A destination point of view that identifies where to put the data. Note these usage rules: To avoid populating the database with unwanted values, rules should be as explicit as possible in terms of defining where data should reside. A good practice is to include clearly defined ICP and Custom dimension intersections for the Account dimension. Such clearly defined intersections utilize Oracle Hyperion Financial Management validation checks to avoid writing data to invalid intersections.
Expression	A calculation expression.

The destination for the data is on the left side of the equal sign, and the data to be assigned is on the right side. This example sets the cell that intersects the UnitsSold account and the [None] members of the Custom dimensions to 40000:

HS.Exp "A#UnitsSold.C1#[None].C2#[None].C3#[None].C4#[None]" _

   & " = 40000"

On the right side of the equal sign, you can use Account Expression characters to represent dimension members. Thus, you can assign data for a group of cells to another group of cells. This example sets the cell that intersects the Taxes account and the [None] members of the Custom dimensions to 6 percent of the data in the cell that intersects the Sales account and the specified Custom dimensions:

HS.Exp "A#Taxes.C1#[None].C2#[None].C3#[None].C4#[None]" _

   & " = A#Sales.C1#AllProducts.C2#AllCustomers.C3#[None]" _ 

   & ".C4#[None] * .06"

Tip:

You can set multiple accounts with one Exp statement. See Simultaneously Setting Several Accounts.