Monday, November 20th, 2017

???????? Oracle BI Server & Oracle BI Suite EE

Published on Март 5, 2009 by   ·   Комментариев нет

??????????? ????????????? ? ???, ?????????? ? ??????? ????????? (BI, business intelligence) ? ???????? ?????? Oracle, ??????? ? ?????? ????????????? ? ??????????, ??? Oracle Warehouse Builder, OracleBI Discoverer ?, ???????, ???? Oracle. ??? ??? ??????????? ???????? ?????????? ????? ? ????????????? ??? ??? ?????????????, ??????? ????? ??????? ???? ?????? Oracle ??????? ????? ????????????? ?????????. ?? ????????? ????????????? ????? ??????????? ?????? ??? ?? ??? ?????? Oracle, ??? ? ?? ?????? ?????????? ??????, ????? ??? ??????????? ???????, ????????? ? ??????? XML ?, ????????, ?? ??????, ??????? ??? ????? ??????? ?? ERP-?????? ??? ???? OLAP-???????? (? ???????? ?? ????? MDX), ????? ??? SAP BW ??? Microsoft Analysis Services. ??? ???? ????????????? ? ???????????? ??????? ????? ????????????? ????????? Oracle BI Suite Enterprise Edition ?? ?????????? Oracle, ??????? ???????? ?? ?????????? Siebel Analytics, ????? ???? ???????? ????????.

? ???? ?????? ? ??????????? ?? ?????????? ??? ????? ????????????? ????????? ?, ????????, ????????????? ?????? Oracle BI Server, ?????????????? ?????? ??????????? (?business intelligence application server?), ??????? ????????? ??????? ????? ???????????????? ???? ?????????. ?? ????????, ??? ?? ?????????? ? ????????, ???????????? ???????????? ????????? Oracle ? ?????????? ??? ???????? ??????? ??????????? ? ??????????? (OLAP) ?????? ? ???? ??????. ? ????? ??????????? ?? ?????? ??????????? ? ?????? ?????????? ???????????? ????????, ??????? ???????? ?????? Enterprise Edition, ? ?? ????????????????? ? ???, ??? ???????? ???????????? ????? ???????????? ???? ????? Oracle BI Server.

????????? ????????? ????? ????????????? ????????? Oracle

??????????? ????????????? Oracle ??????? ? ?????????? Oracle Business Intelligence 10g, ? ??????? ???????? Discoverer, Reports ? Discoverer Portlets ??????? ? ???? ??????????? ??????? ? ?????? ?????? Fusion Middleware. ? ??? 2006 ???? ?????????? Oracle ???????? ??? ??????????? ??????? ????? ?????????? ????????????? ????????????, ?????????? ????? ???????????? ???????? Siebel, ????????? ?????? ??? BI Suite Enterprise Edition. ??? ????????? ???? ???????????? ??? ?????????? ???????????? ??????????? ???????, ??????? ????? ?????????? BI Suite Standard Edition. ?

??? ??? ?? ??? ?????, Oracle BI Suite Enterprise Edition?

Oracle BI Suite EE ? ??? ????????????? ????????? Oracle’s «?????????? ?????????». ??????? ???? ????????? ???????? ?????? Oracle BI Analytics Server, ????????????? «?????? ??????????», ????? ???? Oracle BI Suite Enterprise Edition ???????? ????????? ???????????? ??? ???????????? ???????????????????? (ad-hoc) ????????, ???????? (delivery) ? ????????????? (presentation) (???????????) ? ???????????? ?????????? ? ???? ??????????? ?????????? ??????.

? ??????? ?? ????? ?????????, ??? OracleBI Discoverer, Oracle Reports Services ? Oracle Portal, ???????? ???????????? ???????? ? ???????? ??????????? ? BI Suite Enterprise Edition ???? ? ?????? ?????? ????????? ??? ??????????? ????????????? ????? ? ??? ?? ??????????, ????????? ??????? ??????????, ?????????????? ?????????? ? ???????????? ?????????????????. ??? ??? ???????? ???? ??????? ? ??????????? Dynamic HTML, ??? ????????????? ????????? (rich) ???????????????? ?????????, ?? ??????? ??????? ?????????? ?????? Web-????????. ?

?? ?????? Siebel Analytics

?????????? ? ????????, ??????? ?????????? Oracle BI Suite Enterprise Edition, ???????? ?? Siebel Analytics, ????????, ??????? ?????????? Oracle ????????? ??? ??????? ???????? Siebel ????? ? 2006 ????. Siebel Analytics ??? ??????? ?? ??????????, ??????? ????????? ???????? Siebel ?? ????? nQuire ? 1999 ???? ? ??????? ?????? ???????? ? ??????? ??? ????????????? ????????? ?????????? ?????????. ??? ????????? ????????? Siebel ????? 25% ?? ??????? ?? ??????? ????????. ?

