Hi Everyone!

I'm involved in project that requires building several cubes in SSAS
2005. Currently we've been working on some calculation procedures and
processes and in order to organise our work properly, we have split our
whole system into serveral modules - each one has it's own
functionality and own structures - usually only some dictionary tables
are common for all modules. We would like to have the same project
structure when it comes to OLAP project in SQL Server Business
Intelligence Development Studio. Our first concept was to create one
Solution (e.g. WholeSystem) and several Analysis Services projects
(Module1, Module2, etc). Since several dimensions (like Time or Date
dimension) are common for all modules, we created module Common, where
we have defined those dimensions (and created Data Source View only
with dimension tables). Then we copy each dimension to module that
needs it. We work in small team (2-4 people).
Several problems are now clear for us:
- each module has to have it's own deployment database since building
of a project deletes ALL objects in database
- each module has to be developed only by one developer at a time (SCM
problems): actually for the time being it's not a problem, but what if
one module becomes more complex (split it again?)

My questions are:
- have you had such design issues and how you managed to solve them?
- is there possibility in MS tools to build several AS 9.0 projects
against one database (not rebuild, but rather alter) or integrate
several projects automatically (building whole Solution in BIDS build
each module step by step so it's the same as building each module
separately)?

Thanks in advance for any suggestions,
Peter