Challenge Overview
Automate the current manual check records process, by developing a tool that runs multiple SQL queries (1 for each Essbase/TM1 dimension/Outline update), after STAR A2P jobs are run to update Outline changes to DB/2 tables.
After the tool runs, the output should automatically be appended to, and compared with prior run data in existing excel sheets. An output variance report for any discrepancies between last record and current data should be created. Some criteria could potentially be added to identify acceptable variances.
Final Submission Guidelines
Refer to the assembly specification for details.