Hi Techies ,
I am little new to cognos world . we used to create DMR views in Fm and doing the report . due to permfomance issue , we start working on transformer cubes , we created a cube in Dev enviorment , want to know the process /step to follow for production migration .
Also would like to know how we do data refresh
1, can we do manually using UI ?
2, is this can be automated as scheduled jobs .
request to share the best way /industrial standard pratice to follow .
Yes, you can manually refresh the cube using the UI but it is best to use a script which will invoke Transformer and start the build process automatically at a certain time. This is usually done in the night.
For the migration to production, Transformer cubes are usually refreshed on the production server itself. The idea is to update the cube with the data on the Production server which is usually more recent then the data on the DEV server. Hence , instead of building the cube on the DEV and migrating it on PROD, the cube is built (refreshed) on the PROD itself. Transformer needs to be installed on the PROD and the script needs to execute on the PROD.