BI Data Analytics

Build test cases to detect below common Reporting issues Any blank column on the report for all selection Rows repeating for same dimension and attributes Double addition for amounts for same dimension for different selections Report filtering data for all selections ( default, individual, multi select) Download options working for all selections Query properties and naming conventions followed  Output getting distorted in pdf/excel or parameters, standard logos are not displayed

MotioCI can be helpful to do impact analysis for any Backend DB changes. Steps: 1. Create queries for packages for each query subject. Please remember to put filters to limit data and have good performance. 2. Create test cases for each of them. 3. Run Test Scripts via MotioCI 4. Schedule them to run with comfortable frequency and failure notification. Once a test case fails, you can verify reason for failure (  table lock vs, DB changes) and get them corrected.