????????????? ???????? Oracle BI Suite EE ????? ???????? ?? ?????????? Siebel Analytics ? ????????? ? ????????? Oracle, ????????????????? ??? ?????? ? Oracle’s Fusion Middleware. ?? ???????? Oracle ??????? (? ??? ?????????) ?????? ???????????????? ?? ?????? ????? ?????????, ??????? ????? ????????, ??? XML Publisher, Oracle Business Activity Monitoring ? Oracle Portal, ? ???? ???????? Siebel ????? ????????? ??? ?????????????? ???????????? ?????????????. ?? ???????????, ???????? ??????? ? ?????? BI Analytics, ??????? ??????????? ? ???????????? ???????????, ?? ????????? ? ??? ???????????? ???????????? ????????? ?????????? ???????? Oracle ?? ??????????? ???? ????????????? ?????? ? ???? ?????? Oracle ? ????? ???????????? ??????? ? ?????????????? ???????????? Oracle ? ???? ???? ??? ????????? ??????.

????????? ????????? Siebel Analytics

?? ?????? ?????? ? Oracle, ????????? Siebel Analytics 7.8 ???????? ?? ???? ??????? ?????????:

  • Siebel Business Analytics Platform ? ?????????????? ??????? ??????????, ???????????? ????????????????? ? ???????????? ???????, ??????? ?????? ?????????? Oracle BI Suite Enterprise Edition;
  • Siebel Analytics Applications, ?????? ?????????????? ?????????????????? (pre-packaged), ???????????? ??????????, ??????????? ? ??????????? ???????????? Analytics Platform. ??? ?????????? ?????????? Oracle ????? ????????? ??-???????? ??? ?????? Siebel Business Analytics Applications. ?

?? ??????? ???????? Siebel ??????????? Oracle, ???????? ??????????? Siebel Analytics ? ???? ????????? ???? ?????????????? ?????????????????? ??????????, ???????? ??????? ???????????? ???, ??? ? ??? ??? ???? ?????????? ? Siebel CRM ? ???????? ERP-???????????, ?????????? ???????? workflow, ? ??? ????????? ?? ??????? ? ????? ??????? ????????????? ?????????. ?????????? ? ???????, ?????? ????????, ??? Oracle ??????? ??????? ??? ??????? ????????????? ?????????? ????????? Fusion ?????????? Siebel Business Analytics Applications. ?

?? ?????? ?????? ? ??????????? Oracle ???????? Siebel ??????????? ????? ???????????? ? ????????? ????????? Siebel Analytic Applications, ?????? ?? ??????? ?????? ???????????? ??? ???????? Oracle, ??, ?? ???? ?????????, ???????? ???? ??. ??? ????????:

  • Sales Analytics,
  • Service and Contact Center Analytics,
  • Marketing Analytics,
  • Financial Analytics,
  • Supply Chain and Supplier Analytics,
  • HR/Workforce Analytics ?
  • Real-Time Decision Solutions. ?

??? ????????????? ?????????? ???????????? ? ETL-????????? ? ????? ??? 3000 ERP-????????, ??????? ?????????? ? Siebel CRM, Oracle e-Business Suite, SAP, PeopleSoft ? ??????????? ?????????? call-???????.

Oracle BI Suite Platform

?????? ????? Oracle BI Suite Enterprise Edition ??????? ?? ?????????? Siebel Analytics Platform, ?? ??????? ???? ???????? ????????? Oracle. ?? ???????? ?????? ???????? Oracle ????? ?????????? ? BI Suite Enterprise Edition ? ???????????? Siebel-???????? ????? ?????????. ??????????? ??????? ??????? ?????? Oracle BI Suite Enterprise Edition ????????:

  • OracleBI Analytics Server, ????? Siebel Analytics Server
  • OracleBI Interactive Dashboards, ????? Siebel Intelligence Dashboard
  • OracleBI Answers, ????? Siebel Answers
  • OracleBI Delivers, ????? Siebel Delivers
  • OracleBI Disconnected Analytics, ????? Siebel Mobile Analytics
  • OracleBI Reporting & Publishing, ?? ?????? ?????????? ?? Actuate

????????? ? ???????????? ???????????? ???????? ?????? Oracle

Oracle BI Suite EE, ??? ? ????? Siebel Analytics, — ??? ???????????? (federated) ???????. ?????????? ?? ??? ? ???????????? ???????? Oracle ? ?????????? ??????, ????? ?????? ?????????? ?? ??????????? ?????????? ?????? ? ??????????? ? ???? ?????? (????????, ??????? ? ???? ????????????? ???? ?????? ? ????. ???.), ? ????? ????????????? ? ??????????????? ????????? ??????? ??????????? ?? Oracle BI Suite EE ????????????? ? ????????? ?????? ??? ??? ???-?? ?????????????? ? ?????

