SetTextCellLineItems

Appends or updates line items for the specified cell.

Syntax

<HFMwData>.SetTextCellLineItems bstrScenario, bstrYear, bstrPeriod, bstrEntity, bstrAccount, bstrICP, bstrCustom1, bstrCustom2, bstrCustom3, bstrCustom4, varabstrData, varabstrDetails

Argument	Description
bstrScenario	The name of the cell’s scenario. Input argument. String subtype.
bstrYear	The name of the cell’s year. Input argument. String subtype.
bstrPeriod	The name of the cell’s period. Input argument. String subtype.
bstrEntity	The name of the cell’s entity. Input argument. String subtype.
bstrAccount	The name of the cell’s account. Input argument. String subtype.
bstrICP	The name of the cell’s Intercompany Partner dimension member. Input argument. String subtype.
bstrCustom1	The name of the cell’s Custom 1 dimension member. Input argument. String subtype.
bstrCustom2	The name of the cell’s Custom 2 dimension member. Input argument. String subtype.
bstrCustom3	The name of the cell’s Custom 3 dimension member. Input argument. String subtype.
bstrCustom4	The name of the cell’s Custom 4 dimension member. Input argument. String subtype.
varabstrData	An array of strings containing the line item data to be added, formatted according to the connected user’s preferences. Tip: The HFMwSession component provides access to user preferences. For details, see HFMwSession Type Library. Input argument.
varabstrDetails	An array of strings containing the line item descriptions to be added. This array has a one-to-one correspondence with the varabstrData argument’s array. Input argument.

Example

The following example inserts two line items for the specified cell.

Dim cHFMData, vaData(1), vaDetails(1)
Set cHFMData = Server.CreateObject("Hyperion.HFMwData")
'g_cHFMSession is an HFMwSession object reference
cHFMData.SetWebSession g_cHFMSession
vaData(0) = "61"
vaData(1) = "56"
vaDetails(0) = "Roger"
vaDetails(1) = "Mickey"
cHFMData.SetTextCellLineItems "Actual", "2000", "July", _ 
  "NewYork", "Salaries", "[ICP None]", "GolfBalls", _ 
  "Customer2", "[None]", "Increases", vaData, vaDetails