|
How to automate Framework manager CSV output |
 |
 |
 |
|
Written by Martijn Christenhusz
|
|
Tuesday, 05 May 2009 22:17 |
Useful for versions prior Cognos 8.3 and for a mixed environment CRN and Series 7
Thanks to this command, every time the cube is built, the necessary latest data is written to csv format and will be used by transformer. - Create Query Subject(s) with property Externalize Method set to CSV
- Create Package with these CSV Query Subjects
- Publish this CSV package (select externalized query subjects check box)
- Select View transaction history in Project menu
- Go to the last transaction
- Select last step (publish)
- Press “Save as Script” button
- Save in your work directory, e.g. name is: PublishCSVScript.xml
- Save you model
- Edit your transformer batch file (which will be scheduled) and add the following command line before running transfrmr.exe
"C:\Program Files\Cognos\crn\bin\BmtScriptPlayer" -m <workdir>\modelname.cpf -a <workdir>\PublishCSVScript.xml www.cogknowhow.com
|
|
Last Updated on Saturday, 30 January 2010 11:47 |
Knowledge Articles 
Comments