Code

Post Reply
Pearl72
Posts: 3
Joined: Fri Jan 10, 2014 1:18 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Code

Post by Pearl72 »

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? :)
declanr
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

Post by declanr »

Search the reference guide and the forum for asciiouput; it will cover everything you need.
Declan Rodger
Pearl72
Posts: 3
Joined: Fri Jan 10, 2014 1:18 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: Code

Post by Pearl72 »

Thanks! Where is the reference guide?
Pearl72
Posts: 3
Joined: Fri Jan 10, 2014 1:18 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: Code

Post by Pearl72 »

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 :)
declanr
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

Post by declanr »

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"
Declan Rodger
declanr
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

Post by declanr »

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