Sage Accpac Insight Data Warehouse delivers a powerful reporting and analytical solution by optimizing and correlating your various subsets of data into a single, easy-to-manage database.
The Data Warehouse module in conjunction with Author for Data Warehouse and Viewer for Data Warehouse modules delivers the following functionality:
Budget Express
Budget Express turns a Sage Accpac Insight report into a fully functional budget model workbook. It provides a quick and easy way to define up to five basic spread methods, automatically defines mapping to the data warehouse database based on a users’ chart of account structure, and enables you to write the budget data back to the reporting database.
Job Scheduler
Job Scheduler makes Insight reporting as near real time as possible. It schedules filter profiles so that the reporting database is updated with the most current information on regular intervals. You can even schedule updates to run after business hours to take advantage of underutilized computing resources that typically sit idle during this time.
Security
Security provides access (only available if data warehouse is based on MS SQL Server) based on a clearly defined reporting structure. Security is implemented at the account structure, not the report level, limiting what data users can see. Users are assigned to profiles, and when reports are run, access is only granted to the rows in the data warehouse as indicated by users' assigned profiles.
Workbook Generator
Workbook Generator creates procedures for generating reporting or budgeting workbooks from any valid reporting database (data link or data warehouse). It contains all the information needed to allow the distribution of workbooks, providing a single source of maintenance. It can run manually, or be scheduled using scheduling tools such as, Windows Task Scheduler and Insight Alerts.
Workbook Refresher
You can schedule a workbook for automated refreshing with the Workbook Refresher using Windows Task Scheduler or Insight Alerts.
Budget Express Write Back
Write back captures data from an Excel file and writes it to the data warehouse database. For example, it can capture budget information from all departments and divisions and store it in the data warehouse for future reference.
Data Mart Generator
Data Mart Generator creates tailored Data Marts from existing reporting databases, automates and schedules the publishing of Data Marts, synchronizes one or more Data Mart(s), summarizes reporting structures and provides access via Microsoft SQL Server and Access.
