130 likes | 252 Views
Cameron Power Project Owner – Financial Reporting Upgrade Australian Red Cross Blood Service Session ID: CON7730 Session Title: Customer Panel: Real-World Value with Oracle BI Applications Venue / Room: Moscone West - 3016 Date and Time: 10/1/14, 12:45 - 13:30.
E N D
Cameron Power Project Owner – Financial Reporting Upgrade Australian Red Cross Blood Service Session ID: CON7730Session Title: Customer Panel: Real-World Value with Oracle BI ApplicationsVenue / Room: Moscone West - 3016Date and Time: 10/1/14, 12:45 - 13:30
https://www.youtube.com/watch?feature=player_embedded&v=slQahKU4TEshttps://www.youtube.com/watch?feature=player_embedded&v=slQahKU4TEs
Previous state financial reporting Data source Finance process management Reporting tools Discoverer Cash Management Inventory Purchasing Payables Receivable's Project Accounting Salary Analysis Assets eBus General Ledger BI Publisher Report Manager Excel (GL Wand) Sub-ledgers (eBusiness modules) Essbase Excel (SmartView) Hyperion Planning / Product Costing
Future state financial reporting Vision Future state Impact Interim Current state Roadmap Time
Finance Reporting Platform enablement Objectives Management Reporting Finance Intelligence / Analytics Technology as an enabler not a barrier
Option assessment • Low cost option – leverage Essbase and ODI • Build a Finance schema within the existing organisation data warehouse • Build a data warehouse using OBIEE technology • Implement OBI Applications as a pre-packaged solution
Chosen option • BUY • Purchased OBIEE • Purchased OBIA for the following: • Financials • Procurement • Supply Chain • Projects
Future state financial reporting Data source Finance process management Reporting tools Cash Management Inventory Purchasing Payables Receivable's Project Accounting Salary Analysis Assets OBIEE / OBIA BI Answers Dashboards Org Data warehous eBus General Ledger Sub-ledgers (eBusiness modules) Cost Centre Reporting Excel (SmartView) Essbase Hyperion Planning / Product Costing
Reporting Outcomes • Immediate (< 3 months) • Replace existing Discoverer reports using BI Answers • Develop project reporting using OBIA • Replaced Report Manager cost centre reports • Medium term (<12 months) • Developed non-financial Inventory operational dashboards using OBIA • Developed drill down reports to enhance cost centre reporting
Reporting Outcomes • Long-term(> 12 months) • Unpack remaining OBIA modules • Financials • Procurement • Integrate supplier data into data warehouse • Develop dashboards for other operational areas
Issues encountered • OOTB is not OOTB • Capacity to deliver • Over promising • Data quality