すぐに使える！Essbase キューブ開発テクニック集
|
|
|
- きょういち つつの
- 8 years ago
- Views:
Transcription
1 Oracle Direct Seminar <Insert Picture Here> Essbase Fusion Middleware EPM/BI SC
2 Essbase Oracle Direct Concierge SQL Server MySQL PostgreSQL Access Oracle Database Oracle Developer/2000 Web Oracle Database Oracle Database Copyright 2009, Oracle. All rights reserved. 2
3 <Insert Picture Here> Essbase Copyright 2009, Oracle. All rights reserved. 3
4 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 ( ) ( )
5 (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 (](/docs-images/76/72986572/images/6-0.jpg "true) EAS [] [ ] [ ][ ]")
6 Essbase = EAS [] false ( true) EAS [] [ ] [ ][ ] 100KB False Copyright 2009, Oracle. All rights reserved. 6
7 <Insert Picture Here> Copyright 2009, Oracle. All rights reserved. 7
8 1 1 1 Copyright 2009, Oracle. All rights reserved. 8
9 = 1 =,,,, PSI Copyright 2009, Oracle. All rights reserved. 9
10 @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
11 Essbase Essbase,,,,,, KPI,,,,,,, Copyright 2009, Oracle. All rights reserved. 11
12 2009, , 2, 3, 1, Copyright 2009, Oracle. All rights reserved. 12
13 , 1,, + JPY, USD, EUR etc Copyright 2009, Oracle. All rights reserved. 13
14 IO Copyright 2009, Oracle. All rights reserved. 14
15 ) = + - Ratios Copyright 2009, Oracle. All rights reserved. 15
16 0 Hyperion Planning 1 1 Essbase BASS1:1 BASS Copyright 2009, Oracle. All rights reserved. 16
17 2 0 Copyright 2009, Oracle. All rights reserved. 17
![TB B/S, #Missing, 0 EAS [ ] [ ] 1 TB1 100 1 3 330 TB3 120](/docs-images/76/72986572/images/18-0.jpg "2TBMissingMissing 32 110 Copyright 2009, Oracle.")
18 TB B/S, #Missing, 0 EAS [ ] [ ] 1 TB TB TBMissingMissing Copyright 2009, Oracle. All rights reserved. 18
![Essbase 1Essbase EAS [] [ ] Excel, FR, WA](/docs-images/76/72986572/images/19-0.jpg "Essbase Copyright 2009, Oracle.")
19 Essbase 1Essbase EAS [] [ ] Excel, FR, WA Essbase Copyright 2009, Oracle. All rights reserved. 19
20 <Insert Picture Here> Copyright 2009, Oracle. All rights reserved. 20
![EAS EAS [Essbase Server] [][] [] & : &CurYear, &NxtYear, &CurForecast](/docs-images/76/72986572/images/21-0.jpg "&CurYear=FY09 &CurForecast=Forecast_Jul Copyright 2009, Oracle.")
21 EAS EAS [Essbase Server] [][] [] & : &CurYear, &NxtYear, &CurForecast &CurYear=FY09 &CurForecast=Forecast_Jul Copyright 2009, Oracle. All rights reserved. 21
22 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 ].](/docs-images/76/72986572/images/23-0.jpg "[DB ] force restructure; etc 1 Copyright 2009, Oracle. All rights reserved.")
23 Essbase EAS [] [][ ] [ ] x MaxL : alter database [AP ].[DB ] force restructure; etc 1 Copyright 2009, Oracle. All rights reserved. 23
24 Excel Excel Essbase Excel [Essbase] / [] Copyright 2009, Oracle. All rights reserved. 24
25 Excel () #Missing #Missing #No Access Copyright 2009, Oracle. All rights reserved. 25
26 Excel () Copyright 2009, Oracle. All rights reserved. 26
27 Excel () Missing Copyright 2009, Oracle. All rights reserved. 27
28 Excel () Copyright 2009, Oracle. All rights reserved. 28
29 Excel () Excel Excel ON OFF Excel ON Copyright 2009, Oracle. All rights reserved. 29
30 Excel () MS Excel 1 2 Microsoft Excel Essbase OFF Copyright 2009, Oracle. All rights reserved. 30
31 Oracle Direct Seminar 100Wendy !! a. b. c. d. a,b,c,d Oracle Direct Copyright 2009, Oracle. All rights reserved. 31
32 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 Oracle E-Business Suite Siebel PeopleSoft JD Edwords Agile 11/20 11/27 12/3 12/4 Copyright 2009, Oracle. All rights reserved. 32 Copyright Oracle Corporation Japan, All rights reserved.
33 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
34 Oracle Direct Oracle Direct IT / Web ~9:00~12:00 13:00~18:00 Copyright 2009, Oracle. All rights reserved. 34
意外と簡単！？ Oracle Database 11g -バックアップ・リカバリ編-
Oracle Direct Seminar !?Oracle Database 11g -- Agenda Oracle Direct Concierge SQL Server MySQL PostgreSQL Access Oracle Database Oracle Developer/2000 Web Oracle Database Oracle Database
データ連携がこんなに簡単に！？Oracle Data Integratorのご紹介
< > Agenda Oracle Data Integrator Oracle Data Integrator Oracle Data Integrator 2 Agenda Oracle Data Integrator Oracle Data Integrator Oracle Data Integrator 3 NEED Business Intelligence Corporate Performance
Windowsユーザーの為のOracle Database セキュリティ入門
Oracle on Windows etc http://www.oracle.co.jp/campaign/mb_tech/ Windows Server System Center / OTN Japan http://www.oracle.com/technology/global/jp/tech/windows/.net + Oracle Database.NET Developer Center
<Insert Picture Here>
Copyright Corporation Japan, 2006. All rights reserved. 3 Business Intelligence Enterprise Semantic Model vs. BI BI BAM Insight Driven Actions Copyright Corporation Japan, 2006. All
untitled
Oracle on Windows etc http://www.oracle.co.jp/campaign/mb_tech/ Windows Server System Center / OTN Japan http://www.oracle.com/technology/global/jp/tech/windows/.net + Oracle Database.NET Developer Center
What's Oracle WebLogic Server ～なぜWebLogic Serverが選ばれるのか～
Oracle Direct Seminar What s Oracle WebLogic Server WebLogic Server Agenda What s Oracle WebLogic Server Oracle WebLogic Server TCO Oracle Direct Concierge SQL Server MySQL PostgreSQL
<Insert Picture Here> Oracle Business Intelligence 2006/6/27
Oracle Business Intelligence 2006/6/27 Oracle Business Intelligence Suite Enterprise Edition Oracle Warehouse Builder 10g Release 2 Agenda BI FY07 3 Oracle Business Intelligence 2007
ハピタス のコピー.pages
Copyright (C) All Rights Reserved. 10 12,500 () ( ) ()() 1 : 2 : 3 : 2 4 : 5 : Copyright (C) All Rights Reserved. Copyright (C) All Rights Reserved. Copyright (C) All Rights Reserved. Copyright (C) All
Copyright 2008 All Rights Reserved 2
Copyright 2008 All Rights Reserved 1 Copyright 2008 All Rights Reserved 2 Copyright 2008 All Rights Reserved 3 Copyright 2008 All Rights Reserved 4 Copyright 2008 All Rights Reserved 5 Copyright 2008 All
平成20年度内部評価実施結果報告書《本編》
10 11 12 13 14 15 16 17 Plan Do Check Action 1 2 3 4 146 13 20 43 44 45 62 104 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
-2-
-1- -2- -3- -4- -5- -6- -7- -8- 10-9- -10-1 2 -11-1 1-12- -13- -14- Plan Do Check Action Check Action 1 -15- -16- -17- -18- -19- -20- -21- -22- 10 2 9 3 9 2 1 10 2 9 3 6 4 1 6 6 10 2 10 2 11 1 8 1 8 4
Hyperion Corporate PPT Template
2006.12.07 BPM No.1 Legacy Teradata SAP Oracle Siebel Copyright 2006, Hyperion. All rights reserved. 2 BPM Copyright 2006, Hyperion. All rights reserved. 3 BPM ERP CRM ROI TCO M&A Copyright 2006, Hyperion.
Visual Studio Oracle Database 11g アプリケーション開発入門
Oracle on Windows etc http://www.oracle.co.jp/campaign/mb_tech/ Windows Server System Center / OTN Japan http://www.oracle.com/technology/global/jp/tech/windows/.net + Oracle Database.NET Developer Center
初心者にもできるアメブロカスタマイズ新2016.pages
Copyright All Rights Reserved. 41 Copyright All Rights Reserved. 60 68 70 6 78 80 Copyright All Rights Reserved. FC2 97 Copyright All Rights Reserved. Copyright All Rights Reserved. Copyright All Rights
- 2 Copyright (C) 2006. All Rights Reserved.
- 2 Copyright (C) 2006. All Rights Reserved. 2-3 Copyright (C) 2006. All Rights Reserved. 70-4 Copyright (C) 2006. All Rights Reserved. ...1...3...7...8 1...9...14...16 2...18...20...21 3...22...23...23...24
Copyright 2008 NIFTY Corporation All rights reserved. 2
Copyright 2008 NIFTY Corporation All rights reserved. 2 Copyright 2008 NIFTY Corporation All rights reserved. 3 Copyright 2008 NIFTY Corporation All rights reserved. 4 Copyright 2008 NIFTY Corporation
組織変更ライブラリ
2003 6 1...1 2...2 3...4 3.1...4 3.2...5 3.3...6 3.4...6 4...7 4.1...7 4.2...9 4.3...9 4.4...10 4.5...10 5 Web...11 5.1 WebUI...11 5.2Oracle 9iFS WebUI...12 6Oracle9i AS...13 6.1OiD...13 6.2 SSO...13 7...14
20 180pixel 180pixel Copyright 2014 Yahoo Japan Corporation. All Rights Reserved.
12 300pixel 300pixel www.yahoo.co.jp Copyright 2014 Yahoo Japan Corporation. All Rights Reserved. 20 180pixel 180pixel Copyright 2014 Yahoo Japan Corporation. All Rights Reserved. 300pixel 300pixel www.yahoo.co.jp
Copyright All Rights Reserved. -2 -!
http://ameblo.jp/admarketing/ Copyright All Rights Reserved. -2 -! Copyright All Rights Reserved. -3- Copyright All Rights Reserved. -4- Copyright All Rights Reserved. -5 - Copyright All Rights Reserved.
Copyright 2006 KDDI Corporation. All Rights Reserved page1
Copyright 2006 KDDI Corporation. All Rights Reserved page1 Copyright 2006 KDDI Corporation. All Rights Reserved page2 Copyright 2006 KDDI Corporation. All Rights Reserved page3 Copyright 2006 KDDI Corporation.
1 1,200m ,482,620m 1 323,825m 1 205,988m 114,988m 60,000m 31,000m ,837m ,158,795m ,340m 1 48,006m 1 33,016m 1,125m
IV 39 7 10 167 1 3 9 2 10 79 1 1,200m 23 23 6 1 429 2,482,620m 1 323,825m 1 205,988m 114,988m 60,000m 31,000m 27 117,837m 3 2 426 2,158,795m 44 277,340m 1 48,006m 1 33,016m 1,125m 33,016m 4 14,990m 2 44
Microsoft Word - 最終版 バックせどりismマニュアル .docx
ism ISM ISM ISM ISM ISM ISM Copyright (c) 2010 All Rights Reserved. Copyright (c) 2010 All Rights Reserved. Copyright (c) 2010 All Rights Reserved. ISM Copyright (c) 2010 All Rights Reserved. Copyright
untitled
http://www.riskdatabank.co.jp The of Japan, Ltd. All rights reserved. 2 The of Japan, Ltd. All rights reserved. 3 The of Japan, Ltd. All rights reserved. 4 The of Japan, Ltd. All rights reserved. 5 The
KDDI
Copyright 2007 KDDI Corporation. All Rights Reserved page.1 Copyright 2007 KDDI Corporation. All Rights Reserved page.2 Copyright 2007 KDDI Corporation. All Rights Reserved page.3 Copyright 2007 KDDI Corporation.
ESA_UI_1110.PDF
ESA SAP SAP SAP Web AS SAP SAP : ESA ESA : CAF ESA SAP SAP SAP : ESA ESA : CAF ESA SAP SAP SAP Office???? SAP Japan Co., Ltd. 2004, Title of Presentation / Speaker Name / 4 SAP SAP : ESA ESA : CAF ESA
dekiru_asa
11 10 4 4 1 2 3 4 2 4 6 10 12 16 20 2 1 3 1 4 2 5 2 6 3 3 7 8 9 3 3 10 4 1 11 4 2 3 4 5 1 2 3 12 4 5 5 13 14 6 7 8 9 10 11 5 15 6 1 2 3 16 17 1 2 3 6 18 1 2 3 19 6 6 1 2 v 3 20 7 1 2 3 1 7 21 22 2 3 4
(OnePoint) ( URL Web Copyright 2005 Microsoft Corporation. All rights reserved. Microsoft Windows Visual Basic Visual Studio Microsoft Corporation
Microsoft Microsoft Visual Basic.NET (OnePoint) ( URL Web Copyright 2005 Microsoft Corporation. All rights reserved. Microsoft Windows Visual Basic Visual Studio Microsoft Corporation Microsoft Microsoft
untitled
mitsuya Copyright (C) 2007. All Rights Reserved. 1/1 mitsuya Copyright (C) 2007. All Rights Reserved. 2/2 mitsuya Copyright (C) 2007. All Rights Reserved. 3/3 mitsuya Copyright (C) 2007. All Rights Reserved.
FileMaker Oracle Microsoft SQL Server MySQL Salesforce.com ROI TCO RAD IT FileMaker Pro RAD RAD TCO RAD Microsoft Visual Studio 2008 Oracle Developer
RAD Rapid Application Development ROI TCO FileMaker Oracle Microsoft SQL Server MySQL Salesforce.com ROI TCO RAD IT FileMaker Pro RAD RAD TCO RAD Microsoft Visual Studio 2008 Oracle Developer Suite 10g
2
2 485 1300 1 6 17 18 3 18 18 3 17 () 6 1 2 3 4 1 18 11 27 10001200 705 2 18 12 27 10001230 705 3 19 2 5 10001140 302 5 () 6 280 2 7 ACCESS WEB 8 9 10 11 12 13 14 3 A B C D E 1 Data 13 12 Data 15 9 18 2
SAP Solution in Detail SAP Business One SAP Business One 1 SAP Business One 5 SAP Business One 5 1 5 5 5 6 6 SAP Business One 6 / 6 / 6 / 7 / 7 / 7 / 7 SAP Business One 8 8 9 9 CRM 9 CRM 10 10 SAP Business
Windows Oracle -Web - Copyright Oracle Corporation Japan, All rights reserved.
Windows Oracle -Web - Copyright Oracle Corporation Japan, 2004. All rights reserved. Agenda Oracle Windows Windows Oracle 1 / Active Directory/Enterprise User Security 1-1 Windows 1-2 Kerberos 1-3 Enterprise
Web Microsoft 2008 R2 Database Database!! Database 04 08
Database Database Web http://www.microsoft.com/japan/sqlserver/2008/r2/solution/comparison/default.mspx Microsoft 2008 R2 Database Database!! 03 2009 6 1 Database 04 08 vs. Database 12 2008 R2 5 14! 5!
健康保険組合のあゆみ_top
(1912) (1951) 2,00024,000 (1954) (1958) (1962) (1965) (1968) (1969) (1971) (1972) (1973) (1974) (1976) (1978) (1980) (1982) (1983) (1984) (1985) (1987) (1988) (1989) (1990) (1991) (1992) (1994) (1995)
EM10ｇR3記者発表
トップダウンのアプリケーション管理を実現する Oracle Enterprise Manager 10g Release 3 日本オラクル株式会社常務執行役員システム製品統括本部長三澤智光 2007 年 4 月 10 日 構成管理 サービス レベル管理 Oracle Enterprise Manager アプリケーション パフォーマンス管理 ライフサイクル管理
Copyright 2008 LOCKON CO.,LTD..All rights reserved. 2
Copyright 2008 LOCKON CO.,LTD..All rights reserved. 1 Copyright 2008 LOCKON CO.,LTD..All rights reserved. 2 Copyright 2008 LOCKON CO.,LTD..All rights reserved. 3 Copyright 2008 LOCKON CO.,LTD..All rights
Copyright 2010 Sumitomo Mitsui Banking Corporation. All Rights Reserved.
1 2 3 4 5 3 1 2 5 4 2Copyright 2010 Sumitomo Mitsui Banking Corporation. All Rights Reserved. Copyright 2010 Sumitomo Mitsui Banking Corporation. All Rights Reserved.3 Contents 4Copyright 2010 Sumitomo
ORACLE Data Integrator
Oracle Data Integrator ORACLE DATA INTEGRATOR E-LT アーキテクチャがもたらす最高性能 アクティブ統合プラットフォームによる包括的かつ進化的なデータ統合 宣言的な設計によるユーザーの生産性向上 ナレッジ モジュールが提供するモジュール性 柔軟性 拡張性 機能 : 異種システムにおけるすべての変換とデータ制御のサポート テーブル 集約 複雑な計算の間での複雑な結合の実行
Oracle Identity Managementの概要およびアーキテクチャ
Oracle Identity Management 2003 12 Oracle Identity Management... 3 ID... 3 ID... 4 ID... 4 Oracle Identity Management... 5 Oracle Identity Management... 6 Oracle Identity Management... 7 ID... 8 Application
1 2 3 4 5 6 7 a a a a a a 
c c c c c 1 c c c c c c c c c c c 2 3 c c 4 a a a a a a a a a 
①
Copyright 2005 Impex.,inc. All Rights Reserved 1 Copyright 2005 Impex.,inc. All Rights Reserved 2 Copyright 2005 Impex.,inc. All Rights Reserved 3 Copyright 2005 Impex.,inc. All Rights Reserved 4 Copyright
untitled
Copyright 2010 by Future Architect, Inc. Japan Copyright 2010 by Future Architect, Inc. Japan -2- Copyright 2010 by Future Architect, Inc. Japan Copyright 2010 by Future Architect, Inc. Japan Copyright
技術流出防止指針公表用.PDF
15 3 1 4 .. 2 2.. 4. 6.10 10.14.16.19.24.26.28 1 2 1 2002 7 3 2002 3 4 2 3 5 4 4 6 7 8 5 5 9 plan (do) (check) (act) 1) 2) 3) 4) 5) 6) 7) 10 11 12 13 14 15 16 17 18 6 6 19 / / 20 21 22 7 23 8 24 25 26
Copyright 2017 JAPAN POST BANK CO., LTD. All Rights Reserved. 1
Copyright 2017 JAPAN POST BANK CO., LTD. All Rights Reserved. 1 Copyright 2017 JAPAN POST BANK CO., LTD. All Rights Reserved. 2 60 50 40 30 20 10 0 20173 20183 Copyright 2017 JAPAN POST BANK CO., LTD.
% 11.1% +6.% 4, % %+12.2% 54,16 6.6% EV7, ,183 Copyright 216 JAPAN POST GROUP. All Rights Reserved. 1
216 3 216 5 13 848+4.4% 11.1% +6.% 4,853 495 +2.6% 1 +11.6%+12.2% 54,16 6.6% EV7,829 2 7,183 Copyright 216 JAPAN POST GROUP. All Rights Reserved. 1 15.3 16.3 16.3 11,692 96,57 5.5 % 4,926 4,115 16.5 %
P. 2 P. 4 P. 5 P. 6 P. 7 P. 9 P.10 P.12 P.13 P.14 P.14 P.15 P.17 P.18 P.20 P P P P P.25 P.27 P.28 Copyright 2016 JAPAN POST BA
201729 3 1 2016 8 12 P. 2 P. 4 P. 5 P. 6 P. 7 P. 9 P.10 P.12 P.13 P.14 P.14 P.15 P.17 P.18 P.20 P.21 10 P.22 11 P.23 12 P.24 13 P.25 P.27 P.28 Copyright 2016 JAPAN POST BANK CO., LTD. All Rights Reserved.
untitled
Oracle on Windows etc http://www.oracle.co.jp/campaign/mb_tech/ Windows Server System Center / OTN Japan http://www.oracle.com/technology/global/jp/tech/windows/.net + Oracle Database.NET Developer Center
Slide 1
Oracle Direct Seminar 入門の方も歓迎! 多次元データベースの考え方からノウハウ教えます 日本オラクル株式会社 Fusion Middleware 事業統括本部 EPM/BI 第一 SC 部 2010 年 4 月 6 日 本日の内容 多次元とは Essbase 多次元データベースの構造 Essbase キューブ作成ノウハウ 無償技術サービス
... 3... 4... 5... 7 Acronis Backup & Recover 10 Deduplication... 7... 10 2
Copyright Acronis, Inc., 2000 2009 ... 3... 4... 5... 7 Acronis Backup & Recover 10 Deduplication... 7... 10 2 50 100% 2008 IDC 3 3,000% Windows Linux 3 1 1 4KB 1 90% 9MB Microsoft PowerPoint 10 [ ] 9MB
X-U5
X-U5 X-UD5 2 3 4 5 6 7 8 9 10 11 12 PC IN 13 x 14 R 15 16 17 1 2 3 4 CD USB/iPod Bluetooth FM LINE PC 1 2 3 S.Bass Off S.Bass 1 S.Bass 2 18 1 2 3 1 2 3 19 20 x x 1 2-3 3 x 1 2 1 2 21 1 2 3 4 1 2 3 4 1
PLQ-20 取扱説明書 詳細編
2013 Seiko Epson Corporation. All rights reserved. o n h o n n A B o C h h n h A B n C n n A B C A B C A B C D E A B C D E h o h B n C A D E F G n A C B n A B C D C n A B D F G H E n A B D C E F n A h