???????, ?? ??????? Oracle BI Suite EE ????? ????????????? ??? ???????????? ???????? ??????, ??????????? ? ???, ??? Analytics Server ???????????? ?????????? ???????? ? ????????? ?????????? ?????? ? ?????? (joins) ?????????? (???????? ? ???) ?????? ????? ?????????????? ????????????. ?? ????, ?? (Analytics Server) ????????? ?????????????? ????, ??????? ??????????? ??????????? ????????????? ???????? (staging area) ????????? ??????. ????? ????, Analytics Server ?????? ?????????? ? ?????? ?????????? ? ??????-??????????? (business definitions), ??????? ??????? ?????????????, ? ???????????.

??????, ?? ?????? ?????????? BI Suite EE ??????????? ????? ? ????????????? ??????????? ???????? Cognos ? Business Objects, ? ??????? ????? ??????????? ?? ????????? ??????? ?????? ??????????, ???????? ????? ? ?????????? (roles and permissions), ? ??????????? ????? ????????????? ?????? ? ??????/????.

? ????????????????, ??????????? ????????????? ????? ???????????? Oracle BI Suite EE ??? ?????????? ? ????????????? ????????? ?????? Oracle; Oracle BI Suite EE ????? ?????????????? ??? ???????? ???????????? ???????? ? ??????? ??? ????? ????????? ??????, ? ????? ????? ?????????????? ??????, ????? ??? ??????? ??????????????? ?????? ??? ??????, ???????? ? ??????????? ???????? ??? ?????? XML, ????? ??????????? ????? ? Analytics Server, ????? ??? ?????. ????????????? ? ??????? ? ??????????????? ?????? ?? ????????, ? ????????? ?????? ? ETL-????????????, ????? ??? Oracle Warehouse Builder, ???????? ????????? ?????? ??? ?????????? ?????? ???? ??????????.

????????????? ?????? Oracle — Oracle BI Server

??????? ????????? Oracle BI Suite EE ???????? ????????????? ?????? Oracle BI Server. ??? ?????????????? ?????? ??????????? («business intelligence application server»), ??????? ????????????? ????????? ??? Oracle Answers, Oracle Dashboards ? ?????? ??????? ???????????? ????????, ????????? ?????????? ? ??????? ? ????????????? (business and presentation), ???????? ?????? ?? ??? ?????? ? ??????????, ???????? ? ???????????? ?? ? ???????? ?????????? ???????? ???????????? ???????? (query tool).

Bi server

????????????? ?????? Oracle ? ???, ? ????????, ROLAP (Relational OLAP) ??????????? (engine), ??????? ??????????? ? ?????????? ??????, ?? ?? ????? ????????? (???????) ?????? ? ????????????, ??? ??? ??????, ??????. ???? ? ???? ???? ????? (cache), ? ??????? ???????? ????? ????????? ??????, ??? ??? ??????????? ??????? ? ???? ?? ?????? ??????????? ???????. ??????? OracleBI Discoverer, ????????????? ?????? Oracle ?????????? Enterprise Semantic Model (????????????? Discoverer End User Layer), ???????, ??????, ?????????? ?? ???? ?????: Presentation (?????????????), Business (??????) ? Physical (??????????).

????????????? ?????? Oracle ??????? ????????????? ??? ??????????? ?? ??? ??????. ?????????? ?????????????? ?? ???? ???? ? ??????????? ODBC- ?????????, ? ????? ? ?????? ?????????? ????????????????? ??????, ????? ??? ??????????? ??????? Microsoft Excel ? XML-?????????. ??? ?????? ?????? ??????? ?? ???-??????????, Analytic Server ?????? ??? ??????, ???? ?????, ????????? ?????????? ? ?????? ????????? ? ????????????? ?????????? ????????????? ????? ????????? ??? ???????? ???????????? ????????. ??? ?????????????? ?????????????? ??????? ????? ?? ???????? ????? ???? ????????????, ????????? ??? ????????, ??????????? ???????? ? ????? ? ??????????? ??????? ? ?????-??????????. ? ??? ????????????? ?????? ????????????????? ?? ?????, ?????????????? (??????????) ??????, ?????????? ?????? ????????????? ? ????????????, ???????? ??????????? ???????? ???????????? ????????.

