Implementing Oracle Financial Analyzer: Delivering Value-Added Business Processes With Oracle Analytic Solutions

by Cunningham, John; Stevens, Guy; Dean, Fred

• ISBN13: 9780201675276
• ISBN10: 0201675277
• Edition: CD
• Format: Paperback
• Copyright: 2001-05-01
• Publisher: Prentice Hall

Summary

(Pearson Education) Complete guide to the financial analysis software Oracle Financial Analyzer, OFA, with coverage of everything from backup and recovery to database design. The CD-ROM features an interactive project with a Web interface. Also includes a companion Web site. For project managers and other professionals. System requirements not listed. Softcover.

Table of Contents

Preface	ix
Introduction	1	(5)
Overview of Oracle Financial Analyzer	1	(2)
Objectives of this book	3	(1)
Road map for the book	4	(2)
Project Scoping for Oracle Financial Analyzer	6	(33)
Identifying the business processes to which OFA can be applied	7	(21)
Packaged solutions as part of the solution architecture	28	(5)
Common data sources and business processes	33	(6)
Oracle Financial Analyzer Key Features	39	(60)
OFA key features and functions	39	(45)
Controlling the flow of structures and data	84	(6)
More workstations and their functionality	90	(9)
Enterprise Oracle Financial Analyzer, ERP and the Data Warehouse	99	(21)
The Oracle General Ledger and Oracle Financial Analyzer	100	(6)
Other ERP systems and Oracle Financial Analyzer	106	(3)
Operational data stores, the data warehouse and OFA	109	(7)
OFA, tactical solutions and the data warehouse	116	(4)
Project Principles	120	(144)
Sponsorship	121	(3)
Business process modelling	124	(7)
Change management planning	131	(1)
Design of the application architecture	132	(26)
Database design	158	(42)
Infrastructure specification	200	(35)
Documentation	235	(9)
Roll-out and continuing change management	244	(8)
Backups, database reorganizations and data archiving	252	(12)
Case Study in the Consumer Packaged Goods (CPG) Industry	264	(24)
Company overview	264	(1)
The requirements of the OFA system	264	(4)
Sponsorship and change management	268	(1)
Business process modelling	269	(1)
Design of the application architecture	270	(1)
Database design	271	(15)
Roll-out	286	(1)
Continuing change management	287	(1)
Case Study in the Financial Services Industry	288	(21)
Company overview	288	(1)
The requirements of the OFA system	288	(1)
Roll-out	289	(1)
Sponsorship	290	(1)
Change management	291	(1)
Requirements	291	(2)
Design of the application architecture	293	(2)
Database design: management reporting	295	(4)
Interface design: management reporting	299	(4)
Database design: budgeting	303	(2)
Database design: profitability	305	(3)
Infrastructure specification	308	(1)
Case Studies in Activity-Based Management	309	(57)
Activity-based costing: the principles	310	(18)
Oracle Financial Analyzer and activity-based planning and budgeting	328	(18)
A more detailed look at the generic ABC business process model and OFA	346	(20)
REFERENCES	366	(34)
APPENDICES
A Tuning OFA	367	(7)
B Data loading	374	(12)
C The GL Link: hints and tips	386	(5)
D History, future developments and their potential impact	391	(9)
Index	400