End
Datamart Generator
Analyst
Database
Datamart
Generator
•
Datamart can be MS SQL
Server or Access
•
Data appended to existing
datamart
Excel
•
Worksheet
•
Workbook
WWW
Datamart Generator Process
1.
Appending Existing Datamart
•
Can add new periods of data to an existing Datamart
•
Can replace an existing period in the Datamart
2.
Create a New Datamart
•
Allows selection of Reporting Hierarchy or Structure to be used
•
Can select multiple periods of data e.g. this year and last year
•
Can select both Actuals and Budgets
•
Can be used for History or archiving
3.
Act as a Source
•
For normal Analyst Reports
•
Or for Web Product
4.
Loading back into Data Warehouse
•
Although not shown, a mechanism is available to write data back to data warehouse using the Universal Filter core technology
