SetData

Inserts a cell’s data into an HsvMDDataBufferLite object.

Syntax

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

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. You must pass a member ID for a user-defined member. Do not pass the member ID for the system-defined member <Scenario View>.

lEntity

Long (ByVal). The member ID of the cell’s Entity dimension member.

lParent

Long (ByVal). Pass the HFMConstants type library constant MEMBERNOTUSED.

lValue

Long (ByVal). The member ID of the cell’s Value dimension member. You must pass a member ID for a user-defined member. Do not pass a member ID for system-defined members such as <Entity Currency>.

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.

vbAddToExistingData

Boolean (ByVal). If the HsvMDDataBufferLite object already contains data for the cell, this argument determines whether the existing data will be overwritten. Pass TRUE to add the dData argument’s data to the existing data, FALSE to overwrite the existing data.

plNumElementsInDataUnit

Long. Returns the number of cells in the HsvMDDataBufferLite object that are in the subcube to which the cell belongs. This number returned is calculated after SetData adds the cell.

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(laIDs) To UBound(laIDs)
' laIDs() is a Long array of Account IDs, daData() is a
' Double array of data.
m_cMDBufferLite.SetData m_lScen, m_lYear, m_lPer, m_lView, _ 
m_lEnt, m_lPar, m_lVal, laIDs(i), m_lICP, m_lCust1, _ 
m_lCust2, m_lCust3, m_lCust4, daData(i), False, False, _ 
lNumElems
' saDescs() is a String array of descriptions.
m_cMDBufferLite.SetDescription m_lScen, m_lYear, m_lPer, _ 
m_lEnt, m_lPar, m_lVal, laIDs(i), m_lICP, _ 
m_lCust1, m_lCust2, m_lCust3, m_lCust4, saDescs(i)
Next i