If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Exporting Cube View as part of TI Process

Started by gats1527, 26 Jan 2016 12:29:22 PM

Previous topic - Next topic

gats1527

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);

dusherwo

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.

gats1527

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