??????, ??????? ????? ?????? ??? ???????????? ?????????????? ???????, — ?? ????? ??????? ?? ???????????? (scale up), ????? ?????????? ? ?????????? ?????? ?? ???????????? ??? ??????. ? ??? ?? ?????????? ????????????? ?????? ? ???????? ?????? ??????,? ?????? ????????????? ????????? Siebel ??????????, ??? ?????? ????? ????????????? ??????? ????? ???????????? ?????????????, ???????? ???????? ? ??????????? ? ?????????? ?????????? ??????, ????????? ?? ?????? ??????????. ????? ????, ???? ????????????? ?????? ?? ?????? (?? ??????? ??????) ???? ??????, ?? ???????? ??????? ?????????? ???? ???????? ???????????, ??????? ????????? ????????? ???????????? ?????????????, ??????????? ????????????, ??????????? ?????????? ?? ????????? ?????????? ?????????? (Unix ? Microsoft Windows, ???? Linux ??? ???), ??????? ?????????????????? ? ???????? ???????? ??????, ????????? ??????? ?????????? (highly available) ? ??????? ??????? ???????????. ???????????? ??????? ?? ??????????? ???? ? ??? ?????????? ???????? ?????? ?? ??????? ?????? (?? ??????????? ???????????? ??????????? ????????) ? ?????????? ????????? ??????????.

Oracle Analytics Web

Oracle Analytics Web ? ??? ?????????? ???????? (application framework), ??????? ????????????? ?????? ? OracleBI Answers, Delivers ? ?????? ???????????? BI Suite Enterprise Edition. ??? ??? ?????????? ?????? Analytics Web ??????????? ??? ?????????? ?? Web, ? ??? ??????? ??????? c ????????? ???????????????? ??????????? ?? ?????? HTML, DHTML ? Javascript. ? ??????? ?? OracleBI Discoverer Plus ??? ?? ??????? JVM (??????????? ?????? Java) ?? ?????????? ?? ? ???????? ? ????????? Java-???????. ?

Oracle Analytics Web ????????? ???????? ????????? web-???????? ??? ????????????????. ?

OracleBI Answers

OracleBI Answers ? ??? ?????????? OracleBI Discoverer ? BI Suite Enterprise Edition. ??? ?????????? ???????????? ???????????????????? ???????? ?, ??? ? ?????? ??????????? Analytics Web, ???????? ? ??????-??????? (business model). ?? ???????????? ??? ???????? ? ?????????? ???????, ??????? ????? ????????????? ????? OracleBI Interactive Dashboards. ?

OracleBI Interactive Dashboard

OracleBI Interactive Dashboard (????????????? ?????????????? ??????) ????????? ?? ?? ????, ??? Oracle Application Server Portal ? BI Suite Standard Edition; ???? ?????????? ????????????? web-???????? (framework) ??? ???????? ????????? ??????? ????????????? ?? ?????? ?????????? Web-????????. ? ??????? ?? BI Suite Standard Edition, ?????? ? ?????????????? ?????? ????????? ???????????? ? ?????????? ?????? ?? ???? ?? ??????????? ? ?????? ????????? ??????? (display live, up to date data) ?? ??????????. ?

??????????? ????????? ? ??????????? ?????????????? ??????

?????????? ???????? Interactive Dashboards ???????? ????????? ??? ?Guided Analytics? ? ??????????? ?????????. ??? ??????? ?????? ? ???????????? ????????? ? OracleBI Delivers ??????????? ??? ????, ????? ?????? ??????-????????????? ?????? ? ?????????? ??????????/???????? (navigate) ??????????? ???????? ? ????????????? ??????????????? ????????. ?

???????? Oracle BI Server

??????? ????????????? ? ????????? Oracle BI Suite Enterprise Edition, ????????? ????????? ?? ?? ????????????? ??????.

???????????

Oracle BI Suite EE ? ??? ?????? ????????? ??? ?????????? ????????????? ??????????. ??? ???????? ????????? ????????????, ?????????? ??????????, ??????????? ????????????????? ? ODBC-?????????? ??? ????????? ? ????? ??. ??? ????? ???????????????? ????????????? Oracle BI Server ?????????????? ? ???????? ?????????????? (authentication cab) ????? ???? ?????????? ??? ????????? ??? ??????? ? ?????????????? LDAP ???? ???????? ?????????????? ???? ??????.

Bi server

? ?????? ??????????? ???? ????????? — Oracle BI Server. ?? ???????? ???????, ????????? ? ???????????????? ?????????? ???????? — Intelligent Request Generation. ??? ??????????? (?? ?????? ?? ?????????? ?????????) ???????????? ???????? ???????, ???????? ?????? ?? ??????????????? ??????????, ?????? ?? ? ????????? ????????? ??????????. ????????????? ?????? ????? ????????? ?????????? ???????? ? ???????????? ????????, ????????? ??????? ???????????? ? ??????????? ?????? (security and scopes data), ? ???????????? ?????? ????????????? ???????? ?????????? ??????-?????? (logical business model).

Oracle BI Web ? ??? web-?????????? ?? C++, ??????? ????????????? Web Catalog, ?????????? (front-end) ??????????, ????? ??? Oracle Answers ? Oracle Dashboards, ODBC ?????? ? XML- ? URL-???????????? web-???????? SOAP. ?

