Lately, I've been trying to clean up a group of projects that my company received from an outside contractor. Among them is an SSAS cube, with an associated data warehouse.
The contractors generated the cube top-down, using the Schema Generation Wizard to generate the schema for the data warehouse from the cube. Normally, based on what I've read about the SSAS tools in Visual Studio, you make changes to the data warehouse by changing the cube, and then re-running the Schema Generation Wizard to update the data warehouse. I'd like to maintain the database using the SSAS tools so that we have one centralized place to manage both the cube and data warehouse's schema.
My goal with cleaning up these projects is to get them to run on developers' local machines. That will require standing up a full new set of independent databases on each developer's machine. I want to manage the data warehouse schema from the SSAS tools, so I'd like to fully regenerate the schema each time we stand up a new developer.
I'm not concerned with data or stored procedures in the data warehouse at the moment. I'd be fine with completely deleting the data warehouse and regenerating it when needed. Deleting the
.dsv file will not be an option, however, because it contains queries against the table structure defined by the cube.
Is there any way to regenerate a previously-generated schema using the Schema Generation Wizard, without deleting the