Dynamic Cubes

[ShawnEvans]

Hello,

I'm trying to determine how to create a cube from Transformer that is linked to an Oracle DB and is dynamically updated as the underlying DB information changes. Meaning, I don't want to have to update a cube every time the DB changes. I would rather have a single cube, accessed by multiple users that reports up-to-date information without any administrative intervention. Is it possible to achieve this goal with a Power Play/Transformer combo, or are cubes always static? Any and all input would be appriciated.

Regards,
Shawn

 

[GJParker]

In short No.

Powerplay Cube data is static data, the only way to change it is to re-build the cube, It is however possible to automate this process.

HTH

Gary Parker
Systems Support Analyst
Manchester, England