????????????????? ??????? Oracle BI Server ?????????????? ? ??????????? ???????????? ??????????? (? ????? Windows), ??????? ????????????? ?????? ? ????????? Semantic Model, ? ????? ? (????????????) ????????????? ? ?????, ????????????, ????? (jobs), ???????????? ????????????????? ???? ? ???????????????.

?, ???????, ???????? ? ?????????? ?????? ???????????? ???????? ??????????? ?????????????? ??????? ? ?????????? ? ??????????? ?????????? ??????, ? ???? ????? ??? ODBC ? Oracle BI Web ????????? ??????????? ??????? ????, ????? ??? Business Objects, ???????? ?????? ? ?????? (??????????????) ??????? ????? Semantic Model.

???????????? ????????? ??????

??? ????? ??????????, ???????? ????? ?????????????? ??? Siebel Analytic Server ???? ????????????, ????????? ??? ????????, ??????????? ????????? ? ????? ?????? — ??????????, ??????? ?????? ??????. ? ???????? ??????, ????? ?? ?????????????? Siebel Analytics, ?? ??????????? ?????????? ? ???? ????? ?????? (Oracle, Microsoft SQL Server, IBM DB2), ?????????? ??????, ??????

??? ???????, ? ????? ??????????? ???? ??????? ? ????????????? (business and presentation layers (the «Enterprise Semantic Model»)) ? «Enterprise Semantic Model» ??? ????? ?????? ???????. ? ?????, ????? ???????????? ??????????? Analytic Server, ????????? ?????????? ???????, ?? «??????????» ?????? ????????????? ? ???? ??? ????????? ???????? ? ????? ?????? ?????????? ? ??????????????? ?????? ??????????. ???? ??? ? Analytic Server ???????????, ?????????? ????? ??????? ???????????? ? ??? ??? ????? ???????? ????????????? ? ???????????? ???????????? ????????????.

Siebel Analytic Server ? Oracle BI Analytic Server ???????????? ?????????? ?? ?????? ?????????? ??????. ??????????? ?????? ????? ???? ??????? ?? ????? ???? ?????? (? ??????????? ODBC-????????), ??????? Oracle, Microsoft SQL Server, IBM DB2 ? Teradata. Analytic Server ????? ???????????? ?????????? ? ?????????? ??????????? ?????? (???? ??????? MDX), ????? ??? Microsoft Analysis Services ? SAP Business Warehouse, ? ????? ? ???????? ? XML-??????????. ????? ?????? ?? ???? ?????????? ????????????? ? Analytic Server, ???????????? ????? ??????????????? ????????????? ????? ?????? ????????? ??????, ??????? ????? ???????? ???????? ?? ???????????? ?????????? ??????, ????????? ??????? ? ???? ? ?? ?? ??????? ?????? ? ????????? (fact and dimension objects).

????????????? ?????? ?????? ???????????

??? ? OracleBI Discoverer, ?????? Oracle BI Server ???????????? ?????? ????????????? ???????? ?????????? ??????-??????. ? Discoverer ??? ???????? ??? End User Layer, ? ? ???? ??????? ??? Enterprise Semantic Model.

??? Semantic Model ???????? ??? ????:

  • ?????????? ????, ??????? ???????? ?????????? ? ?????????? ?????????? ??????, ????? ??????, ????????? ? ??????????? (primary and foreign) ????? ? ???????? ????? (row counts);
  • ??????-????, ?????????? ????, ??????? ???????? ??????????? ????????? (dimensional constructs), ?????????? ???????, ??????? ?????????? ? ????????? ?
  • ???? ????????????? — ??????????, ????????????????? ????????????? ??????, ? ??????? ????????? ? ??????????? ???????????? SQL?.

????????????? ?????? (Semantic Models) ???????? ? ????????????, ?????????? ?????????? ?? ???? ??????, ??????? ????? ???? ???????????? ??? ????????? (offline or online). ?? ????????????????? ??????????? ? ?????????????? ??????????? Administration tool ?????????? ????, ??? ???????????? OracleBI Discoverer Administrator.

?????????? ?????????????????

Analytic Server ? ? ??????????? Enterprise Semantic Model ???????????????? ? ?????????????? Administration Tool — Windows-??????????, ??????? ??????????? ? ???????????? ? online ??? offline ?????????.

Bi server

Administration Tool ???????????? ??? ???? Enterprise Semantic Model ??? ??? ?????? (panes), ????????? ???? Presentation, Business Model and Mapping ? Physical layer ????? ???? ? ??????. ????????? ???? ??????????, ?? ?????? ????????? ? ?????? ????????????? ? ??????, ????????? ?? ?????????? (assign permissions), ????????? ????? ? ????????? ?????? ??????.

?????????? ???? — Physical Layer

