TM1 Forum

Posted: **Sat Mar 02, 2024 11:56 pm**

Hello all.

Has anyone encountered returning data from a drill process where the source is specified as a csv file?
The official doc is silent on this matter, but there are still some references that the function is reserved and works through the rest api. So maybe I’m doing something wrong or it doesn’t work very well in old clients? PA 2.0.9

as I expected it only works in PAW

csv columns (variables) define as 'Other' in the source variables tab.

Epilog code:

Code: Select all

ReturnCSVTableHandle;

documentation: https://www.ibm.com/docs/ro/planning-an ... llsets.htm

Posted: **Sun Mar 03, 2024 10:19 am**

Hello,

George Tonkin and Edward Stuart have been working on this in the past:
https://community.ibm.com/community/use ... utput-file

Does this help ?

Posted: **Sun Mar 03, 2024 4:32 pm**

yep Wim thanks

Posted: **Mon Mar 04, 2024 12:02 pm**

I wasn't aware of this. Will have to look up ReturnCSVTableHandle and see if I can get it to work.

The "classic" way of doing this is to use a text to ODBC driver and set up a public ODBC DSN pointed to a specific folder then have a TI process write a CSV to the folder which can then be displayed as a drill-through result. However, just being able to reference a CSV directly for a drill-through seems like a betrter option.

TM1 Forum

}Drill process return handle

}Drill process return handle

Re: }Drill process return handle

Re: }Drill process return handle

Re: }Drill process return handle