It is very important to update the project's Schema every time there is a Schema Object change, addition, or deletion. In this exercise, you will learn how to update the Schema with the following steps:
- Select the project where the schema will be updated. For this exercise select the MicroStrategy Tutorial project.
- Open the project by double clicking on it or clicking on the plus symbol on its left.
- Go to the Schema menu | Update Schema.
- On the next window, shown as follows, make sure only the first option is selected with Update schema logical information | Update:
Selecting the Update Schema logical information
The other options are related to other Schema and administrative tasks.
- This finalizes the exercise.
The schema can be updated at any time, even if no change has been introduced on the Schema Objects (like in the exercise). However, it is mandatory to do so when any schema object has been modified, created, or deleted. Failing to update the schema might result in memory differences with the physical metadata and eventually a metadata corruption.