TM1 Forum

Hi guys,

Was wondering if anyone has used I_PROCESS TM1 macro function in VBA ?? I have created active slice of the cube view and would like to display a message related to functionality on this slice. For e.g. If Add vendor TI failed, I would like display the exact reason. For this I write error message to ASCII file which i would like to load it within this Active slice worksheet.

I have tried it as per TM1 help on this but just displays FALSE in the worksheet.

Activecell.value = Run("I_PROCESS", "DR");

DR is the name of the ASCII file with .cma extension.

Appreciate any help and thanks in advance.

I think you have misinterpreted what the I_PROCESS macro does. I_PROCESS allows you to programatically call a worksheet process, typically to load data into a cube. This is very old technology and was the precursor to TurboIntegrator. There has been plenty of discussion regarding process worksheets lately on this board if you're interested.

A TM1 worksheet process reads all records in a comma separated ASCII source into row 1 of the Excel sheet one record at a time, as each record is read in the worksheet calculate event is called. Hence if you know the structure of the import file you can have other Excel TM1 formulas pointing at the range in row 1 used by the process to send or otherwise manipulate data. As what the I_PROCESS macro does is trigger a worksheet process I hope it's now obvious that you can't call the result as a cell function?

For what you want to do a more sensible and efficient solution would be to write your load comment to a string cube that holds that latest status for your TI load process (or you could have a more generic cube that holds the status for many TI processes ...). In any slice or active form reports you can then just pull the commentary for the TI process with a DBRW formula. This should be more simple and more elegant to implement.

Hmm If you had a file with exactly 1 record in it and no end of file record then I suppose you could use I_Process to read it into a spreadsheet, since I_Process imports 1 line at a time. If you have a column of messages to read in then you could use I_Names.

In practice though it's often more straight forward to read the value in from a string cube that you wrote too during the TI process and you'll have greater control over where the information displays too.

As lotsaram also says this is very old functionality now so I would not be suprised to find it did not interact well with very current things like active slices. Have you tried your code on an ordinary workbook?

Cheers,