HsGetText

Data sources: Financial Management

HsGetText retrieves cell text from the data source for dimension members, cell references, the default POV, or a combination of all three.

Syntax

HsGetText (“Connection”,”POV”,”CellTextLabel”)

Example

In this example, HsGetText returns the cell text from the HFM01 data source for the default POV.

HsGetText(“HFM01”,"Scenario#Actual;Year#2004;Period#"&B$2&";View#
<Scenario View>;Entity#UnitedStates.Connecticut;Value#<Entity Currency>;Account#"&$A3&";ICP#[ICP None];Custom1#GolfBalls;Custom2#Customer2;Custom3#[None];Custom4#
Increases")