@dimexact(vXXXX,“dimension member”)

Definition

References dimensional account instances from accounts that do not share the same dimensions as the account with the formula, enabling you to reference dimensions not currently assigned to the account with the function.

Returns

Returns a dimensional instance.

Example

If Sales has the dimension Region but not Product, and Cost of Goods sold has the dimension Product but not Region, the Cost of Goods Sold account can use this formula:

@dimexact(v1000,"North")*.1 

to retrieve the instance for Sales/North and multiply it by 10%.