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

Copy Time Dimension from 1 model to another

Started by kgcognos, 15 Oct 2014 01:39:24 PM

Previous topic - Next topic

kgcognos


We created a Time Dimension but we had to make changes to the categories and then lock it so new categories won't be created.
It takes time to create a time dimension. Is there any way to copy a dimension from 1 model to another so we don't have to recreate each time?

bdbits

I don't know if there is a way to copy a dim of any kind from one model to another. And since the time is linked to something in your data source, how would Transformer know what the target model date source is?

Here, I base my Transformer cubes on Framework Manager packages. My cube time dimensions point to a query subject based on an underlying table that has all the date attributes we normally use for date/time. When we want to build a new cube on an existing warehouse with a time dim, we pull in the existing query subject with whatever attributes we want to use. For a new warehouse, we copy the time dim and the stored proc we use to populate it. This works well for us.