Sage Accpac Intelligence (AI)
Posted by Plus Consultants on Wed, Jun 23, 2010 @ 12:01 PM
by TK Haran (tk@plus.ca)
1. What is Accpac Intelligence?
Organizations are increasingly suffering from information frustration. Having to manage large volumes of data, and needing to report from several databases and using inflexible reporting tools. Information delivery and user empowerment is increasingly taking centre stage in all enterprises with a resulting growth in the end user query and reporting (EUQR) category of the business intelligence market.
Sage Accpac Intelligence is an innovative software reporting solution that offers users, in organizations of all sizes, a powerful and intuitive reporting tool to take control of their own reports. It introduces a revolutionary approach to leveraging the reporting power of Microsoft Excel and protects and extends organizations existing IT skills and investment.
2. What Components does it have?
- Report Viewer
- Security Manager
- Report Manager
- Connector
- Analysis
- License Manager
3. Description of above components
- Report Viewer-This is used to view or to run the standard/shipped reports.
- Security manager- The Security Manager is an Administration tool that lets you (as System Administrator) manage Roles (User Groups) and assign Users and Reports to each Role. When security is enabled the User will be required to login and then will only have access to the Reports selected for the Role that User belongs to.
- Report manager- The Report Manager Interface allows users to design and manage their own reports and to display results in Microsoft Excel.
- Connector- The Connector allows an organization's system administrator to make a connection to their database in order to access the relevant tables for reporting purposes. It also allows an organization's system administrator to configure the metadata to empower the users to create their own reports.
- Analysis- An OLAP (On Line Analytical Processing) database allows business decision makers to analyze data that has been sorted into hierarchical structures. The data is static, so all mathematical aggregations can be built into the database query, thereby providing a more efficient and resource friendly means of reporting. This data warehouse can then be pulled into a pivot table within Excel, where the user is able to drill down into the report, using the hierarchical dimensions built into the query.
- License Manager- The License Manager provides a snapshot of your Sage Accpac Intelligence licenses and module configuration.
4. What Components come with a standard Accpac 5.6 installation?
- Report Viewer (1 user license)
- Report manager (1 user license)
- Security manager
5. Benefits of "AI"
- Works with a standard Microsoft windows look and feel.
- Reduces the need for IT department intervention.
- Reduces the need for custom complicated report creation by hired consultants.
- Consistent format (MS Excel) for reporting across multiple data sources.
- Business intelligence can become a standard desktop tool.
- Avoids inefficiencies in the report development life cycle thereby improving productivity.
- Empowers the user, thereby improving overall productivity.
- Optimizes return on investment by leveraging your existing IT infrastructure.
- Extends MS Excel skills rather than requiring learning of a new set of software skills.
6. Is there standard report/s available?
Yes and the shipped reports are as follows,
- Financials- Financial Report S, Financial Report D, Financial Report SB,
- Dashboard Analysis, Financial Trend Analysis
- Sales Master, Purchase Master, Inventory Master