. , , ,

,,,

, , , , . . , , . , . .

-, 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.

. . , . , . ( , ). . , .

, , , , .

 

 

 

! , , , .
. , :