Oracle Business Intelligence 11g R1 Cookbook : Make Complex Analytical Reports Simple and Deliver Valuable Business Data Using OBIEE 11g with This Comprehensive and Practical Guide / Cuneyt Yilmaz.

Providing simple solutions, useful techniques and best practices to ensure that your business is intelligent as it can possibly be, this book is a must buy for anyone that works with Oracle BI. If you are a business analyst, BI administrator or developer working with Oracle Business Intelligence 11g R1 then this book is exactly what you have been looking for. Hands on practical examples, real world solutions and best practices make this book an essential guide for Oracle BI. Clear a space on your desk as you won't want this handy reference to be too far away.

Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Exploring and Building the Repository; Introduction; Building the Physical layer in the repository; Building the Business Model and Mapping layer; Adding multiple sources to the logical table source; Adding calculations to the fact table; Creating variables; Building the Presentation layer; Validating the repository using Consistency Check Manager; Uploading the repository; Chapter 2:Working with Logical Dimensions; Introduction; Creating level-based hierarchies.

Creating parent-child hierarchiesCreating level-based measures; Creating shared measures; Creating presentation hierarchies; Chapter 3:Using Aggregates and the Time Series Functions; Introduction; Creating aggregate tables; Implementing aggregate tables; Using the Aggregate Persistence Wizard; Creating calculations by using the time series functions; Chapter 4:Working with Multidimensional Data Sources; Introduction; Importing the multidimensional data source; Accessing members and member counts; Creating the multidimensional Business Model; Implementing Horizontal Federation.

Implementing Vertical FederationChapter 5:Security in Oracle BI; Introduction; Configuring security settings; Creating users; Creating groups; Creating application roles; Setting up permissions on repository objects; Configuring query limits; Specifying the time restrictions; Creating data filters; Chapter 6:Managing Usage Tracking and Enabling the Cache; Introduction; Enabling Usage Tracking; Creating the Business Model for Usage Tracking; Creating dashboards for Usage Statistics; Enabling the cache; Gathering cache statistics; Managing the cache.

Chapter 7:Creating Simple Oracle Business Intelligence AnalysesIntroduction; Constructing the analysis; Exploring the table view properties; Formatting the table view; Filter types and creating the filters; Using the selections; Adding column prompts; Chapter 8:Adding Views to Analyses and Advanced Features; Introduction; Adding the pivot table view; Adding the graph view; Adding the gauge view; Adding the legend view; Adding the column selector view; Adding the view selector view; Configuring the master-detail view settings; Chapter 9:Measuring Performance with Key Performance Indicators.

IntroductionCreating the KPIs and the KPI watchlists; Creating the scorecards; Creating the objectives; Creating the initiatives; Adding the perspectives; Building the strategy trees and maps; Chapter 10:Creating and Configuring Dashboards; Introduction; Creating the dashboards; Using the Dashboard Builder; Exploring the properties of dashboard objects; Adding catalog objects to the dashboards; Using the dashboard prompts; Chapter 11:Oracle BI Best Practices; Introduction; Best practices of the Physical layer; Best practices of the Business Model and Mapping layer.

Print version record.

eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - Worldwide