protecting and extending your discoverer investment roadshow
TRANSCRIPT
![Page 1: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/1.jpg)
Protecting and Extending YourDiscoverer Investment
ROADSHOW
![Page 2: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/2.jpg)
The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
![Page 3: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/3.jpg)
• Einführung
• Optionen für Discoverer Kunden
• Oracle Enterprise Performance Management
• Mehrwert der Oracle BI Suite Enterprise Edition
• Migrationsüberlegungen
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 3
Agenda
![Page 4: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/4.jpg)
Einführung
• Ziel dieser Veranstaltung• Optionen für Discoverer Kunden• Mehrwert der Oracle BI Suite Enterprise Edition (BI EE)• Themen zur Diskussion
• Typ des Systems• Metadata• Workbooks
• Setzt Kenntnisse des Discoverer-Konzepts voraus
• Einführung in das BI EE Metadaten-Konzept
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 4
![Page 5: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/5.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 5
Agenda
• Einführung
• Optionen für Discoverer Kunden
• Oracle Enterprise Performance Management
• Mehrwert der Oracle BI Suite Enterprise Edition
• Migrationsüberlegungen
![Page 6: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/6.jpg)
• Discoverer beibehalten• Kontinuierliche, neue Release-Stände und Funktionalitäten• Dediziertes Entwicklungsteam• Deckung durch Oracle’s Lifetime Support• Keine erzwungene Migration
• Nutzung von Discoverer mit BI Enterprise Edition• Discoverer Integration mit BI Publisher• Discoverer Analysen sichtbar in BI EE Dashboards• Nutzung von BI EE Delivers für Alerting & Distribution von
Discoverer Analysen
• Discoverer-Migration zu BI Suite Enterprise Edition
Oracle BI Discoverer – Optionen
"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"
![Page 7: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/7.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 7
Agenda
• Einführung
• Optionen für Discoverer Kunden
• Oracle Enterprise Performance Management
• Mehrwert der Oracle BI Suite Enterprise Edition
• Migrationsüberlegungen
![Page 8: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/8.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 8
Oracle’s Enterprise Performance Management System
EPM Workspace
OLTP & ODSSystems
Data WarehouseData Mart
SAP, Oracle, Siebel,PeopleSoft, Custom
ExcelXML
BusinessProcess
OLAP
Fusion Middleware
Business Intelligence Foundation
BI ApplicationsPerformance ManagementApplications
![Page 9: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/9.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 9
Oracle BI Suite Enterprise EditionKey Elemente der Oracle BI Foundation
BUSINESS INTELLIGENCE FOUNDATION
Essbase BI Server Real Time DecisionsCommon Enterprise Information Model
EPM Workspace
OLTP & ODSSystems
Data WarehouseData Mart
SAP, Oracle, Siebel,PeopleSoft, Custom
BusinessProcess
OLAP
Fusion Middleware
BI ApplicationsPerformance ManagementApplications
EPM Workspace
ExcelXML
![Page 10: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/10.jpg)
Informationszugang - überallEine Plattform, ein Modell, multiple Delivery Channels
Data WarehouseData Mart
SAP, OraclePeopleSoft, Siebel,
Custom Apps
Files ExcelXML
BusinessProcessEssbase
Einheitliches unternehmensweites Metadatenmodell
Data Integration
Ad-hoc Analysis
Interactive Dashboards
Essbase Reporting &Publishing
ProactiveDetectionand Alerts
Disconnected& MobileAnalytics
MS Office& OutlookIntegration
OLTP & ODSSystems
BI ServerBI Server• Integrierte Sicherheit, Benutzermanagement, Personalisierung• Multidimensionale Kalkulationen und integrierende Engine• Intelligente Abfragegenerierung and optimierte Datenzugriffsdienste
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 10
![Page 11: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/11.jpg)
• Einführung
• Optionen für Discoverer Kunden
• Oracle Enterprise Performance Management
• Mehrwert der Oracle BI Suite Enterprise Edition
• Migrationsüberlegungen
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 11
Agenda
![Page 12: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/12.jpg)
Mehrwert von Oracle BI EE
• Intuitiver, simultaner Zugriff auf multiple, heterogene Datenquellen –
unternehmensweites Geschäftsmodell
• Hot Pluggable mit bereits getätigten Investitionen in DBs und Apps
Servern
• Dashboards bieten einfachere Handhabung, Interaktivität und bessere
Präsentations- und Visualisierungsmöglichkeiten
• Durchweg Thin-Client-Umgebung
• Alerting, Scheduling und Distribution
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 12
![Page 13: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/13.jpg)
Mehrwert von Oracle BI EE
• Generierung von pixelperfekten Berichten mit BI Publisher
• Disconnected Modus
• MS Office Integration
• Umfassende BI Applikationen
• Architektur gemacht für Performance und Skalierbarkeit
• Enge Integration mit Fusion Middleware
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 13
![Page 14: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/14.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 14
Einheitliches, unternehmensweites MetadatenmodellErmöglicht Konsistenz, Sicherheit, Wiederverwendbarkeit und Flexibilität
• Benutzerrollen, Preferenzen• Vereinfachte Sichten auf Daten• Logisches SQL Schnittstelle
Präsentationsschicht
• Dimensionen• Hierarchien• Kennzahlen• Kalkulationen• Verdichtungsregeln• Zeitreihen
Geschäftsmodell
Physikalische Schicht
• Physische Anbindung der Quellen• Verbindungen• Schema
Rollenbasierte Sichten auf, für Benutzer relevante Informationen
Konsistente Definition von Unternehmenskennzahlen, Maßen und Berechnungen
Einmal modellieren, überall nutzen
Auf jede Datenquelle
![Page 15: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/15.jpg)
Mehrwert Unternehmensgeschäftsmodell
BUSINESS MEHRWERT
Konsistente, akkurate Informationen
Endbenutzer Selbstversorgung
Auswahl an Endbenutzerwerkzeugen
Rollenbasierter, sicherer Zugang
Transparenter Informationszugang
TECHNISCHER MEHRWERT
Einmal modellieren, überall verwenden
Weniger Benutzerunterstützung, bei 100%iger Kontrolle
Erlaubt schrittweise BI-Standardisierung
Unterstützt IT Compliance Initiativen
Einfache Upgrades & Veränderungen ohne Berichte neu zu definieren
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 15
![Page 16: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/16.jpg)
• Einführung
• Optionen für Discoverer Kunden
• Oracle Enterprise Performance Management
• Mehrwert der Oracle BI Suite Enterprise Edition
• Migrationsüberlegungen
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 16
Agenda
![Page 17: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/17.jpg)
<Insert Picture Here>
Produkt Komponenten
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 17
![Page 18: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/18.jpg)
Oracle Discoverer – Oracle BI EEFunktionsgleiche Komponenten
• Discoverer Administrator <> BI EE Administration Tool
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 18
![Page 19: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/19.jpg)
Oracle Discoverer – Oracle BI EE Funktionsgleiche Komponenten
• Discoverer Plus/Viewer <> BI EE Answers
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 19
![Page 20: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/20.jpg)
Oracle Discoverer – Oracle BI EE Funktionsgleiche Komponenten
• Discoverer Portlet Provider <> BI EE Dashboards
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 20
![Page 21: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/21.jpg)
<Insert Picture Here>
Metadata Migration
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 21
![Page 22: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/22.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 22
Administrationswerkzeug
ORACLE BI SUITE ENTERPRISE EDITION
![Page 23: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/23.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 23
Connection Pool
Objekt Mapping
Primär- / Fremdschlüssel
PHYSIKALISCHE SCHICHT
![Page 24: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/24.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 24
Dimensionales Modell
Dimensionen
Fakten
Hierarchien
GESCHÄFTSMODELL
![Page 25: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/25.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 25
Endbenutzerschicht
WYSIWYG-Sicht auf die Answers-Analyse- / Berichtsgenerierung
PRÄSENTATIONSSCHICHT
![Page 26: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/26.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 26
![Page 27: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/27.jpg)
Migrationsansatz
• Verknüpft Objekte mit ähnlichem Metadatenkonzept ...
• Endbenutzerschicht• Geschäftsbereiche• Ordner und Elemente• Joins• Hierarchien
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 27
![Page 28: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/28.jpg)
Migration Approach
• Endbenutzerebene (EBE)• Discoverer Metadaten Repository• Schema in einer Datenbank
• BI Enterprise Edition RPD Datei• Metadaten Repository Datei
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 28
![Page 29: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/29.jpg)
Migrationsansatz
• Verknüpft Objekte mit ähnlichem Metadatenkonzept ...
• Endbenutzerschicht• Geschäftsbereiche• Ordner und Elemente• Joins• Hierarchien
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 29
![Page 30: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/30.jpg)
Migrationsansatz
• Geschäftsbereich → Präsentationsschicht
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 30
![Page 31: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/31.jpg)
• Geschäftsbereich → Themenbereiche
Migrationsansatz
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 31
![Page 32: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/32.jpg)
Migrationsansatz
• Verknüpft Objekte mit ähnlichem Metadatenkonzept ...
• Endbenutzerschicht• Geschäftsbereiche• Ordner und Elemente• Joins• Hierarchien
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 32
![Page 33: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/33.jpg)
Ordner
METADATA EIGENSCHAFTEN
![Page 34: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/34.jpg)
![Page 35: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/35.jpg)
Vom Discoverer
![Page 36: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/36.jpg)
Migrationsansatz
• Discoverer Ordnertypen• Komplexe Ordner können equivalent in der
Präsentationsschicht von BI EE Metadaten gebildet werden• Benutzerdefinierte SQL Ordner können in BI EE erzeugt
werden
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 36
![Page 37: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/37.jpg)
Migrationsansatz
• Verknüpft Objekte mit ähnlichem Metadatenkonzept ...
• Endbenutzerschicht• Geschäftsbereiche• Ordner und Elemente• Joins• Hierarchien
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 37
![Page 38: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/38.jpg)
Joins
METADATA EIGENSCHAFTEN
![Page 39: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/39.jpg)
From Discoverer
Joins in der
physikalischen Schicht
METADATA EIGENSCHAFTEN
![Page 40: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/40.jpg)
From Discoverer
Joins im
Geschäftsmodell
METADATA EIGENSCHAFTEN
![Page 41: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/41.jpg)
Migrationsansatz
• Verknüpft Objekte mit ähnlichem Metadatenkonzept ...
• Endbenutzerschicht• Geschäftsbereiche• Ordner und Elemente• Joins• Hierarchien
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 41
![Page 42: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/42.jpg)
Hierarchien
METADATA EIGENSCHAFTEN
![Page 43: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/43.jpg)
Migrationsanmerkungen
• BI EE Business Models werden als Starschema verknüpft• Logische Tabellen können sich auf mehrere physische
Quellen referenzieren
• PL/SQL / Oracle analytische Funktionen• Können an BI EE druch ‘Evaluate’ anknüpfen
• Kein Equivalent von Elementklassen in BI EE• Wertelisten werden zur Laufzeit generiert
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 43
![Page 44: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/44.jpg)
<Insert Picture Here>
Arbeitsblatt Migration
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 44
![Page 45: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/45.jpg)
Arbeitsblatt Migration
• Discoverer Arbeitsblatt → Answers Abfrage
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 45
![Page 46: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/46.jpg)
Arbeitsblatt Migration
• Kein direktes Equivalent von Arbeitsblättern in BI EE• In Dashboards können Abfragen zusammengefasst werden
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 46
![Page 47: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/47.jpg)
• Gleiche Möglichkeiten der Ausnahmeformatierung• Zusätzliche Möglichkeiten in BI EE z.B. Bildzeichen
• Extra Visualisierung in BI EE – z.B. Gauges
Arbeitsblatt Migration
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 47
![Page 48: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/48.jpg)
Arbeitsblatt Migration
• Gleiche Möglichkeit Bedingungen und Filter zu definieren / Berichte zu parametrisieren
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 48
![Page 49: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/49.jpg)
Sortierungen
Ampelformatierungen
Grafiken
ARBEITSBLATT EIGENSCHAFTEN
![Page 50: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/50.jpg)
Sortierungen
Ampelformatierung
Grafiken
ARBEITSBLATT EIGENSCHAFTEN
![Page 51: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/51.jpg)
<Insert Picture Here>
Migration Überlegungen
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 51
![Page 52: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/52.jpg)
Migration Überlegungen
• Was für einen Systemtyp möchten Sie migrieren?• Data Warehouse• Eigenentwicklung – 3NF• Oracle Applications Berichte (z.B. BIS)
• Welche Bereiche des Systems müssen migriert werden?• Metadaten• Arbeitsbereiche und Arbeitsblätter
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 52
![Page 53: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/53.jpg)
Data Warehouse
• Typischerweise Star- oder Snowflake-Schema• Optimiert für den Datenzugriff
• Gute Übereinstimmung mit OBI EE Metadaten
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 53
![Page 54: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/54.jpg)
Eigenentwicklung – 3NF
• Beinhaltet typischerweise mehrere Joins pro Tabelle
• Discoverer erlaubt Benutzern von multiplen Join-Pfaden während der Berichtserstellung auszuwählen – kein Equivalent in BI EE
• Notwendigkeit das bestehende Modell für die logische Schicht in ein Starschema zu modellieren
• Ein Beispiel für multiple Join-Pfade …
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 54
![Page 55: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/55.jpg)
Eigenentwicklung – 3NF
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 55
Auslieferungen über die Zeit
Inventar pro Auslieferung
Inventar pro Auslieferung
über die Zeit
ABRAGE OPTIONEN
![Page 56: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/56.jpg)
Eigenentwicklung – 3NF
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 56
Definiert jeden Join-Pfad
DISCOVERER METADTEN
![Page 57: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/57.jpg)
<Insert Picture Here>
Auslieferung über die Zeit
Inventar pro Auslieferung
Inventar pro Auslieferung
über die Zeit
ABFRAGE OPTIONEN
![Page 58: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/58.jpg)
<Insert Picture Here>
Auslieferung über die Zeit
Inventar pro Auslieferung
Inventar pro Auslieferung
über die Zeit
ABFRAGE OPTIONEN
![Page 59: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/59.jpg)
<Insert Picture Here>
![Page 60: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/60.jpg)
<Insert Picture Here>
Auslieferung über die Zeit
Inventar pro Auslieferung
Inventar pro Auslieferung
über die Zeit
ABFRAGE OPTIONEN
![Page 61: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/61.jpg)
Eigenentwicklung – 3NF
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 61
Auslieferung über die Zeit
Inventar pro Auslieferung
Inventar pro Auslieferung
über die Zeit
ABFRAGE OPTIONEN
![Page 62: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/62.jpg)
Eigenentwicklung – 3NF
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 62
Physikalische Schicht
ORACLE BI EE METADATEN
![Page 63: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/63.jpg)
Eigenentwicklung – 3NF
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 63
Fortsetzung der logischen Schicht
Empfindet das Geschäft nach
ORACLE BI EE METADATEN
![Page 64: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/64.jpg)
Eigenentwicklung – 3NF
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 64
Geschäftsmodell
ORACLE BI EE METADATEN
![Page 65: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/65.jpg)
<Insert Picture Here>
![Page 66: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/66.jpg)
<Insert Picture Here>
![Page 67: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/67.jpg)
<Insert Picture Here>
![Page 68: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/68.jpg)
<Insert Picture Here>
![Page 69: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/69.jpg)
<Insert Picture Here>
![Page 70: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/70.jpg)
Berichte auf Oracle Applikationen (BIS)
• Oracle BI Applikationen• Erlauben zusätzliche Einblicke in CRM and ERP Applikationen• Einfach anzupassen und auszubauen• Fügt sich in bestehende IT-Landschaften ein • Schneller ROI• Enge Integration mit OLTP Systemen• Niedriege TCO• Über 1.000 Kunden
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 70
![Page 71: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/71.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 71
Umfassende BI Applikationen
Sales Service MarketingOrderMgmt.
BI APPLIKATIONEN
SupplyChain
HR Finance
EPM Workspace
OLTP & ODSSystems
Data WarehouseData Mart
SAP, Oracle, Siebel,PeopleSoft, Custom
BusinessProcess
OLAP
Fusion Middleware
Business Intelligence Foundation
Performance ManagementApplications
EPM Workspace
ExcelXML
![Page 72: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/72.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 72
•Dashboards
•Vordefiniertes ETL über multiple Quellen und Applikationen•Vorverknüpfte Metadaten•Vordefinierte Kennzahlen•Vordefiniertes Metadatenmodell für Fachbereiche
Der Wert liegt unter OberflächeOracle BI Applikationen
![Page 73: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/73.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 73
Umfassender InhaltOracle BI Applikationen
In Zahlen:
Applikationen 8
Dashboards 35
Berichte 973
Kennzahlen 3,021
• Neu: Beschaffung und Ausgaben analytische Applikation
• Erweiteter Support für:• PeopleSoft 8.9/9.0 HR und
Financials• Oracle EBS R12• PeopleSoft Financials 8.4, 8.8,
8.9, 9.0• PeopleSoft HR 8.9, 9.0• Siebel 8.0, 8.1
Sofortiger Mehrwert. Niedrige TCO. Integrierte Best Practices.
![Page 74: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/74.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 74
Unangefochtene Integration mit Oracle Apps
Erweitert den Mehrwert für BI. Senkt die TCO.
Betrachtet die Performance in Zusammenhang mit dem Budget und der Planung.
INTEGRIERT MIT PLANNING UND EPM
Nahtlose Navigation von analytischen Informationen zu Transaktionsdaten.
AKTIONSVERKNÜPFUNGEN – “INSIGHT TO ACTION”
Ein Login. Zutreffender Inhalt für jeden Nutzer.
INTEGRIERTE SICHERHEIT
Data Security
UserSecurity
ObjectSecurity
BPEL, ESB Oracle BI
Intelligenz-getriebende Geschäftsprozesse.
INTEGRIERTER WORKFLOT
![Page 75: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/75.jpg)
<Insert Picture Here>
Migration Werkzeug
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 75
![Page 76: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/76.jpg)
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 77
Metadaten Konversionsassistent
• Ausgeliefert mit Oracle BI EE 10.1.3.4
• Dokumentation, Methodologie und Best Practice
• Beta getestet durch viele Partner und Kunden
• Fein abgestimmte Algorithmen und Multi-Byte-Support
• Generiert Oracle BI EE .rpd file
• Zusätzlich gibt es einumfassendes Oracle Consulting Angebot
![Page 77: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/77.jpg)
Metadaten Konversionsassistent
• Identifikation von Kennzahlen und Dimensionen• Measures identified by placement (DATAPOINT) und
Standardaggregationeigenschaften (SUM, AVG, MAX, MIN, COUNT)
• Snowflake-Datenmodell im Discoverer• Zusammengestellt in ein Starschema
• Auf sich beziehende oder multiple Join-Pfade in Discoverer• Alias-Ordner, eine Alternative multiple Join-Pfade zu erlauben
• Werkzeug generiert Ordnerlisten, die multiple Join-Pfade haben
• Benutzer können dann optional auswählen, welchen Alias-Ordner sie für eine Abfrage nutzen wollen.
![Page 78: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/78.jpg)
<Insert Picture Here>
Ausblick
"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"
![Page 79: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/79.jpg)
Arbeitsbuch Konversionsassistent
• Derzeit in der Entwicklung
• Generiert Oracle BI EE .rpd file und webcat files
• Migriert Arbeitsbücher & Charts
"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"
![Page 80: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/80.jpg)
Zusammenfassung
• Vorteile von Oracle BI Enterprise Edition• Zugriff auf multiple, unterschiedliche Datenquellen• Hot Pluggable• Interaktive Dashboards• Reine Thin-Client Oberflächen• Alerting, Scheduling und Distribution• Hoch skallierbare Architektur
• Ähnliches Metadatenkonzept: 1 in 3 funktioniert!
• Consider type of system to be migrated ?
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 81
![Page 81: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/81.jpg)
Weitere Informationen
http://www.oracle.com/technology/products/bi/discoverer-migration/index.html
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 82
![Page 82: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/82.jpg)
Weitere Informationenhttp://blogs.oracle.com/mikedurran/
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 83
![Page 83: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/83.jpg)
The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. 84
![Page 84: Protecting and Extending Your Discoverer Investment ROADSHOW](https://reader036.vdocuments.us/reader036/viewer/2022062622/55204d6249795902118b6a59/html5/thumbnails/84.jpg)