TM1 Forum

Hi All,

I am not an expert in TM1 but here i am facing an unusual situation that when I use csv file to load data using TI Process into cube, i can see preview in Data Source tab. Then I store all fields in different variables and then using these variables and cellputn function in Prolog tab, I am trying to populate data into cube, but it is not happening giving error unable to find source data. Also, to check if different fields of csv file is getting stored into respective variables, I just tried ASCIIOUTPUT function to output variable contents. But, in generated text file, only an empty string is visible. Can anyone please help me to understand what is happening here? Or any suggestion what i should try out. Any help regarding this is really appreciated.

Thanks and Regards,
VIV

zodiacviv wrote:Then I store all fields in different variables and then using these variables and cellputn function in Prolog tab

The prolog tab does not read your data source; only the metadata and data tabs actually read the rows of your datasource.

Did you get the path correct? Preview will work if "Data Source Name" is set, but TM1 will ignore that and use the "Data Source Name On Server" field.

The difference is that "Data Source Name" is used by the client for preview purposes and should be a path that is accessible to the client. "Data Source Name On Server" should be a path accessible to the TM1 Server and is used during the actual TI execution.

You have two issues going on here. The first issue is putting code in the prolog, expecting it to act on records in the data source. A'int gonna happen because the Prolog (as the name implies) is for code to do stuff BEFORE any actual records are read from the source. All your variables from the data source will be empty because no records have been read into memory. This code will have to go in Data tab. Second issue is difference between DatSourceName and DataSourceNamefor Server. The preview is built off the path you AS THE USER can see. The path the server is actually going to process is in the second field DataSourceNameforServer. Just because you can see it does not mean TM1 will be able able to. It needs to be a path that the server (once again, not you personally), can see and has security rights to.

Thanks All,

I really appreciate help from all TM1 Experts here. Now i am able to do file export. I was doing mistake of writing code for Data Tab into Prolog tab.

Viv