TM1 Forum

Hi All,

I am trying to export data from a cube view to CSV file, the process reported successful, however, it produces no file ...

Detail of TI:
Data source is cube view and previews returning 1 sample data.
I have converted all entries in variable tab as "Other"
Tried both ASCIIOutput and TextOutput functions and they behave the same i.e. says successful, but produce no file.

Thank you in advance for your help .

jimmyn wrote: ↑Tue Apr 07, 2020 8:19 am Hi All,

I am trying to export data from a cube view to CSV file, the process reported successful, however, it produces no file ...

Detail of TI:
Data source is cube view and previews returning 1 sample data.
I have converted all entries in variable tab as "Other"
Tried both ASCIIOutput and TextOutput functions and they behave the same i.e. says successful, but produce no file.

Thank you in advance for your help .

You can't rely on the sample view to give you an indication of what is going to be generated from the cube view. If you get a message that the process completed successfully, and you have no file, most of the time it's a sign that there was no data in the data source. That, incidentally, does not count as being an error in itself.

I would suggest that you go to the cube, right click on it and select "Export as Text Data..." and export your view directly from there. I would not be surprised if what you have exported is bupkis. In that case, it's time to redefine your view.