?????????? ???? ????????????? ?????? ?????? ? ??????????? ???????????? ? ?????????? ??????, ?????? ? ??????????? ??????????? ?????? (physical data structures), ? ??????? ??? ???????????? ??????. ??? (?????????) ????? ???? ??????????? ??????????? ??????, OLAP ????? SQL-????????????? (views) ??? MDX-, XML-, ??? ????? ???????? ?????? ? ODBC ???????????. ? ? ?????????? ? ??????????? ? ???????? ??? ??????, ?????????? ???? ????? ???????????? ?????????? ? ERP- ? ?????? ???????????, ????? ??? Siebel CRM ??? Oracle E-Business Suite.

??????-???? — Business Layer

??????-???? ???????????? ??????? ?????????? ??? ??????????? ????????? ? ????????? ?????????????? ???????????? ?????? ? ?????????? ???????????? ??????? (logical subject areas). ????????? ?????????? (Drill paths) ????? ???? ??????????? ?????? ??????????? ????????? (dimensions) ? ??????????? (measures). ??? ????? ???????????? ?????????????? ??????????? ??????????? ?????????? (in-built calculation engine) ? ????????????? ???????.

???? ????????????? — Presentation Layer

???? ????????????? ??????????, ??? ???????? ???????????? ??????, ????? ??? ?????? ???????? ?????? ? OracleBI Answers. ??? ????? ???? ?????? ????? ?????? ? ??????-???? ??? ?????? ????????, ? ?? ?????? ????????? ??????? ? ??????????? (scoping), ??? ??? ????????? ???????????? ?????? ?????? ???? ??????.

????????? ????????

??? ???????? ????, ????? ?? ??????? ????? ?????????????? Oracle BI Server ???????? ????????????, ????????? ??? ????????, ??????? ????????? ??????? ? ????? ???????? ??????. ?? ???? ????? ?? ???????????, ??? ?????????? OLAP ???? ?????? ????? ????? ??? ?????????? OLAP-?????????? ? ???????; ?????????????????????? ??????????? ???? ??????, ????? ??? Oracle, ????? ????? ? ?????? ?? ????????????? ???????? ?????? ?, ????? ??? ????????, ?????? ??? ?????????? ?????? ?????????????? ??? ?????????, ? ?? ????????????? ??????. ????, ??????? ???? ?????? ??????, ??????????? ? ???, ??? ?? ????????? ?????? ? ?????????? ???????? ?? ??????????? ???????? (query tool) ? ????? ??????????? ???? ?????????? ?????? ? SQL (? MDX) ? ????? ???????? ??????. ????? ??? ???? ?????? ?????????? ???? ??????????, ????????????? ?????? ?????? ??????, ???? ?????, ????????? ??? ????????? ??????????, ??????????? ??? ?????? ? ?????????? ?? ??????????? ????????.

Анатомія в таблицях

SQL-???????????, ??????? ???????????? ??? ?????? ???? ??????, ??????????????, ????? ??????????????? ?????????????? ????????? ?????? ???? ??????, ? ?? ?????? ????? ???????? ?????? ? ?????? ? ?????????????? ???????? (aggregate tables), ???? ?? ??????? ? ???????. ??? ????? ????????, ????????, ??? ?? ?????? ????? ?????????? ????????? ?? ????? ??????? ??????? ?????????????, ?? ?????????????? ?????? ? ???? ??????, ??????? ?? ?????? ???????????? ??? ?????? ??? ????????? ?????????? ? ??????? (query rewrite mechanism) ? ???? ?????? Oracle. ??? ??????????? ????? ????? ??????????????, ????? ?????? ?????????????? ??????? ????????????? ??????? SQL-????????????? ??? ?????????????? ???????????? (analytic workspace), ???? ????????? ????????????? ????? ???????? ??????. ????? ???????? ??????????? ? ???, ??? ??????? ????????????? ???????? ????????, ????????? ????? ???? ? ????? ???????? (?A day in the life of a query?) ?

????? ???? ? ????? ????????

???????????? ?????????????? ? OracleBI Answers ? ?????????? ??????. ???? ?????? ???????? ???????? ?????? ?? ????????? Products ? ??????????? (measures), ?????????????? ????? ?? ???????? ??????? (total closed revenue), ?????????? ???????? ?? ???????????? (numbers of service requests) ? ???? ?????? ?? ??????? (revenue share by brand).

???? ?????? ????? ??????????? ? ?????? ?logical SQL? ? ?????????? ?????????????? ???????.

??????, ??? ??????? ????????????? ??????, — ??? ???????? ????, ????? ??????????, ??? ?? ??? ??? ??????, ??????? ????????????? ???????? ???????.

??????? ?????????, ??????????????? ????????????????? ????????????? ? ?????????? ????????, ?????? ?? ???? ????? ???? ????????????, ???? ???? ??? ?? ????????????? ??????? ???????; ???????????? ???????????? ?????? ????? ??????????????, ??? ????? ??????????????. ?????????? (derivations) ????? ??????????????, ???? ??? ???????????? ?????? ???????, ??? ??????? ???????? ???????????.

