G'day all
We have created a sophisticated set of time relative categories in one cube model and now need to replicate this in several others. My questions related to this activity are:
1. Is it possible to create a template model and then reference/inherit objects from that template in the new model. This is similar to the template idea in Impromptu or Report Studio/ReportNet.
2. How can a category in one model be copied to another model?
I anticipate your flood of responses with baited breath. :)
Bluey
Hi Blue,
I don't believe there's any concept of Transformer model "templates" available currently. The only thing I can suggest is that once you have finished your first model, rename it and use it as the starting point for your subsequent model (which would mean you would need to delete the irrelevant bits and add your new data sources/dimensions/measures etc.) Probably not what you're looking for, though! :-)
Best regards,
MF.
Thanks GFGF, that's what we were thinking of doing. I was hoping that someone had created some nifty macro that allowed copying of categories from one model to another and was willing to share such programming brilliance. ;D
One possible solution:
Implement your categories in MDL (Complimentary Material/Transformer MDL Rerference).
Then you could apply these to any cube by creating mdl containing:
OpenMDL "YourCube.mdl"
OpenMDL "AddCategories.mdl"
MDL is not that hard to learn...