TM1 Forum

I'm trying to create a process to dump the contents of a cube into a file, although I'm having some trouble with the code. Can anyone help?

Search the reference guide and the forum for asciiouput; it will cover everything you need.

Thanks! Where is the reference guide?

Ok I searched the asciioutput and have to say I'm still confused. Im not really a "coder", so any hints would help a lot

Pearl72 wrote:Thanks! Where is the reference guide?

You can find a link to it in:
http://www.tm1forum.com/viewtopic.php?f=3&t=1037

Pearl72 wrote:Ok I searched the asciioutput and have to say I'm still confused. Im not really a "coder", so any hints would help a lot

You set the cube as your datasource, set all variables to string and then put:
AsciiOuput ( 'filepath\filename.csv', Variable1, Variables2... )

In the data tab.
Press the execute button.


Or if you really can't do coding, just right click on the cube and select "Export as Text Data"

Googling "export data from cube TM1 9.5" provided this link:
http://pic.dhe.ibm.com/infocenter/ctm1/ ... 509A4.html