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.
Export Cube ViewTo Excel/CSV
- 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
Thanks
Vinnusea
Vinnusea
- 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
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!
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
Rizwan Kaif
- 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
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
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
Vinnusea
-
- MVP
- Posts: 2832
- 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
ASCIIOutPut command can only output text, You'll have to convert v6 to text before you can use it in the formula.
-
- 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
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
-
- MVP
- Posts: 2832
- 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
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.
- Steve Rowe
- Site Admin
- Posts: 2416
- 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
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..
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
www.infocat.co.uk