Updating Powercubes 1

[Julia23]

Halo Everyone,

I am looking for a way to update the Powercube data. I have read the ebooks but I can´t find any simple way or the option for Automatic Update. I have a Database for the current year (2007) and tha data imports are every day. I have created a Model and a Powercube. But if I only built the Powercube from the Transformer the new Data is added. For normal Users is that not a solution... To update the Powercube I must recreate the powercube in the Transformer and that costs time. If I update the Cube in the Transformer with the "update option" is that the same? Is there a other way to become the new inportet data? I mean automaticly. Thanks for the Help!!!

 

[drlex]

Julia,
The update option in Transformer is only for updating non-transactional data such as object labels, drill-through links and user classes (see the descriptions next to the check boxes in 'Update PowerCube' window).

You need to rebuild the cube to incorporate new data.
You can do this in a batch file using the command line options of transformer or with a cognos macro. Both can be set in scheduler (cognos or windows).

If you need to set iqds or test for pre-existing conditions prior to a cube build, you might want to use a macro. It is also useful to build the cube in a different location and use the macro to disable the 'live' cube, swap in the new one and re-enable it after a successful build.

A search on this forum and a look through the Cognos documentation should help you get started.
lex

soi la, soi carré

 

[Julia23]

Thank you very much Lex for the information!
I will search in this Forum for a cognos Macro. Yet I know that a different way to update the Data isn´t possible. Thanks for you help again!!!