even if you don't have version 9 of MicroStrategy, just get it. ScanMD update which has come up after ages (not like frequent HF, SP or GA of MicroStrategy). It is toooooo good, even though I have't used yet. Have a look at the tech-note to downlaod new version.
The biggest problem with ScanMD is it would show you tons of errors even though there is just ONE discrepiency 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.
Showing posts with label ScanMD. Show all posts
Showing posts with label ScanMD. Show all posts
Wednesday, April 01, 2009
Thursday, March 19, 2009
Scan MD and MD Doctor
While working on metadata, there are chances that MD may get corrupt. Only reason for corruption of MD is MicroStrategy programmers NOT you (No way), unless you have manually fiddled with the metadata. One small change can messed the metadata forever, some time impossible to recover.
There are two types of discrepancies in MicroStrategy
Logical discrepancies: Using desktop you can create/delete several objects. Sometime deletion of the objects doesn’t get reflected in metadata and they get deleted in metadata but still available in front-end. Now such a mis-match in case of schema objects is simply killing, because it won’t let you update schema at all. Imagine not having ability to update schema. Using ScanMD is not an easy task. ScanMD shows 95% for false errors as discrepancies. Engine team of MicroStrategy, Inc. needs to update the tool. For one error, you may have to go through 100+ errors. You can verify the error easily by having project opened side by side. NEVER EVER FIX A FALSE ERROR.
Physical discrepancies: There are not just 10 DSS tables that make metadata, there are several more database objects that are created for metadata; e.g., triggers, views. If any of these objects are messed up, you have a physical discrepancy in your project. I’ve never worked on MD Doctor and look forward some information from you.
This blog is not exhaustive and 100% as I certainly do not believe the bugs in MicroStrategy are only source of discrepancies in metadata.
There are two types of discrepancies in MicroStrategy
- Logical
- Physical
Logical discrepancies: Using desktop you can create/delete several objects. Sometime deletion of the objects doesn’t get reflected in metadata and they get deleted in metadata but still available in front-end. Now such a mis-match in case of schema objects is simply killing, because it won’t let you update schema at all. Imagine not having ability to update schema. Using ScanMD is not an easy task. ScanMD shows 95% for false errors as discrepancies. Engine team of MicroStrategy, Inc. needs to update the tool. For one error, you may have to go through 100+ errors. You can verify the error easily by having project opened side by side. NEVER EVER FIX A FALSE ERROR.
Physical discrepancies: There are not just 10 DSS tables that make metadata, there are several more database objects that are created for metadata; e.g., triggers, views. If any of these objects are messed up, you have a physical discrepancy in your project. I’ve never worked on MD Doctor and look forward some information from you.
This blog is not exhaustive and 100% as I certainly do not believe the bugs in MicroStrategy are only source of discrepancies in metadata.
Subscribe to:
Posts (Atom)
