Challenge Overview
Automate the current manual check records process, by developing an automated Db/2 query job, 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 query job 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 recorded, and current data should be created. Some criteria could potentially be added to identify acceptable variances