Oracle Apps Day_SEM

Size: px

Start display at page:

Download "Oracle Apps Day_SEM"

덕현 진
6 years ago
Views:

1 Senior Consultant Application Sales Consulting Oracle Korea

2 -

3 1. S = (P + R) x E S= P= R= E= Source : Strategy Execution, By Daniel M. Beall 2001

4 1. Strategy Formulation Sound Flawed Missed Opportunity Doomed From The Start Flawed Strategic Success At Risk Sound Strategy Execution

5 2. Lack of a well defined strategy Strategy Formulation 57% Lack of a link between strategy and Operational plan Strategy Cascading 53% Lack of accountability of results Responsibility 45% Lack of meaningful performance measures KPI Lack of pay for performance Reward 21% 34% Lack of appropriate data DW/DM 21% Source : How Strategic Performance Management Is Helping Companies Create Business Value, By Omar Aguilar, Strategic Finance, January 2003

6 3. Balanced Scorecard Input (Resources) / Initiatives & Programs Output (Results)

7 3. Value Tree ( )- ROIC ( )- Cascading ( )- BSC BSC, ( ) Index BSC

8 3. Operation Layer Data Integration Layer Intelligence Layer ERP, Legacy DW/DM SEM

9 3. < > by , PHP, Mobile High Range Alert Target Low Range Exception (notify) :

10 3. CORP SBU Top-Down EDUCATION PERSONAL GOAL ALIGNMENT Bottom-Up BALANCED PAYCHECKS The Strategy Focused Workforce

11 3. Vision / CSF/KPI C.S.F KPI CDP Feedback Activity Define / HR

12 KPI, (Plan) -KPI (Do) Data Warehouse/Data Mart Exception Management On-line / Off-line (Do),, (See)

13 4. Plan / CSF Do / Alert / See

14 5. GL Interface Budget Performance Report Planning & Forecasting Variance Oracle Financial Analyzer Data Analysis Ad Hoc Individual Data Slice What-If Exception

15 5. Rolling Plan EVA, CFROI,,

16 5. Map KPI KPI Segment need Financial Planning

17 5. OBSC Feedback & Corrective Action loading

18 5. KPI KPI Communication Common Language / KPI

19 5. ( ) / Process Innovation

20 5. Cumulative Percentage of Sales (1) Rules (2) Rules (1) The Most Profitable 20% : (+) 300% (2) The Remaining 80% : (-) 200% Cumulative Profits (percent of total profits) Cumulative Percentage of Products Cumulative Sales Most Profitable Product Cumulative Percentage of Products Least Profitable Product Cumulative Profitability

21 5. Process Capacity Simulation

22 5. Proactive Management (Alert). mobile, (PHP), Application. Information Alert.,.

23 5.,

24 5.

25 5. Total Compensation & : Communication Validation

5. Oracle Mainframe DB2, Informix SAP, People Soft Syndicated data Benchmarking data 2 3 Design Target Warehouse Map Source to Target OWB (Oracle

26 5. Oracle Mainframe DB2, Informix SAP, People Soft Syndicated data Benchmarking data 2 3 Design Target Warehouse Map Source to Target OWB (Oracle Warehouse Builder) OWB* Oracle ETT ( Extraction Transformation Transformation ) Legacy,,,. 1 Define Sources 4 Generate Code 5 Instantiate Warehouse 6 Extract Data

27 5. KMS System EIP ( Enterprise Information Portal ) Data Warehouse Solution Web System DW ROLAP ETT 1 ODS ODS ODS DW DW DW 3 MOLAP Data Mining Alert/Workflow Data Mart Data Mining DM MOLAP DM Campaign DM 2 4 SEM OFA BSC ABM Analytical Intelligence OLAP E-Business Intelligence

28 5. References POSCO, One-Stop Best Practice Oracle e-business Suite One Vendor Solution Open System 100% iplatform Web Solution Self-service, 3 Tier Architecture,, (Oracle, ERP, Legacy)

29 D E M O N S T R A T I O N

30 Q U E S T I O N S A N S W E R S

E-BI Day Presentation

E-BI Day Presentation E-Business Intelligence Agenda Issue E-BI Architecture ORACLE E-BI Solutions ORACLE E-BI ORACLE E-BI I. Issue? KPI. (KPI ). Jeff Henley, CFO, Oracle Corporation I. Issue? I. Issue Many Sources, Users,and