sage
End
Workbook Generator
Dept 4
• Worksheet
• Workbook
Dept 3
• Worksheet
• Workbook
Dept 2
• Worksheet
• Workbook
Dept 1
• Worksheet
• Workbook
Workbook Generator:
• Control Sheet
• Workbook Template
Analyst
Database
Workbook Generator Process

1.Source databases are any valid analyst database
•The source database is stored in the template to be reproduced. Therefore report packs containing more than one data source can be created
2.Analyst Template Workbook
•Workbook is generally an Analyst book but not necessarily
3.Profile Workbook
•Contains information to allow the WBG to run…..
•Departments
•Accounts
•Email addresses and Network Locations – This means one source of maintenance
4.Running the Workbook Generator
•Can be run immediately or scheduled as a command line is available
•Can be run from any third party scheduling tool.