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

Building 2 exact same cubes concurrently

Started by damzI, 01 Nov 2016 11:45:41 PM

Previous topic - Next topic

damzI

Hello,
My Transformer models has 2 cubes (exactly the same cubes) with different names and I am looking to build them together.
Every time a cube is built transformer reads the data.
How can I have one data read for the above 2 cubes to avoid redundancy and save time ?
Thanks, D

stan.parker

Transformer will reread the data for each cube it builds. Have you considered using flat files to build your cubes to save on build time?

bobznkazoo

You said "Transformer models" so that sounds like you have more than one.

If the cubes are exactly the same and use the same data sources, then put both differently named PowerCubes into the same model file.  Then the data sources get read only once and you can build as many cubes from that model as you want.

damzI

thank you bobz - that is exactly what I was looking for.