Skip to main content

Development of an analytical BI system on SAP Business Objects

Published by admin
14 February 2018
SAP
Manufacturing

Project description 

Development of the corporate data warehouse and analytical system on SAP Business Objects platform, integration with SAP ERP systems, Oracle Siebel SAP Portal. Client: worldwide acting heavy engineering company.

Background of the project:

  • Lack of information about the distributors` activities;
  • Insufficient accuracy and timeliness of data for analysis;
  • The inconvenience by using reports generated manually in Excel.

Goals and tasks 

  • Increase efficiency and flexibility of decision making, as well as transparency of sales data in the distribution network;
  • Get a single information space for analysis and collection of current distributors` data from various sources.

Project scope 

  • Within the project the following solutions were implemented:
  • Corporate data warehouse on the SAP BW platform designed and developed;
  • System of analytical reports on the platform SAP Business Objects designed and developed;
  • Several dozens of reports implemented. The access to these reports is possible via MS Excel, Internet browsers, mobile devices;
  • Integration with the SAP ERP system configured for the following modules: MM, SD, TOPO, FI, DMS;
  • Bi-directional data exchange SAP ERP <-> SAP BW <-> Oracle Siebel implemented;
  • Integration at the user interfaces level of the Oracle Siebel portal, SAP Business Objects, and SAP ERP (Webdynpro) set up;
  • In the SAP ERP system  developed web services for adding contractors and purchase orders from the Oracle Siebel portal

Result 

  • We managed to significantly improve the transparency and control of the distribution network, to optimize the work with deposits and dealers all over the world, it became possible to clearly plan and analyze the current situation in detail.
  • The introduction of the analytical system allowed qualitative formalizing of the new markets development process. It became the effective support for the sales through the dealer network. The analytical system formed a unified approach to work with existing and potential customers.
  • Problems of planning balances in the warehouses of dealers solved. The process of the necessary provisions creation simplified.
  • Reporting across the entire sales geography based on the "purchase funnel" implemented, a detailed analysis of the work of previous periods conducted, users completely turned away from creating "manual" reports, system capacity significantly increased. Thanks to the visualization SAP BO and the use of best practices, the Company was able to move to the new level of information analysis.

Advantages of JET BI 

  • Unique technical expertise and experience in Business Intelligence tools;
  • High quality thanks to the efficient QA processes and the transparent handling of bugs enhancement applications;
  • Bureaucracy minimum;
  • Adjustment to the client`s internal processes, challenges implementation with regard of the specific of the business processes;
  • High level of employees’ motivation.
Start your project now
Expertise
JET BI TEAM
  • Project manager
  • 1 SAP BW Architect
  • 1 SAP BI Consultant
  • 2 SAP BO Consultants
  • 1 SAP ABAP Developer
TECHNOLOGIES
  • SAP BW
  • SAP BO Design Studio
  • SAP BO Web Intelligence
  • SAP BO OLAP for WEB
  • SAP Bex Analyzer
  • SAP Portal
  • SAP ABAP Development
PROJECT TIMELINE
  • 5 months
Question to the expert

We have available resources to start working on your project within 5 business days

2 Senior Developers

1 SF Consultant

2 QA engineers

2 Admins