Business intelligence is a buzz phrase in today's marketplace-and for good reason. The need for a complete business intelligence software application capable of full-scale reporting has never been more prevalent. Gone are the days of trying to glean key information from a monthly balance sheet, profit and loss statement, and cash flow statement. Today's business leaders demand more insightful, more comprehensive metrics because their ability to serve their stakeholders and outflank their competitors depends on it. What should you look for in a comprehensive reporting and business intelligence solution? Full integration with Accpac ERP, the ability to pull data from anywhere in your enterprise, and total ease of use. You'll find these qualities, and more in our premier business intelligence software package, Accpac Insight.

Accpac Insight

Accpac Insight is an enterprise-wide reporting, budgeting, and consolidations application, ideal for employees in remote offices and disparate departments who need to manage, distribute, and collaborate from a single, unified source. It allows you to quickly capture and integrate information into meaningful reports and securely distribute them across your entire enterprise on demand.

With Accpac as your accounting foundation, you can use Accpac Insight to enhance your business intelligence with sophisticated, customizable budgets, analytics, and reports. The possibilities from this leading business intelligence solution include:

Accpac Insight Core Modules

Accpac Insight integrates with Accpac ERP to create bottom-up budgeting, budget write-back, drill-down, multi-dimensional analysis and other advanced enterprise business intelligence customization capabilities. Providing access to your critical operational and sales data, as well as customer, product, vendor, employee, geographic data and more, you can quickly integrate information into meaningful reports and distribute them across your enterprise in near real time while applying user-level security, ensuring that confidential information remains confidential.

From basic reporting capabilities to full-feature enterprise business intelligence consolidations, Accpac Insight offers a range of components designed to help you build a system according to your particular business requirements.

Author

Author is a wizard-driven tool that allows you to create new templates quickly and easily in Microsoft Excel for pixel-perfect reports. Once your reports have been generated, you have the full capabilities of Excel at your disposal to further format and generate additional charts and graphs. Author for Data Warehouse in conjunction with Accpac Insight Data Warehouse adds functionality of Workbook Generator and Budget Express.

Viewer

The enterprise business intelligence tool Viewer allows you to run reports against the Data Link/Mart and present reports in Excel, extending the value of the data available through your Accpac ERP system. Featuring powerful cross-module drill-down capabilities, Viewer lets you drill down to supporting transaction detail and even "drill around" from one module into another, making it simple to view underlying transactions and subtotals. Viewer for Data Warehouse in conjunction with Insight Data Warehouse adds functionality of Workbook Refresher, runtime version of Workbook Generator, Budget Express user and Budget Express Writeback.

Web Deployment Server

Ideal for mobile and remote staff, Web Deployment Server offers you the ability to generate reports and publish them on the Internet or a company intranet. Authorized staff can view the reports through a standard Web browser. You can maintain near real-time reporting and provide drill-down capabilities without the need to install any software on users' computers beyond their Web browsers.***

Enterprise Business Intelligence Budgeting**

Enterprise Business Intelligence Budgeting can be used to create very complex models containing multiple worksheets. You can deliver templates for end-user data entry and manipulation, and consolidate input into a single Data Mart to prepare an end-user budget in a true bottom-up fashion.**

Consolidations**

Manage the consolidations process and create financial statements that illustrate key financial performance indicators. Consolidations produces merged accounts for statutory or management reporting purposes. Multiple unrelated databases can be consolidated into a single set of financial reports, so that employees, branch offices and partners can operate with a single, unified view of financial data at any time.****

Data Warehouse

Accpac Insight Data Warehouse module is deigned to fit every business need, delivering a powerful financial reporting solution by optimizing and correlating your data into a single, easy-to-manage database.* The Data Warehouse module acts as a warehouse for your vital information, allowing you to extract only the key data you want to report on. By capturing only the data you need, you eliminate the time-consuming task of sifting through irrelevant information and can focus on business at hand. It also contains vital budgeting and scheduling capabilities, along with special security features to ensure that only authorized personnel have access to key data. Additionally, it includes replication capabilities that let you synchronize your data warehouse across multiple locations – making key information even more accessible to employees across the enterprise.

Universal Database Adaptor (UDA)**

Accpac Insight can connect and integrate with other enterprise business intelligence software applications via the UDA module. It integrates data from other applications and databases into your Accpac Insight reporting system using ODBC connection. Using UDA, Accpac Insight becomes your one-stop reporting and analytical solution for enterprise-wide data.**

Alerts**

Alerts delivers the information needed to create highly responsive, proactive, customer-facing organizations. It automates the reporting process in the enterprise by scheduling data warehouse filter updates, report generation and report refreshes. Scheduling makes it easy to automate the execution of reports by providing report database and period index parameters that are applied to the execution of each report. You can even schedule reports to run after business hours to take advantage of underutilized computing resources that typically sit idle during this time.**

* Requires the Author for Data Warehouse module. ** Requires the Data Warehouse module. *** Requires the Viewer module on the Web server. Web Deployment Server is limited to 20 concurrent users. **** Requires the Data Warehouse module and MS SQL Server database.

Create pixel perfect reports in minutes with complete drill down capabilities.

Deploy reports over the Web to key personnel throughout your company.

Create a budget model with multiple spread methods using a bottom-up budgeting approach.

Consolidate multiple unrelated company databases into a single set of reports for a unified view of key data.

Business intelligence is a buzz phrase in today's marketplace-and for good reason. The need for a complete business intelligence software application capable of full-scale reporting has never been more prevalent. Gone are the days of trying to glean key information from a monthly balance sheet, profit and loss statement, and cash flow statement. Today's business leaders demand more insightful, more comprehensive metrics because their ability to serve their stakeholders and outflank their competitors depends on it. What should you look for in a comprehensive reporting and business intelligence solution? Full integration with Accpac ERP, the ability to pull data from anywhere in your enterprise, and total ease of use. You'll find these qualities, and more in our premier business intelligence software package, Accpac Insight.

Accpac Insight Data Warehousing

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 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 MS 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.