Oracle Business Intelligence Enterprise Edition

1. Oracle Business Intelligence Enterprise Edition 

3. DWH Concepts

4. What is a Data Warehouse ? A data warehouse is a subject-oriented, integrated, nonvolatile, time-variant collection of data in support of management's decisions. - WH Inmon

5. Subject-Oriented- Characteristics of a Data Warehouse Information is presented according to specific subjects or areas of interest, not simply as computer files. Data is manipulated to provide information about a particular subject. Information is presented according to specific subjects or areas of interest, not simply as computer files. Data is manipulated to provide information about a particular subject.

6. Integrated - Characteristics of a Data Warehouse A single source of information for and about understanding multiple areas of interest. The data warehouse provides one-stop shopping and contains information about a variety of subjects. A single source of information for and about understanding multiple areas of interest. The data warehouse provides one-stop shopping and contains information about a variety of subjects.

7. Non-volatile - Characteristics of a Data Warehouse Stable information that doesn�t change each time an operational process is executed. Information is consistent regardless of when the warehouse is accessed. Stable information that doesn�t change each time an operational process is executed. Information is consistent regardless of when the warehouse is accessed.

8. Time Variant - Characteristics of a Data Warehouse Containing a history of the subject, as well as current information. Historical information is an important component of a data warehouse. Containing a history of the subject, as well as current information. Historical information is an important component of a data warehouse.

10. Warehouse Architecture

15. OBIEE Architecture

16. Oracle Business Intelligence Enterprise Edition Architecture

20. Oracle BI Delivers

27. Security in Oracle BI

28. Security in Oracle BI Oracle BI supports security mechanisms that allow users to access only the data for which they are authorized. Business logic object security: This security mechanism controls access to objects, such as subject areas, tables, and columns. For example, report designers in a particular department can view only the subject areas that belong to their department when using Oracle BI Answers. Presentation Catalog object security: This security mechanism provides security for objects stored in the Oracle BI Presentation Catalog, such as dashboards, dashboard pages, folders, and reports. Users can view only the objects for which they are authorized. For example, a mid-level manager may not be granted access to a dashboard containing summary information for an entire department.

29. Security in Oracle BI Data level security: This security mechanism controls the type and amount of data that is available in a report. When multiple users run the same report, the results that are returned to each user depend on their access rights and roles in the organization. For example, a sales vice president sees results for all regions, while a sales representative for a particular region sees only data for that region.

30. Some Good Features of OBIEE

31. Some Good Features of OBIEE Write back - update or write to the back-end database using the write-back capability. For example, Business users can enter the sales targets for the current quarter in a Sales dashboard. Reports created from any Microsoft application(word document, excel or paint) can be imported to OBIEE using BI Publisher. Developers can customize the reports. Level of customization is 100%

32. Some Good Features of OBIEE Oracle BI Disconnected Analytics allows you to view analytics data, Oracle BI Interactive Dashboards, and queries when you cannot connect to the network to access the Oracle Business Intelligence application. Typically, disconnected users connect their personal machines (usually laptops) to a server that runs Oracle Business Intelligence. After downloading an Oracle BI Disconnected Analytics application, they can disconnect their laptops from the network . For example, to travel on a business trip and still view dashboards and queries on their laptop machines

33. Some Good Features of OBIEE Time Series feature - in the form of AGO and TODATE. AGO gives you, for example, the value of sales one month ago or one quarter ago, whilst TODATE gives you the total of sales month-to-date, or quarter-to-date, or year-to-date. Various report views like compound Layout, Narrative etc.

34. Some Good Features of OBIEE Drilling down from different data sources seamlessly. For example I am loading data from SQL Server and Oracle 10g and my report when drilling down to the lower level will use SQL Server data source to a certain point and then use Oracle 10g data source.

35. Oracle Business Intelligence Application Oracle BI applications include Extract Transform Load (ETL) routines to extract, transform, and load data into the Oracle Business Analytics Warehouse. An Oracle BI application consists of prebuilt, industry-specific Oracle BI interactive dashboards and Oracle BI reports that are built using industry best practices and address key functional areas within an organization.

36. References: http://download.oracle.com/docs/cd/B40078_02/doc/index.htm

37. Thank You