InsertDataAtEnd

Inserts data for a cell at the bottom of an HsvMDDataBufferLite object.

Syntax

<HsvMDDataBufferLite>.InsertDataAtEnd lScenario, lYear, lPeriod, lView, lEntity, lParent, lValue, lAccount, lICP, lCustom1, lCustom2, lCustom3, lCustom4, dData, vbIsNoData

Argument	Description
lScenario	Long (ByVal). The member ID of the cell’s Scenario dimension member.
lYear	Long (ByVal). The member ID of the cell’s Year dimension member.
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.
lEntity	Long (ByVal). The member ID of the cell’s Entity dimension member.
lParent	Long (ByVal). The member ID of the lEntity argument’s parent entity.
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.
dData	Double (ByVal). The cell’s data.
vbIsNoData	Boolean (ByVal). Determines whether the cell is set to null. Pass TRUE to set to null, FALSE otherwise.

Example

The following example loops through an array of Account dimension member IDs and inserts data and descriptions for each account into a cell. The data and descriptions are taken from arrays of the same size. Note that the non-Account member IDs passed to InsertDataAtEnd and InsertDescriptionAtEnd are the same for each cell.

For i = LBound(vlIDs) To UBound(vlIDs)
' vlIDs() is a Long array of Account IDs, vdData() is a
' Double array of data.
m_cMDBufferLite.InsertDataAtEnd m_lScen, m_lYear, m_lPer, _ 
m_lView, m_lEnt, m_lPar, m_lVal, vlIDs(i), m_lICP, m_lCust1, _ 
m_lCust2, m_lCust3, m_lCust4, vdData(i), False
'vsDescs() is a String array of descriptions.
m_cMDBufferLite.InsertDescriptionAtEnd m_lScen, m_lYear, _ 
m_lPer, m_lEnt, m_lPar, m_lVal, vlIDs(i), m_lICP, _ 
m_lCust1, m_lCust2, m_lCust3, m_lCust4, vsDescs(i)
Next i