Oracle Business Intelligence 11g R1 Cookbook -- Table of Contents -- Oracle Business Intelligence 11g R1 Cookbook -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 1. Exploring and Building the Repository -- Introduction -- Presentation Services -- Oracle BI Server -- BI Scheduler -- Building the Physical layer in the repository -- How to do it... -- How it works... -- There's more... -- Building the Business Model and Mapping layer -- How to do it... -- How it works... -- There's more... -- Adding multiple sources to the logical table source -- How to do it... -- How it works... -- There's more... -- Adding calculations to the fact table -- How to do it... -- How it works... -- There's more... -- Creating variables -- How to do it... -- How it works... -- There's more... -- Building the Presentation layer -- How to do it... -- How it works... -- There's more... -- Validating the repository using Consistency Check Manager -- How to do it... -- How it works... -- Uploading the repository -- Getting ready -- How to do it... -- How it works... -- There's more... -- 2. Working with Logical Dimensions -- Introduction -- Creating level-based hierarchies -- How to do it... -- How it works... -- There's more... -- Creating parent-child hierarchies -- How to do it... -- How it works... -- There's more... -- Creating level-based measures -- How to do it... -- How it works... -- There's more... -- Creating shared measures -- How to do it... -- How it works... -- Creating presentation hierarchies.

How to do it... -- How it works... -- There's more... -- 3. Using Aggregates and the Time Series Functions -- Introduction -- Creating aggregate tables -- How to do it... -- How it works... -- There's more... -- Implementing aggregate tables -- How to do it... -- How it works... -- There's more... -- Using the Aggregate Persistence Wizard -- How to do it... -- How it works... -- There's more... -- Creating calculations by using the time series functions -- How to do it... -- How it works... -- There's more... -- 4. Working with Multidimensional Data Sources -- Introduction -- Importing the multidimensional data source -- How to do it... -- How it works... -- Accessing members and member counts -- How to do it... -- How it works... -- Creating the multidimensional Business Model -- How to do it... -- How it works... -- There's more... -- Implementing Horizontal Federation -- How to do it... -- How it works... -- There's more... -- Implementing Vertical Federation -- How to do it... -- How it works... -- There's more... -- 5. Security in Oracle BI -- Introduction -- Configuring security settings -- How to do it... -- How it works... -- There's more... -- Creating users -- How to do it... -- How it works... -- There's more... -- Creating groups -- How to do it... -- How it works... -- There's more... -- Creating application roles -- How to do it... -- How it works... -- There's more... -- Setting up permissions on repository objects -- Getting ready -- How to do it... -- How it works... -- There's more... -- Configuring query limits -- How to do it... -- How it works... -- There's more... -- Specifying the time restrictions -- Introduction -- How to do it... -- How it works... -- Creating data filters -- How to do it... -- How it works... -- 6. Managing Usage Tracking and Enabling the Cache -- Introduction -- Enabling Usage Tracking -- How to do it...

How it works... -- There's more... -- Creating the Business Model for Usage Tracking -- How to do it... -- How it works... -- Creating dashboards for Usage Statistics -- How to do it... -- How it works... -- There's more... -- Enabling the cache -- How to do it... -- How it works... -- There's more... -- Gathering cache statistics -- How to do it... -- How it works... -- Managing the cache -- How to do it... -- How it works... -- 7. Creating Simple Oracle Business Intelligence Analyses -- Introduction -- Constructing the analysis -- How to do it... -- How it works... -- There's more... -- Exploring the table view properties -- How to do it... -- How it works... -- Formatting the table view -- How to do it... -- How it works... -- There's more... -- Filter types and creating the filters -- How to do it... -- How it works... -- There's more... -- Using the selections -- How to do it... -- How it works... -- There's more... -- Adding column prompts -- How to do it... -- How it works... -- 8. Adding Views to Analyses and Advanced Features -- Introduction -- Adding the pivot table view -- How to do it... -- How it works... -- Adding the graph view -- How to do it... -- How it works... -- Adding the gauge view -- How to do it... -- How it works... -- Adding the legend view -- How to do it... -- How it works... -- Adding the column selector view -- How to do it... -- How it works... -- Adding the view selector view -- How to do it... -- How it works... -- Configuring the master-detail view settings -- How to do it... -- How it works... -- 9. Measuring Performance with Key Performance Indicators -- Introduction -- Creating the KPIs and the KPI watchlists -- How to do it... -- How it works... -- There's more... -- Creating the scorecards -- How to do it... -- How it works... -- Creating the objectives -- How to do it... -- How it works...

Creating the initiatives -- How to do it... -- How it works... -- There's more... -- Adding the perspectives -- How to do it... -- How it works... -- Building the strategy trees and maps -- How to do it... -- How it works... -- 10. Creating and Configuring Dashboards -- Introduction -- Creating the dashboards -- How to do it... -- How it works... -- There's more... -- Using the Dashboard Builder -- How to do it... -- How it works... -- Exploring the properties of dashboard objects -- How to do it... -- How it works... -- Adding catalog objects to the dashboards -- How to do it... -- How it works... -- There's more... -- Creating the dashboard prompts -- How to do it... -- How it works... -- There's more... -- 11. Oracle BI Best Practices -- Introduction -- Best practices of the Physical layer -- How to do it... -- How it works... -- Best practices of the Business Model and Mapping layer -- How to do it... -- How it works... -- There's more... -- Best practices of the Presentation layer -- How to do it... -- How it works... -- There's more... -- Best practices of the analyses and the dashboards -- How to do it... -- How it works... -- There's more... -- Performance and security tips -- How to do it... -- How it works... -- A. The Major Components of OBIEE 11g -- Introduction -- The major components of OBIEE 11g -- Major components -- Sample processing of an analysis -- Processing steps -- There's more... -- Index.