Alchemex OLAP Module
OLAP stands for On Line Analytical Processing, and supports multi-dimensional analysis of information. It is the process of extracting high volumes of information from a data source (this could be a transactional system or a data warehouse) and compressing it into a format that is optimized for multi-dimensional analysis.
Why is OLAP valuable?
- OLAP can provide insight into a company’s business that other business applications cannot. ERP can provide transactional elements or customer details but it cannot yet rank customers in order of importance, segment suppliers according to order-fill parameters, or identify trends.
- OLAP is flexible; OLAP tools provide an easy way to analyze data by simply dragging and dropping dimensions and facts into the appropriate locations.
- OLAP takes it a step further by answering the “what if” and “why” questions. The OLAP module enables decision-making about future actions, which is typically more complex than simply summoning data.
- OLAP is useful in helping to determine why data appears the way it does. By progressively expanding portions of levels within a dimension, it is possible to drill-down into progressively more detail, to spot a trend or a problem. OLAP tools also allow a breakdown structure of the data where a single piece of data can be dissected into a series of levels to identify something interesting.
- OLAP empowers you to analyse data in your database that is not stored in a suitable format to achieve the type of analysis you have required, prior to OLAP making it possible.
Why is Alchemex OLAP for ACCPAC valuable?
- Alchemex OLAP delivers business intelligence that interacts with a company’s ACCPAC ERP system, providing a low-cost integration into the existing IT infrastructure.
- These reports are invaluable in identifying trends in large volumes of data and eliminate Excel’s row limitations.
- Pre-defined Financial, Sales and Inventory cubes are incorporated into the module, so no source database knowledge or direct database queries are required. The use of the Alchemex Report Manager with its Excel interface means that OLAP technology is now much more accessible in terms of cost and ease of use. The user does not have to be an expert in business intelligence, but simply know how to use spreadsheets.
Why should ACCPAC users take advantage of this BI solution?An ERP system produces significant amounts of data which can, if interrogated correctly, provide valuable insights to a company’s CEO, Sales Director or Marketing Director. The Alchemex OLAP module for ACCPAC puts powerful OLAP technology into the hands of the business users by providing pre-defined cubes and pre-formatted reports in the familiar face of Microsoft Excel.
|
