Steps to Create an FNP Dashboard

1. Run Report 101

• a. Login as User type (ProAdmin for all sites)
• a. Specify the Sites (null: requests all sites)
• b. Specify the required reports (null: Creates all dashboard reports)

2. Check 101_ERRORS_T
3. Run Generate Queries
4. Run GenerateExcelZip
5. Downlaod from ZippedData and use the excel sheets

Finish First Live Dashboard 1/3/2013-28/2/2014

1. Re-run the Quarterly Sheets
2. Insert into zip
3. Load zip
4. Email National Unit with details
a) date range
b) sub-total checks
c) next action

Started Blogging