Guideline for working with OLAP 2005 in teams

[GeertVerhoeven]

Hi all,

I need some guideline for deployment of OLAP cubes. We have 2 servers (PROD and DEV) which are both SQL 2005 servers.

Is it possible to work on 1 single server simultaniously? The issue that we have now is that the changes from the first user are sometimes overwritten by the changes of the second user when using both online and offline development.

What is the best way to be able to work with multiple persons on the same OLAP database. And is it possible to deploy only a single dimension or a single cube in case of needing to deploy the entire solution?

Thanks in advance,

Geert

 

[wawanz]

Just an idea, have you tried using Visual SourceSafe 2005?

Regards,
Wawan

 

[MDXer]

Look into Team services. Has a price tag on it but it will allow you to lock individual portions of a solution.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck