GetLineItems

Returns the data and descriptions for a cell’s line items, given the member IDs that identify the cell’s dimension members. GetLineItems also indicates whether the cell’s data is saved as year-to-date or periodic.

Syntax

<HsvMDDataBufferLite>.GetLineItems lScenario, lYear, lPeriod, lEntity, lParent, lValue, lAccount, lICP, lCustom1, lCustom2, lCustom3, lCustom4, pvbSavedAsYTD, pvaradData, pvarabstrDescriptions

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.

pvbSavedAsYTD

Boolean. Indicates how the cell’s data is saved. Returns TRUE if saved as year-to-date, FALSE if saved as periodic.

pvaradData

Variant array. Returns the data for the cell’s line items. The array is returned as a Double subtype.

pvarabstrDescriptions

Variant array. Returns the descriptions of the cell’s line items. The array is returned as a String subtype.

Example

The following example returns the data and descriptions of a cell’s line items. The example assumes the cell’s dimension member IDs have previously been defined.

Dim bYTD As Boolean, vdData, vsDescs
m_cMDBufferLite.GetLineItems m_lScen, m_lYear, m_lPer, _ 
m_lEnt, m_lPar, m_lVal, m_lAcct, m_lICP, m_lCust1, _ 
m_lCust2, m_lCust3, m_lCust4, bYTD, vdData, vsDescs