SetLineItems

Inserts a cell’s line items into an HsvMDDataBuffer object.

Syntax

<HsvMDDataBuffer>.SetLineItems lScenario, lYear, lPeriod, lEntity, lParent, lValue, lAccount, lICP, lCustom1, lCustom2, lCustom3, lCustom4, vbSavedAsYTD, varadData, varabstrDescriptions

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.

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.

vbSavedAsYTD

Boolean (ByVal). Determines how the cell’s totals are saved. Pass TRUE if the cell is saved as year-to-date, FALSE if saved as periodic.

varadData

Double array (ByVal). The cell’s line item data.

varabstrDescriptions

String array (ByVal). The cell’s line item descriptions.

Example

The following example loops through a Double array of data, inserting a line item for each array item. For each item, a description from an equally sized String array is also inserted.

For i = LBound(vdData) To UBound(vdData)
' vdData() is a Double array of data, vsDescs() is a
' String array of descriptions.
m_cDataBuff.SetLineItems m_lScen, m_lYear, m_lPer, _ 
m_lEnt, m_lPar, m_lVal, m_lAcct, m_lICP, m_lCust1, _ 
m_lCust2, m_lCust3, m_lCust4, True, vdData, vsDescs
Next i