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