InsertLineItemDetails

Inserts line item descriptions in the cells that intersect the specified dimension members.

Syntax

<HFMwData>.InsertLineItemDetails bstrScenario, bstrYear, bstrEntity, bstrAccount, bstrICP, bstrCustom1, bstrCustom2, bstrCustom3, bstrCustom4, varabstrDetail, varalInsertPos

Argument	Description
bstrScenario	The name of the Scenario dimension member for the intersecting cells. Input argument. String subtype.
bstrYear	The name of the Year dimension member for the intersecting cells. Input argument. String subtype.
bstrEntity	The name of the Entity dimension member for the intersecting cells. Input argument. String subtype.
bstrAccount	The name of the Account dimension member for the intersecting cells. Input argument. String subtype.
bstrICP	The name of the Intercompany Partner dimension member for the intersecting cells. Input argument. String subtype.
bstrCustom1	The name of the Custom 1 dimension member for the intersecting cells. Input argument. String subtype.
bstrCustom2	The name of the Custom 2 dimension member for the intersecting cells. Input argument. String subtype.
bstrCustom3	The name of the Custom 3 dimension member for the intersecting cells. Input argument. String subtype.
bstrCustom4	The name of the Custom 4 dimension member for the intersecting cells. Input argument. String subtype.
varabstrDetail	An array of strings that contain the line item descriptions to be added. Input argument.
varalInsertPos	An array of Longs that indicate the positions in the intersecting cells in which the descriptions are to be added. The line item position identifiers are 0-based, and the array has a one-to-one correspondence with the varabstrDetail argument’s array. Caution! The array items must be cast as Long subtypes. Input argument.

Example

The following subroutine creates the first line item for the cells that intersect the dimension members passed. The subroutine also takes the description to be applied to the line items.

Sub InsertFirstLineItem(sScen, sYr, sEnt, sAcct, sIcp, _ 
   sCust1, sCust2, sCust3, sCust4, sLineDesc)
Dim cHFMData, vaPos(0), vaDesc(0)
Set cHFMData = Server.CreateObject("Hyperion.HFMwData")
'g_cHFMSession is an HFMwSession object reference
cHFMData.SetWebSession g_cHFMSession
' Assign the passed description to an array
vaDesc(0) = sLineDesc
' The line item position must be cast as a Long
vaPos(0) = cLng(0)
cHFMData.InsertLineItemDetails sScen, sYr, sEnt, sAcct, _ 
   sIcp, sCust1, sCust2, sCust3, sCust4, vaDesc, vaPos
End Sub