I have searching info about refreshing data contained in a cube automatically.
As far as i know there are three possible ways to do that (tell me if i am wrong):
1. Java script
2. MDL script
3. Swapcube utilitie
What of those ways is more sutable? any of them provided any advantage over the others?
I think the easiest one is using swapcube.bat...
Thanks
Anybody out there correct me if I'm wrong as I don't have C8, but I don't believe cubeswap has anything to do with refreshing data in a cube, it's a mechanism for replacing a cube with a refreshed copy.
I'm also not a Java person but even if Cognos has provided SDK hooks to do something regarding cube building I can't see a necessity for it.
To update a cube noninteractively you use command line Transformer, specifying the cube model which you can maintain in either MDL or binary format (in 12 years of using Transformer/PowerPlay I have not found a compelling reason to use binary format). Build your cube to a staging area and then use cubeswap to move it into production.
For command-line options of Transformer, open Transformer and check the helpfiles.
Cognos Support hosts a pdf about cubeswap. Search the proven practices for "managing powercubes". It describes a beautiful process of how to refresh your powercubes, and how to retain multiple backups of your cubes.