???? ?? ??? ?? ????? ????????????? ??????, Navigator ?????????? ???? ?????? ? ?????? ??????? ??????? ?????? ?? ??? ?????? ??????????.

?????? ???, ??????? ????????? navigator, — ??? ??????????? ????, ??????? ?? ???????? ??????? ??????????? ???????, ?????? ??? OLAP-??????????. ???? ??, ?? ?????? ???????? ??? ????????? ??????, ? ?????? ???? ?? ???????? (OLAP-capable) ? ????? ?????????; ???? ?? ???????? ?? ???????? ? ??? (????????, ??? ???? ?????? ???? Microsoft Access ??? ????), ?? ?????????? ????? ????????? ?????? ?????????????? ???????. ? ????? ?????? ?????????? ???? ??????????? ???? ?????? (Revenue Share) ???????? ?????? ? ??? ????????? ?, ???? ? ???? ?????? ???? ?????? — Oracle, ?? ??? ??????????, ????????, ????? ???????? ??????? ???? ???? ?????? ??? ??????????.

??? ?????? ??????? ?????? ? ??????? ?? ???????? ??????? (closed revenue data) ????????? ? ???? ?????? ??????? ????? (general ledger), ? ?? ?? ????? ?????? ?? ???????????? (service request data) ????????? ? ???? ?????? ?????????? ?????? ???????????? (call centre application). ??????? ??????????? ???????????? (fragmentation optimization element) ?????????? ????? ?????????? ????????? ?????? ???????? ??????? ??????????????? ???????? ??????, ????????????? ???????? ??????? (fan traps), ???? ?????.

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

?????, navigator ????? ????????? ??????? ????????, ??????? ????????????? ? ????? ?????????????, ????? ??????, ????? ?? ?? ???????????? ?????? ?????????? ????????????? ?? ????????? ?????? (detail-level data) ??? ?????.

???????, ?????? ????????? ??????, ????? ???????????? ?????? (internal) ???????????????? ??????????, ???? ???????? ?????? ?? ????? ?? ?????????, ??? ????? ??????????? ????????? ??????? ???? ???????????????? ???? ?????????? ??????.

SQL- ? MDX- ???????????, ??????????????? ??? ????????? ????????, ?????????????? ??? ?????? ?? ???, ? ????????????? ?????????????? ??????? ????? ?????????? ??? ??????????? ????????? ??????? ??? ?????????? ????????, ??? ???, ????????, SQL-??????????? ? ?????????????? ????????? (analytic SQL) ????? ????????? ??? ?????????, ?????????????? ????? ???????, ????? ??? ????? ??????????.

?????, ??? ???????? ????????????? ??????, ?? ???????? ??????? ?????? ? ???????????? ???????, ??????? ???????????? ??? ?????????? Semantic Model.

?????? 1: ?????????? Semantic Model

? ???? ??????? ?? ????? ???????????? ????? ?????? Global Electronics, ??????? ?? ????? ????????? ?? ????????r. ???????, ?? ??????? ??????????? ???????, ?????????????? ??? ???????? ??? ??????????? ?????????????? ???????????? (Global analytic workspace) ? ???????? ??????, ???????? ??? ???????. ? ?????, ?? ??????? ??? ????????????? ???????????? ? ???????, ??? ????????? ?????? ? ???. ?

?????????? ? Oracle OLAP

?? ??? ???, ?????? ??? ?????????? Enterprise Semantic Model ??????? ?? ??????????? ?????? ? ???? ?????? Oracle, ??? ??????, ??????? ????????????? ???????? ?????? ??? Global analytic workspace. ? ????????? ???????????????, ??????, ???????? ????? ?? ????????????? ?????????? ?????? ? ??????? ???????? ???????????? (highly summarized data) ??? ??????, ? ???????? ??????? ???????, ??????????? ?????????? ??? ????????, ??, ????????, ??????????? ????? ???????????? ??????, ???????? ? OLAP Analytic Workspace. ?

?????? 2: ????????????? OLAP-??????

? ???? ??????? ?? ??????????, ??? Oracle BI Suite Enterprise Edition ????? ?????????????? ??? ??????? ? ?????? ? ????????????? ?????????????. ??? ???????????? ???????????? ????? ?????????? ??? ???????? ? ???????????? ?????? ??? ???????, ??? ??? ??? ???????? ?????? ????? ?? ??????, ?????????? ?????????? ??????? ? ??????????? ? ad-hoc ????????? ????? ??????????, ??? ??????????? ???????

?? ????? ???????????? Global Analytic Workspace ?? ?????? Global Sample Schema, ??????????? ??????? ?????????, ??????? ?? ???????????? ? ?????????? ???????. ??? Analytic Workspace ???????? ??? ?Units Cube?, ??????? ???????? ??????????? Product, Customer, Time ? Channel.

Анатомія в таблицях

