GetCell

Gets the data contained in a cell. This function can be used in these types of rules:

Calculation
Translation
Consolidation
Allocation

Syntax

HS.GetCell("POVExpression")

where POVExpression is a valid point of view.

Return Value

The data stored in the specified cell.

Note:

If the function returns more than one value, an error occurs.

Example

This example assigns to the dData variable the amount stored in the intersection of the Sales account and the Golfballs member of the Custom1 dimension:

Dim dData
dData = HS.GetCell("A#Sales.I#[ICP None].C1#Golfballs.C2#Customer2.C3#Increases.C4#[None]")