Oracle Direct Seminar <Insert Picture Here> Essbase Fusion Middleware EPM/BI SC 2009 11 18
Essbase Oracle Direct Concierge SQL Server MySQL PostgreSQL Access Oracle Database Oracle Developer/2000 Web Oracle Database Oracle Database http://www.oracle.com/lang/jp/direct/services.html Copyright 2009, Oracle. All rights reserved. 2
<Insert Picture Here> Essbase Copyright 2009, Oracle. All rights reserved. 3
Copyright 2009, Oracle. All rights reserved. 4 Oracle Essbase No1 BI BI Action Action Plan Plan Do Do Check Check Essbase Essbase PDCA PDCA BI BI ( ) ( )
(Dense) (Sparse) Year Account Scenario Product Market Scenario Block = = Block (.ind) Account Block Block (.pag) Year Scenario Copyright 2009, Oracle. All rights reserved. 5
Essbase = EAS [] false ( true) EAS [] [ ] [ ][ ] 100KB False Copyright 2009, Oracle. All rights reserved. 6
<Insert Picture Here> Copyright 2009, Oracle. All rights reserved. 7
1 1 1 Copyright 2009, Oracle. All rights reserved. 8
= 1 =,,,, PSI Copyright 2009, Oracle. All rights reserved. 9
@XREF + Cube A Cube B Cube Z Cube ODI ETL, Essbase RDBMS ERP Essbase Studio, Essbase Integration Services XOLAP Ver11 Essbase Studio Essbase Copyright 2009, Oracle. All rights reserved. 10
Essbase Essbase,,,,,, KPI,,,,,,, Copyright 2009, Oracle. All rights reserved. 11
2009, 2010 1, 2, 3, 1, Copyright 2009, Oracle. All rights reserved. 12
, 1,, + JPY, USD, EUR etc Copyright 2009, Oracle. All rights reserved. 13
IO Copyright 2009, Oracle. All rights reserved. 14
+,-,*,/ UDA @DESCENDANTS(), @CHILDREN( ) = + - Ratios Copyright 2009, Oracle. All rights reserved. 15
0 Hyperion Planning 1 1 Essbase BASS1:1 BASS Copyright 2009, Oracle. All rights reserved. 16
2 0 Copyright 2009, Oracle. All rights reserved. 17
TB B/S, #Missing, 0 EAS [ ] [ ] 1 TB1 100 1 3 330 TB3 120 2TBMissingMissing 32 110 Copyright 2009, Oracle. All rights reserved. 18
Essbase 1Essbase EAS [] [ ] Excel, FR, WA Essbase Copyright 2009, Oracle. All rights reserved. 19
<Insert Picture Here> Copyright 2009, Oracle. All rights reserved. 20
EAS EAS [Essbase Server] [][] [] & : &CurYear, &NxtYear, &CurForecast &CurYear=FY09 &CurForecast=Forecast_Jul Copyright 2009, Oracle. All rights reserved. 21
or? + KPI 1 : x Copyright 2009, Oracle. All rights reserved. 22
Essbase EAS [] [][ ] [ ] 1.00 1 0.x 0.4 0.5 MaxL : alter database [AP ].[DB ] force restructure; etc 1 Copyright 2009, Oracle. All rights reserved. 23
Excel Excel Essbase Excel [Essbase] / [] Copyright 2009, Oracle. All rights reserved. 24
Excel () #Missing #Missing #No Access Copyright 2009, Oracle. All rights reserved. 25
Excel () Copyright 2009, Oracle. All rights reserved. 26
Excel () Missing Copyright 2009, Oracle. All rights reserved. 27
Excel () Copyright 2009, Oracle. All rights reserved. 28
Excel () Excel Excel ON OFF Excel ON Copyright 2009, Oracle. All rights reserved. 29
Excel () MS Excel 1 2 Microsoft Excel Essbase OFF Copyright 2009, Oracle. All rights reserved. 30
Oracle Direct Seminar 100Wendy2010 1112 2!! a. b. c. d. a,b,c,d http://www.oracle.com/technology/global/jp/membership/index.html ORD_SEMINAR_JP@ORACLE.COM 2009 1112 Oracle Direct Copyright 2009, Oracle. All rights reserved. 31
Oracle University Live Virtual Class Oracle University LVC 15% OFF Oracle University Live Virtual Class (Oracle University LVC) Oracle University LVC Oracle University LVC Data Warehouse 11/2 11/12 11/13 http://education.oracle.co.jp/lvc_session_0911/ Oracle E-Business Suite Siebel PeopleSoft JD Edwords Agile 11/20 11/27 12/3 12/4 http://education.oracle.co.jp/lvc_session_0912/ Copyright 2009, Oracle. All rights reserved. 32 Copyright Oracle Corporation Japan, 2009. All rights reserved.
IT Oracle Direct Concierge BI IT BI Access / SQL Server MySQL / PostgreSQL Oracle Database Oracle Developer Web RFP BI Oracle Database Oracle Database Copyright 2009, Oracle. All rights reserved. 33
Oracle Direct Oracle Direct IT / Web 0120 155 096 ~9:00~12:00 13:00~18:00 Copyright 2009, Oracle. All rights reserved. 34