You are previewing Oracle Business Intelligence 11g R1 Cookbook.
O'Reilly logo
Oracle Business Intelligence 11g R1 Cookbook

Book Description

Here’s an opportunity to learn all the key elements of the OBIEE 11g suite by doing tasks rather than just reading. Packed with practical recipes, it empowers you to create complex analytical reports with minimum effort.

  • Improve the productivity of business intelligence solution to satisfy business requirements with real-life scenarios

  • Practical guide on the implementation of OBIEE 11g from A to Z including best practices

  • Full of useful instructions that can be easily adapted to build better business intelligence solutions

  • In Detail

    Extracting meaningful and valuable business information from transactional databases is crucial for any organization. OBIEE 11g is a reporting tool that satisfies all the business requirements regarding complex reporting. It consists of a powerful back-end engine with a repository and a highly customizable graphical web interface.

    Oracle Business Intelligence 11g R1 Cookbook provides all the key concepts of the product including the architecture of the BI Server. This practical guide shows each and every step of creating analytical reports starting from building a well-designed repository. You will learn how to create analytical reports that will support different business perspectives.

    This practical guide covers how to implement OBIEE 11g suite in order to enable BI developers to create sophisticated web based reports. All of tasks will be covered step by step in detail.

    You will explore the architecture of the Oracle Business Intelligence Server and learn how to build the repository (RPD). We will also discuss how to implement the business rules in the repository with real-life scenarios.

    Best practices of a successful BI implementation are esssential for any BI developer so they are also covered in depth.If you are planning to implement OBIEE 11g suite, this step-by-step guide is a must have resource.All the key tasks are defined in detail and supported with diagrams and screenshots.

    Table of Contents

    1. Oracle Business Intelligence 11g R1 Cookbook
      1. Table of Contents
      2. Oracle Business Intelligence 11g R1 Cookbook
      3. Credits
      4. About the Author
      5. About the Reviewers
      6. www.PacktPub.com
        1. Support files, eBooks, discount offers and more
          1. Why Subscribe?
          2. Free Access for Packt account holders
          3. Instant Updates on New Packt Books
      7. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Errata
          2. Piracy
          3. Questions
      8. 1. Exploring and Building the Repository
        1. Introduction
          1. Presentation Services
          2. Oracle BI Server
          3. BI Scheduler
        2. Building the Physical layer in the repository
          1. How to do it...
          2. How it works...
          3. There's more...
        3. Building the Business Model and Mapping layer
          1. How to do it...
          2. How it works...
          3. There's more...
        4. Adding multiple sources to the logical table source
          1. How to do it...
          2. How it works...
          3. There's more...
        5. Adding calculations to the fact table
          1. How to do it...
          2. How it works...
          3. There's more...
        6. Creating variables
          1. How to do it...
          2. How it works...
          3. There's more...
        7. Building the Presentation layer
          1. How to do it...
          2. How it works...
          3. There's more...
        8. Validating the repository using Consistency Check Manager
          1. How to do it...
          2. How it works...
        9. Uploading the repository
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
      9. 2. Working with Logical Dimensions
        1. Introduction
        2. Creating level-based hierarchies
          1. How to do it...
          2. How it works...
          3. There's more...
        3. Creating parent-child hierarchies
          1. How to do it...
          2. How it works...
          3. There's more...
        4. Creating level-based measures
          1. How to do it...
          2. How it works...
          3. There's more...
        5. Creating shared measures
          1. How to do it...
          2. How it works...
        6. Creating presentation hierarchies
          1. How to do it...
          2. How it works...
          3. There's more...
      10. 3. Using Aggregates and the Time Series Functions
        1. Introduction
        2. Creating aggregate tables
          1. How to do it...
          2. How it works...
          3. There's more...
        3. Implementing aggregate tables
          1. How to do it...
          2. How it works...
          3. There's more...
        4. Using the Aggregate Persistence Wizard
          1. How to do it...
          2. How it works...
          3. There's more...
        5. Creating calculations by using the time series functions
          1. How to do it...
          2. How it works...
          3. There's more...
      11. 4. Working with Multidimensional Data Sources
        1. Introduction
        2. Importing the multidimensional data source
          1. How to do it...
          2. How it works...
        3. Accessing members and member counts
          1. How to do it...
          2. How it works...
        4. Creating the multidimensional Business Model
          1. How to do it...
          2. How it works...
          3. There's more...
        5. Implementing Horizontal Federation
          1. How to do it...
          2. How it works...
          3. There's more...
        6. Implementing Vertical Federation
          1. How to do it...
          2. How it works...
          3. There's more...
      12. 5. Security in Oracle BI
        1. Introduction
        2. Configuring security settings
          1. How to do it...
          2. How it works...
          3. There's more...
        3. Creating users
          1. How to do it...
          2. How it works...
          3. There's more...
        4. Creating groups
          1. How to do it...
          2. How it works...
          3. There's more...
        5. Creating application roles
          1. How to do it...
          2. How it works...
          3. There's more...
        6. Setting up permissions on repository objects
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        7. Configuring query limits
          1. How to do it...
          2. How it works...
          3. There's more...
        8. Specifying the time restrictions
          1. Introduction
          2. How to do it...
          3. How it works...
        9. Creating data filters
          1. How to do it...
          2. How it works...
      13. 6. Managing Usage Tracking and Enabling the Cache
        1. Introduction
        2. Enabling Usage Tracking
          1. How to do it...
          2. How it works...
          3. There's more...
        3. Creating the Business Model for Usage Tracking
          1. How to do it...
          2. How it works...
        4. Creating dashboards for Usage Statistics
          1. How to do it...
          2. How it works...
          3. There's more...
        5. Enabling the cache
          1. How to do it...
          2. How it works...
          3. There's more...
        6. Gathering cache statistics
          1. How to do it...
          2. How it works...
        7. Managing the cache
          1. How to do it...
          2. How it works...
      14. 7. Creating Simple Oracle Business Intelligence Analyses
        1. Introduction
        2. Constructing the analysis
          1. How to do it...
          2. How it works...
          3. There's more...
        3. Exploring the table view properties
          1. How to do it...
          2. How it works...
        4. Formatting the table view
          1. How to do it...
          2. How it works...
          3. There's more...
        5. Filter types and creating the filters
          1. How to do it...
          2. How it works...
          3. There's more...
        6. Using the selections
          1. How to do it...
          2. How it works...
          3. There's more...
        7. Adding column prompts
          1. How to do it...
          2. How it works...
      15. 8. Adding Views to Analyses and Advanced Features
        1. Introduction
        2. Adding the pivot table view
          1. How to do it...
          2. How it works...
        3. Adding the graph view
          1. How to do it...
          2. How it works...
        4. Adding the gauge view
          1. How to do it...
          2. How it works...
        5. Adding the legend view
          1. How to do it...
          2. How it works...
        6. Adding the column selector view
          1. How to do it...
          2. How it works...
        7. Adding the view selector view
          1. How to do it...
          2. How it works...
        8. Configuring the master-detail view settings
          1. How to do it...
          2. How it works...
      16. 9. Measuring Performance with Key Performance Indicators
        1. Introduction
        2. Creating the KPIs and the KPI watchlists
          1. How to do it...
          2. How it works...
          3. There's more...
        3. Creating the scorecards
          1. How to do it...
          2. How it works...
        4. Creating the objectives
          1. How to do it...
          2. How it works...
        5. Creating the initiatives
          1. How to do it...
          2. How it works...
          3. There's more...
        6. Adding the perspectives
          1. How to do it...
          2. How it works...
        7. Building the strategy trees and maps
          1. How to do it...
          2. How it works...
      17. 10. Creating and Configuring Dashboards
        1. Introduction
        2. Creating the dashboards
          1. How to do it...
          2. How it works...
          3. There's more...
        3. Using the Dashboard Builder
          1. How to do it...
          2. How it works...
        4. Exploring the properties of dashboard objects
          1. How to do it...
          2. How it works...
        5. Adding catalog objects to the dashboards
          1. How to do it...
          2. How it works...
          3. There's more...
        6. Creating the dashboard prompts
          1. How to do it...
          2. How it works...
          3. There's more...
      18. 11. Oracle BI Best Practices
        1. Introduction
        2. Best practices of the Physical layer
          1. How to do it...
          2. How it works...
        3. Best practices of the Business Model and Mapping layer
          1. How to do it...
          2. How it works...
          3. There's more...
        4. Best practices of the Presentation layer
          1. How to do it...
          2. How it works...
          3. There's more...
        5. Best practices of the analyses and the dashboards
          1. How to do it...
          2. How it works...
          3. There's more...
        6. Performance and security tips
          1. How to do it...
          2. How it works...
      19. A. The Major Components of OBIEE 11g
        1. Introduction
        2. The major components of OBIEE 11g
          1. Major components
        3. Sample processing of an analysis
          1. Processing steps
          2. There’s more...
      20. Index