COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: damzI on 01 Nov 2016 11:45:41 PM

Title: Building 2 exact same cubes concurrently
Post by: damzI on 01 Nov 2016 11:45:41 PM
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
Title: Re: Building 2 exact same cubes concurrently
Post by: stan.parker on 02 Nov 2016 09:02:05 AM
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?
Title: Re: Building 2 exact same cubes concurrently
Post by: bobznkazoo on 01 Mar 2017 03:08:00 PM
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.
Title: Re: Building 2 exact same cubes concurrently
Post by: damzI on 07 Mar 2017 03:01:26 PM
thank you bobz - that is exactly what I was looking for.