Project life cycle with Object Manager

Let's talk a little bit about usual BI projects. Usually, we use several environments, such as development, test, and production. It gives us flexibility and we can make sure that no one will destroy production. We can build new staff on development then test it on test and then promote to the production. In MicroStrategy, we should use Object Manager. Object Manager tracks the version ID of every object in MicroStrategy. Be aware that if you apply changes on both environments, then the version ID of objects will be different. That's why it is important to not make any changes on production, because it will be difficult to maintain consistency of the project across various environments.

Another feature of Object Manager is that it searches all dependents, such as schema objects, public objects, and so on. We can select from metadata tables all the information about relationships between objects:

SELECT * FROM DSSMDOBJDEPN;

There is a very good presentation...