Accpac Business Intelligence & Reporting
Sage Accpac Data Warehouse
Sage Accpac Business Intelligence | Data Warehousing Software
Sage Accpac Insight Data Warehousing delivers a powerful business intelligence 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 data warehousing 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 warehousing 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 business intelligence 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 Microsoft® SQL Server) based on a clearly defined business intelligence 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 business intelligence 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 warehousing 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.
 | Questions? Please call 858.550.5900 |
