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?
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.