General Ledger

The integration of any OLAP and business intelligence solution to a General Ledger is critical to the reporting and operational effectiveness of a financial reporting solution. Many General Ledger manufactures having got this wrong, resulting in clients developing and integrating their own OLAP reporting solutions to meet their specific needs. An example of this would be where an international company consolidates the financial transactions and trial balances from different international subsidiary company general ledgers which have different structures. Often local reporting requirements can influence the selection of a general ledger and hence the solution as well. OLAP Office™ consultants have been integrating and developing OLAP, business intelligence and financial reporting applications since 1991.

Connecting and Reporting Your Dynamics ERP Cube Data

Whether you are using Dynamics AX, GP, NAV, SL or any other Microsoft Analysis Services cubes, you can use OLAP Office Explorer to slice and dice your cube data into any report format. OLAP Office Explorer is the first free-from pivot table on the market that can slice financial statementsBy this, we mean your pivot table becomes your report. The revolutionary pivot table approach allows for significantly more flexibility than has been available in the OLAP, BI and MS Office arenas. Simply insert blank rows, columns, report headers, non-cube data and calculations into your pivot table; even move things around to fit your reporting requirements. It is that flexible! Leverage your existing reports and merely model the OLAP Office Explorer functionality into your report. Make use of the dynamic functionality where the reports automatically update themselves, if there is a change in structure. …. and more.

OLAP Office also works with partners to provide reporting solutions for some of the major ERP products and data sources available. These include

  • Microsoft Dynamics
    • Microsoft Dynamics AX (Axapta) 
    • Microsoft Dynamics NAV (Navision)
    • Microsoft Dynamics GP (Great Plains)
    • Microsoft Dynamics SL (Solomon)
  • JD Edwards
  • Oracle
  • Peoplesoft
  • Epicor Vista / Vantage / DataFlo
  • SAP
  • Syspro
  • Lawson
  • Sage

Cubes and reporting solutions can be up and running in a very short time for user with budgeting and forecasting inclusive in the solutions. Please contact us for more information or if you would like to use OLAP Office Explorer in your partner solution. 

Scroll to Top