COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: gats1527 on 26 Jan 2016 12:29:22 PM

Title: Exporting Cube View as part of TI Process
Post by: gats1527 on 26 Jan 2016 12:29:22 PM
I have a cube view created with the data that I want to export and I am trying to create a TI process that will export this data as a CSV file.  Below is the code I have in the Metadata tab and the process will run with no issues, but no file is created.  I have also tried moving this code to the ProLog tab and the file will be created, but no data in the file.


TextOutput('D:/dailyoutput.csv',vVersions,vCurrencyType,vBusinessUnit,vIndustry,vClient,vServiceLine,vPeriodDaily,vClientMeasure,vValue);
Title: Re: Exporting Cube View as part of TI Process
Post by: dusherwo on 27 Jan 2016 09:06:32 AM
Use the Data tab.
But also check that your view has content, by rightclicking and exporting to a file. A common issue is to have Suppress Consolidations ticked but then to have one or more dimensions without any N level elements selected.
Title: Re: Exporting Cube View as part of TI Process
Post by: gats1527 on 27 Jan 2016 10:15:38 AM
I thought I had every dimension at the level 0 but I missed a few.  once I changed the view and then re-ran the process, I received an export file.

Thank you