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