SetCellsLineItems

Appends or updates line items for the specified cells. Line item data is passed in a Double array.

Tip:	To update cells by passing data in a String array, use SetTextCellsLineItems.

The cells’ dimension members are passed in arrays that have a one-to-one correspondence with each other.

Syntax

<HsvData>.SetCellsLineItems varalScenario, varalYear, varalPeriod, varalEntity, varalAccount, varalICP, varalCustom1, varalCustom2, varalCustom3, varalCustom4, varadData, varalDetail

Argument	Description
varalScenario	Long array (ByVal). The member IDs of the cells' Scenario dimension members.
varalYear	Long array (ByVal). The member IDs of the cells' Year dimension members.
varalPeriod	Long array (ByVal). The member IDs of the cells' Period dimension members.
varalEntity	Long array (ByVal). The member IDs of the cells' Entity dimension members.
varalAccount	Long array (ByVal). The member IDs of the cells' Account dimension members. Tip: Use HsvAccounts.UsesLineItems to check whether an account supports line items.
varalICP	Long array (ByVal). The member IDs of the cells' Intercompany Partner dimension members.
varalCustom1	Long array (ByVal). The member IDs of the cells' Custom 1 dimension members.
varalCustom2	Long array (ByVal). The member IDs of the cells' Custom 2 dimension members.
varalCustom3	Long array (ByVal). The member IDs of the cells' Custom 3 dimension members.
varalCustom4	Long array (ByVal). The member IDs of the cells' Custom 4 dimension members.
varadData	Double array (ByVal). The data to be added to the cells, formatted according to the user’s preferences.
varalDetail	String array (ByVal). The line item descriptions that identify the line item details to be updated.

Example

The following example adds data for two line items. The example assumes that the member ID arrays passed to SetCellsLineItems have been previously set.

Dim saDesc(1) As String, daData(1) As Double
daData(0) = 100000
daData(1) = 200000
saDesc(0) = "Chairs"
saDesc(1) = "Desks"
m_cHsvData.SetCellsLineItems laScen, laYr, laPer, laEnt, _ 
laAcct, laIcp, laCust1, laCust2, laCust3, laCust4, _ 
daData, saDesc