If you’re like us, then SQL lives in many, many places across your BI artifacts -- from freehand SQL dataproviders to derived table SQL definitions. How do you quickly search across all derived table SQL and then drill into and compare differences across universe versions ? With MetaMiner, of course!
Comparing things -- particularly data and analytics -- can be a daunting task. When Bob changes a Web Intelligence report on Monday, and Mary makes a change to the same report on Tuesday, how can we be absolutely sure that the information being presented remains the same to the end-user? Easy: Report validation. What this lets you do is track data and appearance consistency after key events like before/after BI migrations or before/after universe or report modifications, or before/after a change to the database.
Perhaps the most often requested feature of SAP BusinessObjects: What is the downstream impact from changing the REVENUE_1 column? What universe/reports will be affected if we drop the DEMOG_OLD table?
Not knowing these answers cost us tens of thousands in added project costs to manual trawl for this information. MetaMiner? 10 seconds.
Keeping track of numerous Crystal Report logons and passwords is, well, not easy! Bulk logon modifier helps bring sanity to the process by quickly identifying specific terms in database names, logon names and more -- and allows users to remap values to new ones en masse, saving tremendous amounts of time with superior accuracy.