Export Cube ViewTo Excel/CSV

Post Reply
User avatar
vinnusea
Posts: 116
Joined: Thu Sep 23, 2010 6:12 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Location: San Diego ,CA

Export Cube ViewTo Excel/CSV

Post by vinnusea »

What script i need to write to export the cube view to Excel or CSV and this process should be added in chores. And where to write??.....
Thanks for your time.
Thanks
Vinnusea
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Export Cube ViewTo Excel/CSV

Post by rkaif »

You can use ASCIIOutput() function to export data to CSV file

Crate a TI Process
Data Source tab: Use the Cube View as the Data Source
Variable tab: declare all the variables as Other
Advanced -> Data tab: use ASCIIOutput function to export the data to CSV file

Hope that helps!
Cheers!
Rizwan Kaif
User avatar
vinnusea
Posts: 116
Joined: Thu Sep 23, 2010 6:12 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Location: San Diego ,CA

Re: Export Cube ViewTo Excel/CSV

Post by vinnusea »

Thank you soo much.... for the reply
Thanks
Vinnusea
User avatar
vinnusea
Posts: 116
Joined: Thu Sep 23, 2010 6:12 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Location: San Diego ,CA

Re: Export Cube ViewTo Excel/CSV

Post by vinnusea »

ASCIIOUTPUT('C:\Documents and Settings\preeth\Desktop\TEST11.cma', v1, v2, v3, v4, v5, v6 );

I took TM1 Cube view as source and all variables to Other and gone to Data taba and wrote above code and its throwing me error
"

syntax error on or before :
v6 );
invaled string expression
"

Can you help me ...plz
Thanks
Vinnusea
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Export Cube ViewTo Excel/CSV

Post by tomok »

ASCIIOutPut command can only output text, You'll have to convert v6 to text before you can use it in the formula.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
vinnusea
Posts: 116
Joined: Thu Sep 23, 2010 6:12 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Location: San Diego ,CA

Re: Export Cube ViewTo Excel/CSV

Post by vinnusea »

Yes its working.. Thanks alot.. sir.
Thanks
Vinnusea
aryan
Posts: 7
Joined: Fri May 04, 2018 3:39 pm
OLAP Product: oracle
Version: 10.2.2
Excel Version: 2013

Re: Export Cube ViewTo Excel/CSV

Post by aryan »

tomok wrote: Mon Sep 27, 2010 7:36 pm ASCIIOutPut command can only output text, You'll have to convert v6 to text before you can use it in the formula.
When I am Converting Number to string Only one value is converting and i am getting only one value in the output how to change total data to string
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Export Cube ViewTo Excel/CSV

Post by tomok »

aryan wrote: Thu May 10, 2018 8:59 am
tomok wrote: Mon Sep 27, 2010 7:36 pm ASCIIOutPut command can only output text, You'll have to convert v6 to text before you can use it in the formula.
When I am Converting Number to string Only one value is converting and i am getting only one value in the output how to change total data to string
Read the request for assistance guidelines first and then come back with the kind of information you need to be providing. I have no clue what you are talking about.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Export Cube ViewTo Excel/CSV

Post by Steve Rowe »

Hmmm, you need to convert each field/column/variable to a string independently, so if you have 5 numeric variables then you'll need to write.

AsciiOutput( 'WhyIsThisFunctionNameSoLong.cma' , NumberToString( v1) , NumberToString( v2) , NumberToString( v3) , NumberToString( v4) , NumberToString( v5) );

If that doesn't answer your question then I'm not sure what you are after either..
Technical Director
www.infocat.co.uk
Post Reply