??? ??? ???????? ??? ???????????: Units, Sales ? Cost, ? ???? ????????? ????????? ???????? ????????? ????????, ??, ????? ?? ????????? ??????, ????? ???????????? ?????? ???? ???????? ??? ??????? ?????????.

? ??????? ?? OracleBI Discoverer Plus OLAP, Oracle BI Suite Enterprise Edition ?????? ?????? ? ????????????? ????????????? ? ?????????????? SQL views, ? ?? Java OLAP API. ?

????????????? Oracle BI Server ? Oracle Analytics Web

?????? ???? ???????? Semantic Model, ?? ????? ??????? Web-??????? ? ?????? ????????? ????????????? ?????????????? ?????? (interactive dashboards) ? ?????????????? OracleBI Answers ? OracleBI Dashboards, ???????????, ????????? ????? front-end ??????? Oracle BI Suite Enterprise Edition — Oracle Analytics Web. ?

??????????

Oracle BI Suite EE ? ??? ????? ??????? ????????????? ????????? Oracle, ??????? ???????? ?? ?????????? Siebel Analytics, ??????????? ? Oracle Fusion Middleware. ??? ???????? ?????????? ????????????? ??????, ?????????????? ?????????? ? ???????????? ?????? ?????? ? ????????????. ???? ?????? ???????? SQL-??????, ???????????? ???????? Semantic Model, ? ??????????? ??? ? SQL- ? MDX- ???????????, ???????????????? ??? ?????????? ????????. ?? ???????????? ???????????, OLAP-, XML- ? ?????? ????????? ?????? ???????? Enterprise Semantic Model, ?????????? ?????????? ????, ??????-???? ? ???? ?????????????.

Oracle Analytics Web ? ??? web-?????????? ????? ????????? BI Suite Enterprise Edition, ??? ???????? OracleBI Answers, Interactive Dashboards, Delivers, Disconnected Analytics ? Briefing Books. ????? Analytics Web ??? ??? ?????????? ????????? ?????????? ???????? ????????????, ??????????? ? ????? ????????????? (look and feel).

home work

?c??????: http://www.oracle.com


Смотрите также:

Tags: , , , , , , , ,

Readers Comments (Комментариев нет)

Comments are closed.

Exchange 2007

Проведение мониторинга Exchange 2007 с помощью диспетчера System Center Operations Manager 2007 (часть 3)

Если вы хотите прочитать предыдущие части этой серии статей, перейдите по ссылкам: Проведение мониторинга Exchange 2007 с помощью диспетчера System ... [+]

Практическое рассмотрение перехода с Exchange 2003 на Exchange 2007 (часть 1)

Введение В этой статье из нескольких частей я хочу показать вам процесс, который недавно использовал для перехода с существующей среды Exchange 2003 ... [+]

Использование инструмента Exchange Server Remote Connectivity Analyzer Tool (часть 2)

Если вы пропустили первую часть этой серии, пожалуйста, прочтите ее по ссылке Использование инструмента Exchange Server Remote Connectivity Analyzer Tool (Часть ... [+]

Мониторинг Exchange 2007 с помощью диспетчера System Center Operations Manager 2007 (часть 2)

Если вы пропустили предыдущую часть этой серии статей, перейдите по ссылке Мониторинг Exchange 2007 с помощью диспетчера System Center Operations ... [+]

Подробное рассмотрение подготовки Active Directory для Exchange 2007 (часть 5)

Если вы пропустили предыдущие части этой серии статей, перейдите по ссылкам: Подробное рассмотрение подготовки Active Directory для Exchange 2007 (часть 1) ... [+]

Установка и настройка Exchange 2007 из командной строки (Часть 3)

If you missed the previous parts in this article series please read: Exchange 2007 Install and Configuration from the command line (Part ... [+]

Использование инструмента Exchange Server Remote Connectivity Analyzer Tool (часть 1)

Инструмент ExRCA Текущий выпуск инструмента предоставляется только в целях тестирования и оснащен 5 опциями: Тест подключения Outlook 2007 Autodiscover Тест подключения Outlook 2003 RPC ... [+]

Развертывание сервера Exchange 2007 Edge Transport (часть 5)

Если вы хотите прочитать предыдущие части этой серии статей, перейдите по ссылкам: Развертывание сервера Exchange 2007 Edge Transport (часть 1) Развертывание ... [+]

Установка и настройка Exchange 2007 из командной строки (часть 2)

Если вы пропустили первую статью данного цикла, пожалуйста, перейдите по ссылке: Exchange 2007 Install and Configuration from the command line (Part ... [+]

Использование интегрированных сценариев Using Exchange Server 2007 – часть 2: генерирование отчетов агента Transport AntiSpam Agent

Если вы пропустили предыдущую часть этой серии статей, перейдите по ссылке Использование интегрированных сценариев Using Exchange Server 2007 – часть ... [+]