
Code
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Code
Search the reference guide and the forum for asciiouput; it will cover everything you need.
Declan Rodger
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Code
You can find a link to it in:Pearl72 wrote:Thanks! Where is the reference guide?
http://www.tm1forum.com/viewtopic.php?f=3&t=1037
You set the cube as your datasource, set all variables to string and then put: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
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"
Declan Rodger
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Code
Googling "export data from cube TM1 9.5" provided this link:
http://pic.dhe.ibm.com/infocenter/ctm1/ ... 509A4.html
http://pic.dhe.ibm.com/infocenter/ctm1/ ... 509A4.html
Declan Rodger