Export Cognos Planning data to txt or csv file

[sgan]

How can i export cognos planning data to txt or csv file , I have tried Export to Excel , but i would crash because of large data. also i tried thru report net & analysis studio & query studio , the report is running forever.

Is there a way that i can export data from sql table . source could be application tables or publish container tables.

[Amritha]

1) If you are using SSIS you can export the data in to excel format and can automate the process by creating a job.

2) Bring the data back to Analyst by creating Contibutor-Analyst link and then export the data by using 'Export' option.