GetCell

Returns the data in and transaction status of a cell in a subcube.

Syntax

<HsvNodeCube>.GetCell lPeriod, lView, lValue, lAccount, lICP, lCustom1, lCustom2, lCustom3, lCustom4, pdData, pbyTransType

Argument	Description
lPeriod	Long (ByVal). The member ID of the cell’s Period dimension member.
lView	Long (ByVal). The member ID of the cell’s View dimension member.
lValue	Long (ByVal). The member ID of the cell’s Value dimension member.
lAccount	Long (ByVal). The member ID of the cell’s Account dimension member.
lICP	Long (ByVal). The member ID of the cell’s Intercompany Partner dimension member.
lCustom1	Long (ByVal). The member ID of the cell’s Custom 1 dimension member.
lCustom2	Long (ByVal). The member ID of the cell’s Custom 2 dimension member.
lCustom3	Long (ByVal). The member ID of the cell’s Custom 3 dimension member.
lCustom4	Long (ByVal). The member ID of the cell’s Custom 4 dimension member.
pdData	Double. Returns the cell’s data.
pbyTransType	Byte. Returns the cell’s transaction status. For a list of HFMConstants type library constants that represent the valid statuses, see Cell Transaction Type Constants.

Example

The following example assigns a cell’s data and transaction status to the dData and bytStatus variables. The example assumes that the member IDs passed to GetNodeCube and GetCell are obtained from another procedure.

Dim cHsvNodeCube As HsvNodeCube
Dim dData As Double, bytStatus As Byte
m_cHsvData.GetNodeCube m_lScen, m_lYear, m_lEnt, m_lPar, _ 
cHsvNodeCube
cHsvNodeCube.GetCell m_lPer, m_lView, m_lVal, m_lAcct, _ 
m_lICP, m_lCust1, m_lCust2, m_lCust3, m_lCust4, dData, _ 
bytStatus