BUSINESS OBJECTIVES
A leading Bio Technology global company was in need of a high-performance, enterprise analytical solution to manage their finance, operations and to track their R&D activities. As part of the current operation majority of the reports were Excel based and the data was manually collected across multiple systems, departments which was highly labor intensive and the existing ERP reports were of limited help to meet their analytical needs. Finance team wanted a single view of OpEx, CAPEx and P&L across the organization including their entities in other parts of the world.
SOLUTION
- Infometry built a data warehouse solution keeping enterprise global audience in mind to support Finance, HR and Accounting as part of Phase- 1. Complex Summary and detail reports was built with full drill capability to analyze OpEx and CapEx across all the entities, departments and projects.
- Business Objects XI 3.1 Edge series was used for enterprise reporting and Xcelsius 2008 for the executive Dashboards. Single Sign-on was implemented using Windows-AD and BOBJ Universe user security was implemented at Entity, Department and Project level
- Microsoft SQL Server 2008 was used as Data Warehouse DB platform and SSIS (Sql Server Integration Services) is used as ETL tool. Infometry developed a ETL framework for rapid ETL
- Development which includes standard package framework to handle errors, self-documentation and highly configurable parameters. OLAP cubes are built using SSAS (Analysis Services) to perform Adhoc analysis.
SUCCESS CRITERIA & BUSINESS VALUE
The customer is now able to see summary level OpEx, CapEx, and Accrual reports which are drillable to the sub-ledger transaction comparing the actual numbers including Headcount with Forecast and PLAN numbers. Customers can perform analysis across ITEMS, VENDORS, TIME, Chart of Accounts, Projects, and Departments across the US and other parts of the world.
Dashboards provided a consolidated view of the overall spending and business users can now perform Adhoc analysis using Business Objects WEBI and Voyager. Customers could completely eliminate the manual process of collecting data across multiple depts and eliminate the excel spreadsheets. This along increased their productivity by 80%.