Live ERP Reporting versus Data Warehouse Reporting

With BI360 organizations can report live from their Enterprise Resource Planning (ERP) or from the BI360 Data Warehouse (DW).  The question is which one is best for your organization.  Each organization needs to determine which approach is best or whether a hybrid approach is best.  This article will give the benefits of using each option.

There are three main benefits of reporting live from the ERP:

  1. Live Reporting: there is a direct connection from many ERP’s directly into BI360, which allows for live reporting on thousands of fields.  This means that once a transaction is entered into the ERP, then it is available for reporting.  There is not a delay or a process that a user needs to wait for.
  2. Cost of Configuration: BI360 is already pre-configured for thousands of fields in many ERP; therefore, once the software is installed a person can start building reports.
  3. Metadata: as mentioned, there are already multiple modules and thousands of fields already available for many ERP’s, such as all Microsoft Dynamics products, Sage MAS500 and X3, and Epicor Prophet 21.  Standard modules and fields are constantly being added at no cost.

The BI360 Data Warehouse offers many advantages as well:

  1. Speed: using the DW enables organizations to perform many tasks to speed up reports, such as indexing, using a different server which is recommended, and using the flexibility of the DW to enhance report building.
  2. Report Design: Building reports directly from ERP requires hard-coding many times, such as accounts.  For example, cash would be a specific account range and then accounts receivable would be set up as another range.  The DW allows an organization to create trees or attributes so that the report design can point to current assets and the report will dynamically expand.  This will limit the number of groupings, which will greatly enhance speed. Please refer to the White Paper BI360 White Paper – Using Attributes instead of Account Ranges.
  3. Consolidation: consolidating multiple companies from the ERP requires the multi-company tool.  The DW allows companies to build hierarchy trees and report on any level of the tree.
  4. Combine Multiple Sources: gives the ability to combine multiple data sources and report from them using one connection.

There are many advantages to using either solution, but we have many clients that use a hybrid solution.  The recommendation would be to clearly define what reports would be built connecting to the ERP vs. the DW, so that there is no confusion within the organization.  An example of a hybrid approach would be using the ERP for subledgers and the DW for budgeting and financial/operational reporting.

 

This entry was posted in BI360, Solver Operational Data Store (BI360 Data Warehouse module) and tagged , by Corey Barak. Bookmark the permalink.
Corey Barak

About Corey Barak

Along with managing the day-to-day operations of Solver, Corey Barak’s main responsibility at the company is to maximize service quality to our customers and partners. Corey began his Solver career in 1999 as a Senior Business Intelligence Consultant. While at Solver, his responsibilities have ranged from Enterprise Project Manager to Director of Services before assuming his role as Chief Operating Officer in April 2008. Corey’s experiences in successfully implementing Business Intelligence solutions, establishing lasting customer relationships, as well as his many years in operations and an MBA from University of Southern California, have been influential in preparing him for this role

Leave a Reply