Oracle Business Intelligence 11g R1 Cookbook


Oracle Business Intelligence 11g R1 Cookbook
eBook: $32.99
Formats: PDF, PacktLib, ePub and Mobi formats
$28.04
save 15%!
Print + free eBook + free PacktLib access to the book: $87.98    Print cover: $54.99
$54.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 364 pages [ 235mm x 191mm ]
Release Date : June 2013
ISBN : 1849686009
ISBN 13 : 9781849686006
Author(s) : Cuneyt Yilmaz
Topics and Technologies : All Books, Big Data and Business Intelligence, Cookbooks, Enterprise, Oracle

Table of Contents

Preface
Chapter 1: Exploring and Building the Repository
Chapter 2: Working with Logical Dimensions
Chapter 3: Using Aggregates and the Time Series Functions
Chapter 4: Working with Multidimensional Data Sources
Chapter 5: Security in Oracle BI
Chapter 6: Managing Usage Tracking and Enabling the Cache
Chapter 7: Creating Simple Oracle Business Intelligence Analyses
Chapter 8: Adding Views to Analyses and Advanced Features
Chapter 9: Measuring Performance with Key Performance Indicators
Chapter 10: Creating and Configuring Dashboards
Chapter 11: Oracle BI Best Practices
Appendix: The Major Components of OBIEE 11g
Index
  • 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 hierarchies
      • Creating level-based measures
      • Creating shared measures
      • Creating presentation hierarchies
          • Chapter 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 11: Oracle BI Best Practices
                        • Introduction
                        • Best practices of the Physical layer
                        • Best practices of the Business Model and Mapping layer
                        • Best practices of the Presentation layer
                        • Best practices of the analyses and the dashboards
                        • Performance and security tips

                          Cuneyt Yilmaz

                          Cuneyt Yilmaz has been working for Bilginc IT Academy since 2001 as a Senior Consultant and Instructor in Turkey and he's passionate about Oracle technologies. He's delivering training for Oracle and Siebel technologies in around 25 countries in the EMEA region. He mostly specializes in Business Intelligence projects. He is also a regular speaker in Oracle User Group events in Europe; he delivers presentations about Business Intelligence.
                          Sorry, we don't have any reviews for this title yet.

                          Submit Errata

                          Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                          Sample chapters

                          You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                          Frequently bought together

                          Oracle Business Intelligence 11g R1 Cookbook +    SQL Server 2012 with PowerShell V3 Cookbook =
                          50% Off
                          the second eBook
                          Price for both: $47.10

                          Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                          What you will learn from this book

                          • Understand the architecture of the Oracle BI Server
                          • Explore the three layers of the repository and learn how to implement complex business rules
                          • Build a secure, well-designed repository for the BI Server
                          • Work with multidimensional sources to improve the performance of the analyses
                          • Create the simple analyses and use advanced features of the analyses
                          • Measure the productivity by implementing Key Performance Indicators
                          • Customize dashboards to support your business requirements
                          • Build a BI solution based on the best practices

                          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.

                          Approach

                          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

                          Who this book is for

                          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.

                          Code Download and Errata
                          Packt Anytime, Anywhere
                          Register Books
                          Print Upgrades
                          eBook Downloads
                          Video Support
                          Contact Us
                          Awards Voting Nominations Previous Winners
                          Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                          Resources
                          Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software