Please contact o2olap direct for the specific reference client information and the original user story. Relevant general ledger and other information have been omitted for legal and confidentiality reasons.

• An automated, user friendly, robust and flexible reporting platform for financial reporting for multiple formats including Management, Statutory and Regulatory reporting.
• A flexible and scaleable solution that could be easily integrated with any general ledger system and potentially with other systems in the Group with the aim of improving management information.
• An easily accessible database to retrieve and input current and historic financial data.
• Current and historic reporting capabilities and functionality for actual, budget, forecast and variance analysis.
• Ad hoc querying facilities and the ability to create a variety of schedules (e.g. consolidation schedules, trend analysis and graphs) in Excel or other format.
• Control over all aspects of the solution so that the finance department could develop it as and when the business developed and changed, without reliance on the IT department.
• A well supported software and hardware infrastructure, whilst leveraging the existing investment in software and hardware.
• The capability to go beyond financial reporting and provide a scaleable and flexible platform for other Group solutions (e.g. a data warehouse). 
• The integration to Microsoft Office and Microsoft development environments.

Based on our investigations to achieve these requirements, XXXXX decided on the solution offered by o2olap, where their product ‘o2olap for Excel’ leveraged the robust, scaleable and ‘open’ Microsoft SQL Server and Analysis Services (OLAP) platform. At the same time, XXXXX utilized its existing software investments in Microsoft Windows 2000, Office 2000 and GL Line 50.

The o2olap project has proved a great success with the acceptance of the solution by users being due to the familiar Excel interface. Using Excel as the Report Writer and modeling environment facilitates a friendly, easy to use, fast financial reporting and development environment. Using the ‘o2olap for Excel’ interface enables us to create ad hoc reports from our cubes (databases) of information without having to know or program any complex queries. We can model Excel reports on-the-fly with reports referencing multiple cubes with centralized control settings. Also having the ability to efficiently capture data through Excel to Analysis Services has enhanced the way our department works and operates. Of paramount importance and benefit has been the improvement in the quality of information and the quantum leap in the speed of output due to overcoming the inherent time consuming tasks that are common in a spreadsheet reporting environment. Integral to the success of the solution is the automated data loading process using Microsoft’s Data Transformation Services (DTS) and the fact that we now have a more structured way to maintain and update our reporting application.

FINANCIAL REPORTING BENEFITS INCLUDE:

• Multi-hierarchical reporting enabling the production of consistent and reconciled Management, Statutory and Regulatory information for each entity as well as the consolidated Group. 
• Comparative, standard and ad hoc reporting of both current and historic data. Specific reporting periods are easily accessible and comparable.
• Automated and progressive forecasting functionality. The cumulative forecast capability and inputting allows users to assess their past and future predictions whilst maintaining and comparing version histories. The forecast template allows input by entity, ledger account and period.
• Budgeting integration and tools to simplify the budget process. Inclusive are budget templates for data input – by entity, ledger account and period. 
• Adding new companies or ledger accounts to the existing reporting structure is simple, whilst maintaining the confidence in the financial integrity of the data.
• The numbers are simple to audit and additional year-end audit benefits include being able to generate audit schedules ‘on the fly’.
• A task menu stores multi-dimensional templates and work options which significantly reduces spreadsheet proliferation.
• Total confidence in the numbers due to consistent data processing and the natural reporting structure associated with OLAP solutions.

FINANCIAL REPORTING SOLUTION:

Infrastructure

• GL General Ledger for accounting transaction data.
• SQL Server warehouse for financial information. 
• Analysis Services cubes holding structured reporting hierarchies of pivotal reporting data.
• Excel and o2olap for dynamic multi-dimensional spreadsheets for data entry and report writing. 
• Excel formatted reporting templates for consistent output. In XXXXX’s case existing Excel reports were also modeled to reference the new cubes of data.

o2olap for Excel Some of the key and useful features include:

• The Cube Browser generates any user defined, ad hoc, multidimensional, free-form, Excel report. Therefore you can create and model any financially friendly output that you require.
• The Cube Browser enables users to quickly summarise any combination of members (i.e. specific data) in the dimensional hierarchies without having to write formulae. 
• Data output is defined by the structure of the cubes and their dimensions (i.e. data categories). The core cube structures were defined during implementation and continue to evolve with the business.
• Multiple cubes can be browsed in the same Excel worksheet with centralized control for dimension settings. You can even model existing worksheets to the cube data.
• Multiple dimensional hierarchies are maintained through Excel and are automatically updated for new account or entity members. Existing reports automatically have access to the changes in structure and referencing.
• Flexible and efficient input of data, i.e. see the results as you input changes and recalculate ‘on-the-fly’.
• Provides a good platform for creating trend, comparative analysis and graphs.
• Publish data to an intranet environment, or any other format, including Word, Adobe PDF and PowerPoint. 
• ‘Stop light’ capabilities and summarization for indicating significant variances or adverse conditions.
• The multidimensional reports now replace multiple spreadsheets and workbooks. Each report giving users access to any entity, account, time period, currency or version (actuals, budget, forecast, variances) of data.

CONCLUSION:

Part of the success of this project is due to o2olap’s vast experience in developing and delivering OLAP reporting solutions. o2olap provided the solution overview, project plan, detailed on-line help manual and collaborated on the development of a customized XXXXX user manual. This enabled the XXXXX solution to be developed quickly and accurately enabling XXXXX to achieve the project objectives. The ability of o2olap to provide support and training both onsite and real-time through the internet makes troubleshooting and training highly effective and efficient. XXXXX has experienced excellent project management, training and after sales service.

XXXXX now has a highly effective, accountant friendly, financial data warehouse and reporting system that has halted spreadsheet proliferation in the finance department. It has also significantly improved the efficiency and quality of management information and financial data.

Looking forward, XXXXX is able to take advantage of some of the new and innovative features available through ‘o2olap for Excel’ and Microsoft’s Analysis Services. XXXXX is also able to expand the o2olap solution offering to other system areas including customer relationship management, data feeds, fund accounting and settlements systems.