I have several questions with working within projects. Currently, I have several models within my project, one for each subject area, I know I could have broken them out into workspaces, but it would have made my model huge and I wasn’t sure if there was performance impacts.
Is there project level objects we can create that can easily be duplicated in each model?
I have categories that I would like to export or copy to other models within my project. I haven’t been able to find a way to do this. I have to keep manually creating in each of my models when I add new category and I am afraid I am going to miss adding it to one of my models since I maintain 4 of them in my project.
I have a worokspace for date dim with many role playing dimensions, I want this workspace linked in every model and have any changes to one reflected in all the other models. Is this possible?
My current layout is for a data warehouse, star schema, I chose to create model per subject area, we have a lot of common dims that cross fact tables, but we also have a lot of subject areas and fact tables that aren’t related at all.
Within each model I create a workspace for each fact table. Sometimes there are 6 or more facts.
But, there are similarities among each of the models within my models (below) and there are many differences too.
They should all have the same categories
They all should have the same common dimensions
They should all have the same date dim role playing workspace I discussed above.
My question is, would you recommend creating a project that contains a separate model per subject area or just have everything in one model? but then I guess what is the point of projects?
Is there an easy way to link categories, common workspaces, etc. like at a project level so if i change anything there it propagates to all my other models? Right now I am currently maintaining this manually and it is becoming tedious.