Construct Refresher Advisor (CRA) for Management Reporting Applications – Lakshmi Narayan

Problem Statement : Currently the decision for releasing the MRA cubes during critical QC failures are relied upon individual perceptions which may lead to inappropriate release of data to the users, so it was felt appropriate to come up with an automated Decision Support Tool to provide guidance in such situations, based on the generic parameters that we are aware of.

Proposed Solution: Decision Support Tool “MRA – Refresh Advisor” was developed using Excel VBA to validate the situation based on a set of rules and scenarios, to suggest whether we need to perform a Re-Run of the production refresh process or not.
https://hexaware.com/