Even if you don’t have version 9 of MicroStrategy, just get it. ScanMD update has come up after ages (not like frequent HF, SP or GA of MicroStrategy). It is toooooo good, even though I haven’t used yet. Have a look at the tech-note to download new version.

The biggest problem with ScanMD is it would show you tons of errors even though there is just ONE discrepancy in your metadata. So, weeding out one error is a mammoth task. If you fixed a false error, you schema would go for toss forever and even MicroStrategy can’t repair it.

Look at the last screen shot in tech-note which says just 4 errors. My God! Just 4. I have ran ScanMD on fresh metadata and found 100+ error. Don’t believe it. Just install a fresh v8 and run the older version of ScanMD and you will see. Good job Engine team.