ORACLE discoverer migration to bics

Business Problem

  • Oracle Discoverer is a popular reporting tool for Oracle E-Business Suite (EBS)

  • It is an older product and does not work with data from any source other than EBS

  • Discoverer is no longer a supported product and as a result Oracle will provide no further product enhancements or fix any software problems

  • Customers of Oracle Discoverer need to find an alternative reporting solution which is fully supported

Solution

  • Oracle Business Intelligence Cloud Services (BICS) is an excellent choice as a replacement for Oracle Discoverer. BICS is a cloud based, SaaS version of Oracle Business Intelligence

  • Combination of methodology and developer code

  • Pre-built reports and metrics delivered via BICS Dashboards

  • Pre-built schema for out of the box Discoverer views

  • Pre-built extract programs for initial and incremental load of Discoverer data into BICS Database

  • Pre-built E-Business Suite security extended to BICS

Salesforce integration with bics

Business Problem

  • Integration with Salesforce.com is not as simple and straightforward

  • There are several design-time and runtime considerations

  • Cloud based analytics using Salesforce.com and real-time data integration

Solution

  • Using ODI to integrate Cloud Applications (Salesforce.com)

  • JDBC drivers from datadirect

  • ODI knowledge modules to connect to BICS

  • Dynamic ETL process will ensure a consistent pipeline of information that will fuel insights and analytics that will, in turn help business decision making.

E-business suite fixed asset analytics on bics

Business Problem

  • Need for an automated way of managing all standard accounting and operational tasks related to acquiring and maintaining an asset within an organisation

  • Organizations can monitor and report on assets throughout an asset’s lifecycle

Solution

  • Fixed Asset Analytics is a natural extension of Oracle Financial Analytics, Oracle Project Analytics, Human Resources, and Oracle Inventory

  • Integration is available for Projects, Payables, and General Ledger modules

  • Using ODI for data integration from on-premise E-Business Suite to Oracle BICS

  • Pre-built ETL Mappings, Dashboards, Reports

Google analytics integration with bics

Business Problem

  • To improve profitability, every company requires multiple tools to understand their customers and identify potential customers

  • How can companies track inaccurate conversion attribution, bad budget allocation, and incorrect strategic business focus?

  • Make smarter marketing and business decision making

  • Google Analytics allows you to seamlessly activate your data to improve marketing campaigns and experiment with new channels and content

  • One comprehensive BI tool in the cloud

Solution

  • Using Cloud Application technology in ODI to integrate Google Analytics

  • JDBC drivers from data direct

  • ODI knowledge modules to connect to BICS

  • Dynamic ETL process will ensure a consistent pipeline of information that will fuel insights and analytics that will, in turn help business decision making

E-business suite hr analytics on bics

Business Problem

  • HR organizations that do not have modern IT solutions are finding it harder to create business value and a great employee experience.

  • How to measure and improve key HR metrics.

Solution

  • HR Performance – Correlate financial measures with key workforce metrics to demonstrate HR’s strategic value in the organization

  • Workforce Development- Provide better workforce planning with easy visibility to global staffing, retention and contingent labor usage, and improve workforce performance

  • Compensation – Monitor payroll costs, and spend on overtime, and variable compensation

  • Recruiting – A complete set of metrics measuring the efficiency and effectiveness of the entire recruitment life cycle including post-hire employment

Jde procurement & spend analytics on bics

Business Problem

  • Organizations need deep customer insight into orders and inventory data with JDE as source systems

  • Make better decisions at each stage of the order lifecycle

  • Enhance their current supply chain and order management processes to improve financial performance and customer satisfaction

Solution

  • Using JDE as system source and pre-built analytics in cloud using ODI as ETL Engine

  • Pre-packaged ETL in ODI

  • Pre-built Dashboards and Reports for Procurement and Spend Analytics

  • Pre-built metrics and KPIs

  • Order Management , Order  fulfillment, Inventory analytics

Jde supply chain analytics on bics

Business Problem

  • Gain visibility into direct and indirect spending across different accounts using JDE as source systems

  • Identify opportunities for consolidation and reduction of costs

  • Provide transparency across finance, operations and procurement to improve procurement processes

Solution

  • Using JDE as system source and pre-built analytics in cloud using ODI as ETL Engine

  • Pre-packaged ETL in ODI

  • Pre-built Dashboards and Reports for Procurement and Spend Analytics

  • Pre-built metrics and KPIs

  • Spend Analyser, Supplier Performance,  Procurement Performance

PREDICTIVE analytics on bics

Business Problem

  • Advanced analytic applications were very high ROI but also very high cost

  • Reduced cost, quick to launch, and flexible predictive analytics solution

Solution

  • Provide Oracle R Enterprise as a Hosted Cloud Service in Oracle Managed Cloud Service

  • Pre-defined R packages to do predictive analytics and sentiment analysis

  • Export the results in rich visualization dashboard and reports in BICS

  • A combination of IaaS and PaaS Solutions in Oracle Cloud Software Strategy

SAP Financial Planning & Budgeting on PBCS

Business Problem

  • Customers relying on Oracle EPM cloud software in conjunction with SAP as a source system

  • Integration between the SAP and Oracle PBCS

  • Ability to prepare and extract data from the SAP transaction systems

Solution

  • Pull data from SAP ERP Financials modules – General Ledger, Cost Center , Profit Center

  • SAP Adapter using ODI to pull data into pre-built templates/dimensions

  • Load data into PBCS for financial planning & consolidation

  • Pull data from SAP ERP Financials modules – General Ledger, Cost Center , Profit Center

Capex Planning & Workforce Planning with PBCS

Business Problem

  • Capex and Workforce planning in PBCS

Solution

  • Pre-built templates for modules like Capex and Workforce planning based on EPM Hyperion

  • Using FDMEE to load data into PBCS

  • Build dimensions needed for Capex and Workforce planning

  • Will enhance this solution on Enterprise PBCS in future.

ODI Framework to load PBCS from EBS

Business Problem

  • Current PBCS data loading with FDMEE version in Data Management

  • Automate the process  of data loading from EBS to Oracle PBCS

Solution

  • Load data from on-premise EBS system into pre-built dimension templates using ODI

  • Load data from templates files into PBCS using FDMEE via DM

  • Automating the process of data loading using ODI

  • Pre-built templates for dimensions can be extended and customised

EPM On-Premises to PBCS Migration Utility Tool Kit

Business Problem

  • On premise Hyperion EPM to Oracle Planning and Budgeting Cloud Service (PBCS) migration tool kit and checklists

Solution

  • Migrate the Security Model

  • Export Artifacts from the On-Premise Deployment

  • Export data from the EAS console

  • Zip the Exported Artifacts and Upload the Zip Files to the Planning and Budgeting Cloud Service Workspace

  • Import Artifacts to Oracle Planning and Budgeting Cloud Service

  • Manually Migrate Essbase Data to Oracle Planning and Budgeting Cloud Service

  • Manually Define Business Rules Security if the Calculation Manager Module

  • Check the Migration Status Reports and Validate the Application

PBCS & BICS Together Financial Management Analytics In Cloud

Business Problem

  • Complete reporting application for senior finance management which provides pre-built dashboards and analytic reports for the financial planning and budgeting results.

  • Solution should be widely deployed, and can be combined with information from many others source

Solution

  • Pre-built BI Cloud Application  providing any PBCS customer with a simple way to include Financial Planning and Management  information into dashboards

  • Financial Management Dashboards

  • Income Statement

  • Balance Sheet

  • Cash Flow

  • Key Performance Indicators

  • Financial Statement Report – Monthly and Quarterly basis

Previous tabNext tab