TM1 Forum

Hi everyone, yesterday in one of the my post http://www.tm1forum.com/viewtopic.php?f=3&t=12848 I was pointed out that "5. All lines in the Data procedure are sequentially executed against the first record in the data source. All lines are then sequentially executed against the second record in the data source, and so on until all records are processed." http://www.ibm.com/support/knowledgecen ... 40068.html

Please clarify for me, does it run for each single record for example AXJ, then CLT001 and next record so on...?
or does it run for each each line combination? I'm little confused as 'm trying to visualize how the TI script understands / reads the instruction.
Period Regions Clients Measures Value 201002 AXJ CLT001 NetIn 22,203.00 201002 AXJ CLT002 NetOut (590.00) Thanks all!

All Lines in the Data procedure are sequentially executed against the first record of the data source. All lines are then sequentially executed against the second record in the datasource and so on until all records are processed.

Therefore, if your Data procedure or all lines in the Data tab are:

Val1 = CELLGETN ( Cube, Dim1, Dim2, Dim3 ) ;
Val2 = CELLGETN (Cube, Dim1, Dim3, Dim3 ) ;
Val3 = CELLGETN (Cube, Dim1, Dim3, Dim3 ) ;

and your datasource contains four lines

Then the three lines in your data procedure will run for each line in the datasource, giving you a total of 12 values

If you add another two lines to the data procedure then run the process then you would generate 18 values.

Thanks for your help Edward. That helps.

Ashleigh W wrote:Please clarify for me, does it run for each single record for example AXJ, then CLT001 and next record so on...?
or does it run for each each line combination? I'm little confused as 'm trying to visualize how the TI script understands / reads the instruction.
Period Regions Clients Measures Value 201002 AXJ CLT001 NetIn 22,203.00 201002 AXJ CLT002 NetOut (590.00)

There is no such thing as a line combination but a single "record" can have multiple fields in it. I assume the above table has two records with 5 fields in it? In this case all the code in the data tab will be run against the first record (where the value us 22,303.00) and then against the second record (the one with the (590.00) value.

thank you Tom!