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

refreshing data of a cube

Started by churchy, 14 Mar 2008 07:19:20 AM

Previous topic - Next topic

churchy

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

almeids

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.

biejorrun

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.