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 » Mon Sep 27, 2010 5:24 pm

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 » Mon Sep 27, 2010 6:02 pm

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 » Mon Sep 27, 2010 6:05 pm

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 » Mon Sep 27, 2010 7:24 pm

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

User avatar
tomok
MVP
Posts: 2481
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 » 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.
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 » Mon Sep 27, 2010 7:49 pm

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 » 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

User avatar
tomok
MVP
Posts: 2481
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 » Thu May 10, 2018 11:46 am

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: 1799
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Export Cube ViewTo Excel/CSV

Post by Steve Rowe » Thu May 10, 2018 8:56 pm

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..

Post Reply