Oracle BI Server by AORTA

60 %
40 %
Information about Oracle BI Server by AORTA
Business & Mgmt

Published on July 19, 2009

Author: guest066f569

Source: slideshare.net

Description

AORTA BI Solutions is specialized in implementing the Oracle BI Suite. The BI Server is the integrated platform to achieve al the necessary business requirements.

Rick van der Lans referred to it. He calls the BI Server an good example of which he calls the Data Delivery Platform.

AORTA BI Solutions De Oracle BI Server : de grote onbekende Leander van Dongen Hoevelaken, 11 juni 2009 De Oracle BI Server: de AORTA BI Solutions B.V. Fultonbaan 20 3439 NE Nieuwegein www.aortabi.nl

Oracle BI Suite One Platform, One Model, Multiple Delivery Channels Data Ad-hoc Interactive Essbase Reporting & Proactive Disconnected MS Office Integration Analysis Dashboards Analytics Publishing Detection & Mobile & Outlook and Alerts Analytics Integration Common Enterprise Information Model Integrated Security, User Management, Personalization Multidimensional Calculation and Integration Engine Intelligent Request Generation and Optimized Data Access Services OLTP & ODS Data Warehouse Essbase SAP, Oracle Files Business Systems Data Mart PeopleSoft, Siebel, Excel Process Custom Apps XML

1 geïntegreerd platform 1 server 1 repository 1 informatie architectuur Ad-hoc Interactive Analysis Dashboards Common Enterprise Information Model | BI Server Data Warehouse Data Mart Applications

Architectuur Common Enterprise Information Model Presentation Layer Business Layer Connectivity Layer User roles Dimensions Map Physical Data Simplified view Hierarchies Connections Logical interface Measures Calculations Aggregation Rules Time Series

DB2 OLAP Oracle XML Data Source SQL Server ? DWH Benaderen stermodellen en/of genormaliseerde datamodellen

Business Layer 1. Facts & Dimensions • Hierarchies 2. Berekeningen • Afgeleide meetwaarden zoals cumulatieven, “Ago-functies” 3. Autorisatie • Functionele- en data autorisatie 4. Geoptimaliseerde data benadering • Waar haal ik de data vandaan?

Business Layer Data uit meerdere bronnen worden samengevoegd tot 1 ster

1. Facts & Dimensions SQL Server Oracle

2. Berekeningen Common Enterprise Information Model Business Layer Dimensions Hierarchies Measures Calculations Aggregation Rules Time Series

Year Ago Month Ago Quarter Ago

3. Autorisatie Common Enterprise Information Model Business Layer Autorisatie LDAP HRM ?

4. Waar zit de juiste data ? Common Enterprise Information Model Business Layer Dimensions Hierarchies Measures Calculations Aggregation Rules Time Series

BI Server Common Enterprise Information Model Revenue Budget 2008 Data Jan 2009– until last week Current Week Budget Disparate System Disparate System Disparate Systems Aggregated Data Region Quota Spreadsheet OLAP Cube Star Schema Data warehouse Detail Data (Transaction Level) Transaction ERP System

Toon de omzet vs budgetcijfers voor alle regio’s van vorig jaar BI Server Common Enterprise Information Model Revenue Budget 2008 Data Jan 2009– until last week Current Week Budget Disparate System Disparate System Disparate Systems Aggregated Data Region Quota Spreadsheet OLAP Cube Star Schema Data warehouse Detail Data (Transaction Level) Transaction ERP System

Toon de omzet vs budgetcijfers voor alle regio’s van vorig jaar Oracle Dashboard Oracle Answers Oracle BIPublisher BI Server Common Enterprise Information Model Revenue Budget 2008 Data Jan 2009– until last week Current Week Budget Disparate System Disparate System Disparate Systems Aggregated Data Region Quota Spreadsheet OLAP Cube Star Schema Data warehouse Detail Data (Transaction Level) Transaction ERP System

Vergelijk de omzet en budget van dit jaar met dat van vorig jaar BI Server Common Enterprise Information Model Revenue Budget 2008 Data Jan 2009– until last week Current Week Budget Disparate System Disparate System Disparate Systems Aggregated Data Region Quota Spreadsheet OLAP Cube Star Schema Data warehouse Detail Data (Transaction Level) Transaction ERP System

