,,,
, , , , . . , , . , . .
-, OLAP. OLAP - Online Analytical Processing, . . . , OLAP , .
OLAP -
- , . , . , , - . "", "" "", . , ( ), ( ) - , ( - ; ). , . ( ) . "" "" , , , , "". , ! OLAP.
OLAP , .
, , . 1.
. 1.
, , . . ( ) OLAP-. OLAP . , . . , . .
, OLAP , . OLAP ( ). , . . , .
OLAP- :
- , ; .
- () ( SQL ) , .
- , .
OLAP-. , , , ; SQL-, .
OLAP-, , , OLAP- (, Pivot Tables Excel 2000 Microsoft ProClarity Knosys), , OLAP- (, Oracle Express Server Microsoft OLAP Services).
OLAP- / OLAP-, , , , Pivot Table Service Microsoft.
-, - .
. . , , . , , - . , , ? , , .
. ( ). "-". , , . , . , . , . , , .
, , :
. . , , .
. , , , . , . , .
. , , , .
.
(BPM - Business Performance Management) , . IDC , : , ) , .
- . IDC 320 . , 44% . 2005 1,4 . .
, . , , , :
( ) , .
, .
, .
, .
, : ERP- /.
ERP- back-. , Hyperion Solutions Corporation Comshare, , .
ERP- , , Web- . (EPM - Enterprise Performance Management) ERP- - PepleSoft - . EPM , . (scorecard applications), . , .
PeopleSoft - SAP SAP Strategic Enterprise Management (SEM) Oracle Corporation ( Oracle - Enterprise Planning And Budgeting, EPB ) . , . , , Web-, , . Lawson Software Hyperion, , .
ERP- , . Epicor Corporation Business Intelligence . Great Plains Software, Microsoft, , Logility Siebel Systems. Hyperion , Hyperion Pillar, Hyperion Planning, , , , , Hyperion Pillar.
Peoplesoft EPM
PeopleSoft EPM 1998 . , EPM-. , . , .
Business Planning - . , EPM-, - PeopleSoft Financials PeopleSoft Budgets, Essbase OLAP Server.
, - PeopleSoft . .
- , .
PeopleSoft , :
. . , .
. -: . , .
. , .
. , (check-in/check-out) .
PeopleSoft , . - , , OLAP-, EPM-, Business Planning .
" " " " .
SAP
SAP Budgeting and Planning :
;
;
.
. , , , . , MS Excel. Excel-, , , , , .
Budgeting and Planning , . , . .
InfoCubes, SAP Business Information Warehouse (SAP BW- . " SAP"). SAP R/3 CO-CCA , , R/3 SAP SEM.
SAP Budgeting and Planning . Web-, Excel-, . , ( ) .
SAP . , . , .
.
SAP Budgeting and Planning , :
, , , ;
, : (), ;
. R/3 R/3 CO-CCA1 .
, , . SAP , , . , . .
R/3
SAP SEM. R/3 CO-CCA. (Cost Center Planning) R/3. SAP SEM.
Oracle Enterprise Planning And Budgeting (Epb)
Oracle Enterprise Planning and Budgeting (EPB) Oracle Financial Analyzer (OFA) Oracle Sales Analyzer (OSA) . EPB - Oracle Financials, , Oracle Applications, .
EPB Corporate Performance Management (CPM) Oracle.
Oracle EPB Oracle 9i, OLAP-, , Java API. Oracle e-Business Suite, , (workflow), , .
EPB OFA OSA. , . .
-
-, EBP . , , .
, Oracle EPB KPI (key performance indicators, ).
, , . , EPB , , , , "".
EPB . , KPI. , , , , , . KPI , . .
Oracle OLAP, SQL- EPB ( Oracle Reports Oracle Discover, , Business Objects). , . Excel .
, :
Hyperion (.)
Oracle (.)
Cognos
Comshare
MicroStrategy
Hyperion.
Hyperion - , HYPERION SYSTEM 9.
:
, , ;
Hyperion System 9 Shared Services, , , , MS Office;
.
. , .
, , Gartner, Hyperion (leaders) .
Hyperion System 9 BPM: , BI- , . , web.
, , , , .
, . 1: , -, , --, - . . , , , . , , ʻ, . , - , . Project Expert. - , .
(1:, -, 97, ). - , , . ( , , ),
(), (, ).
1 (1: ). 1: 7.5, , .
,
1: 7.5 . , , .
7.5 (7.7) :
- ;
- ;
- .
, , , .. ( . [102
]). , (. , 1998 .). 3- .
, ().
7.5(7.7) .
. 5 , .
, , 1:
. 1: 1: (..6). 1: (1:, 1: ), .
, , , , , .. , 1: : , , .
, , . , 1: .
- . : , , .
2.6 -
|
1: |
- |
97 |
|
|||
1 | . | ||||||
|
|||||||
|
Ö | Ö | |||||
Ö | Ö | ||||||
Ö | Ö | Ö | |||||
Ö | Ö | Ö | Ö | ||||
Ö | Ö | Ö | Ö | ||||
Ö | Ö | ||||||
Ö | Ö | ||||||
|
Ö | Ö | |||||
. | . | . | . | ||||
Ö | |||||||
Ö | Ö | Ö | Ö | ||||
. | . | . | . | ||||
. | . | . | . | ||||
: OLE , OLE Automation DDE |
Ö | Ö | Ö | ||||
Ö | Ö | ||||||
|
1: |
- |
97 |
|
|
||
|
Ö | Ö | Ö |
|
|||
Ö | Ö | Ö |
|
||||
Ö | Ö |
|
|||||
|
|||||||
|
|||||||
( ), . | 540 | 950 | 1.020 | 350 |
|
||
- , , , ; ; ; - -; -.
. , .. , , , , - , , , . , .
, , , , .. - .
- , . , , 1: MS Office.
. . , . , . ( , ). . , .
, , , , .
Copyright (c) 2024 Stud-Baza.ru , , , .