Exporting cube view to CSV via TI

Post Reply
jimmyn
Posts: 9
Joined: Mon Mar 30, 2020 10:06 am
OLAP Product: Not sure
Version: 2.0.49
Excel Version: 1

Exporting cube view to CSV via TI

Post by jimmyn »

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 :).
Attachments
TM1ExportError.PNG
TM1ExportError.PNG (26.1 KiB) Viewed 1563 times
Alan Kirk
Site Admin
Posts: 6647
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Exporting cube view to CSV via TI

Post by Alan Kirk »

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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply