Welcome to this new #BestInMicro article! This is a space where I will be writing about different topics related to MicroStrategy, its use, best practices, and functionalities to get the most out of the tool.
Today we will be talking aboutScanMDIf not handled with caution, this tool can cause many more problems than it fixes. That is why today I will tell you what it is used for, and what are my recommendations when using it.
ScanMD is a tool used to correct inconsistencies in the Metadata, i.e. inconsistencies in the definition of schema objects.
There are situations where, after modifying schema objects, transporting packages, updating tables, facts, or perhaps even the database itself, certain inconsistencies may be found (such as, for example, an invoice pointing to two different tables appearing as a duplicate invoice).
However, this is not a tool to be used regularly. Quite the opposite. Let’s remember that metadata is the foundation of our entire environment. With this tool, modifications are being made and the metadata is being “touched and restructured”. If for any reason in the use of ScanMD you modify something that you should not, you can completely corrupt the environment, and this is why ScanMD should be used only when the inconsistencies have been detected, understood and, whenever possible, verified with MicroStrategy support..
3 different types of analysis can be done with ScanMD: Configuration, all projects, or by specific project.
Although I do not intend to go into detail on how to perform an analysis, it is important to know how to approach the problem. This allows us not only to reduce the risk but also the execution time and the impact of what we are actually correcting.
Although the article at times seems a bit “apocalyptic”, ScanMD is a very useful tool indeed. I have used it several times, and except for some exceptions (which, thanks to following the steps mentioned above, there was no problem) it has solved problems generated, in that case, by the modification of names in the model tables between environments.
Espero que este artículo haya sido de utilidad y los salve de algún dolor de cabeza. Don’t be afraid to leave questions, comments, or ask for a topic that interests you.
* Tu información será utilizada exclusivamente para contactarte en relación al Business Data Master. No hacemos spam ni compartimos datos con terceros.