Vergelijk de omzet en budget van dit jaar met dat van vorig jaar Oracle Dashboard Oracle Answers Oracle BIPublisher BI Server Common Enterprise Information Model Revenue Budget 2008 Data Jan 2009– until last week Current Week Budget Disparate System Disparate System Disparate Systems Aggregated Data Region Quota Spreadsheet OLAP Cube Star Schema Data warehouse Detail Data (Transaction Level) Transaction ERP System

Toon de laatste omzet cijfers van dit jaar BI Server Common Enterprise Information Model Revenue Budget 2008 Data Jan 2009– until last week Current Week Budget Disparate System Disparate System Disparate Systems Aggregated Data Region Quota Spreadsheet OLAP Cube Star Schema Data warehouse Detail Data (Transaction Level) Transaction ERP System

Toon de laatste omzet cijfers van dit jaar Oracle Dashboard Oracle Answers Oracle BIPublisher BI Server Common Enterprise Information Model Revenue Budget 2008 Data Jan 2009– until last week Current Week Budget Disparate System Disparate System Disparate Systems Aggregated Data Region Quota Spreadsheet OLAP Cube Star Schema Data warehouse Detail Data (Transaction Level) Transaction ERP System

Subject Area’s Common Enterprise Information Model Presentation Layer User roles, preferences Simplified view Logical interface

Presentation Layer • Groepen • Presentatie volgorde • Subject Area’s

Architectuur Common Enterprise Information Model Presentation Layer Business Layer Physical Layer User roles, Dimensions Map Physical Data Preferences Hierarchies Connections Simplified view Measures Schema Logical interface Calculations Aggregation Rules Time Series

Rechtstreeks benaderen van de BI Server

En dan is het tijd voor …

Q&A

Add a comment

Related presentations

Canvas Prints at Affordable Prices make you smile.Visit http://www.shopcanvasprint...

30 Días en Bici en Gijón organiza un recorrido por los comercios históricos de la ...

Con el fin de conocer mejor el rol que juega internet en el proceso de compra en E...

With three established projects across the country and seven more in the pipeline,...

Retailing is not a rocket science, neither it's walk-in-the-park. In this presenta...

What is research??

What is research??

April 2, 2014

Explanatory definitions of research in depth...

Related pages

Oracle BI Server By AORTA - Technology - docfoc.com

Download Oracle BI Server By AORTA ... Context class: DocumentController: Inheritance: Controller » CController » CBaseController
Read more

Oracle BI Server By AORTA - Technology - documents.mx

1. AORTA BI SolutionsDe Oracle BI Server : de grote onbekende Leander van Dongenwww.leandervandongen.blogspot.comDe Oracle BI Server: de AORTA BI Solutions ...
Read more

Oracle Discoverer To OBIEE Migration By Aorta - Technology

1. AORTA BI Solutions Migratie van Discoverer naar OBI EELeander van Dongenwww.leandervandongen.blogspot.comDe Oracle BI Server: de AORTA BI Solutions B.V ...
Read more

Patching - Aorta Business Intelligence

The so-called Oracle HOME directory that is identified within the server path as the Oracle_BI folder. (E: ... Aorta Business Intelligence. youtube; linkedin;
Read more

Caching in OBIEE - Aorta Business Intelligence

The cache stores the results of the logical SQL that is sent to the BI server, ... server as “logical event.” Both Oracle BI ... AORTA BI Solutions B.V ...
Read more

Aorta BI (@AORTABI) | Twitter

The latest Tweets from Aorta BI (@AORTABI). World's first Oracle specialization partner for OBIEE11g. ... there was a problem reaching the server. Try again?
Read more

We Love IT - De Oracle BI Server als grote onbekende

De Oracle BI Server als grote onbekende ... Zoals bijvoorbeeld de implementatie van OBI door AORTA bij Scandinavian Tobacco Group uit Eersel ...
Read more

Understanding the Oracle BI Server, see the Light

Understanding the Oracle BI Server, ... Data Delivery Platform and the interesting relation between the Oracle BI Server. ... AORTA BI Solutions ...
Read more

Oracle Business Intelligence Suite | Whitehorses

Sinds 2006 beschikt Oracle over deze BI tool die oorspronkelijk afkomstig is van Siebel. September 2007 ... de BI Server. Over AORTA BI Solutions ...
Read more