Oracle Business Intelligence Enterprise Edition 12c - Second Edition

A comprehensive guide from Oracle experts, that will act as your single point of reference for building an Oracle BI 12c system that turns data in actionable insight.

Oracle Business Intelligence Enterprise Edition 12c - Second Edition

Adrian Ward, Christian Screen, Haroun Khan

A comprehensive guide from Oracle experts, that will act as your single point of reference for building an Oracle BI 12c system that turns data in actionable insight.
Mapt Subscription
FREE
$29.99/m after trial
eBook
$36.40
RRP $51.99
Print + eBook
$64.99
RRP $64.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$36.40
$64.99
$29.99p/m after trial
RRP $51.99
RRP $64.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Book Details

ISBN 139781786464712
Paperback578 pages

Book Description

Oracle Business Intelligence Enterprise Edition (OBIEE) 12c is packed full of features and has a fresh approach to information presentation, system management, and security. OBIEE can help any organization to understand its data, to make useful information from data, and to ensure decision-making is supported by facts. OBIEE can focus on information that needs action, alerting users when conditions are met. OBIEE can be used for data analysis, form production, dashoarding, and workflow processes.

We will introduce you to OBIEE features and provide a step-by-step guide to build a complete system from scratch. With this guide, you will be equipped with a good basic understanding of what the product contains, how to install and configure it, and how to create effective Business Intelligence.

This book contains the necessary information for a beginner to create a high-performance OBIEE 12c system.

This book is also a guide that explains how to use an existing OBIEE 12c system, and shows end users how to create

Table of Contents

Chapter 1: Oracle BI 12c Architecture
Let's look at the big picture
Terminology differences from Oracle BI 11g
What is Oracle Fusion Middleware?
Why is there a database repository for OBIEE?
Overall components
WebLogic Server
System tools controlled by WebLogic
Security
System requirements
Scaling out Oracle BI 12c
Enterprise Deployment Guide
Directory folder structure
Download Oracle BI 12c
System requirements
References
A review - what I should now know!
Summary
Chapter 2: Installing the Prerequisite Software
Installation overview
Installation media
System requirements
Installing Java
Installing the WebLogic Server
Installing the metadata schemas
Gotchas
A review - what I should now know!
Summary
Chapter 3: Installing on Windows Server 2012
Installation overview
Installation media
Configuring start and stop links
A review - what I should now know!
Summary
Chapter 4: Reviewing the Features of the Reporting Repository
Integrated tools
The home screen
Catalog
New
Administration
A review - what I should now know!
Summary
Chapter 5: Installing and Configuring Client Tools
Installing the client software
Configuring a connection to the OBIEE Server
Configuring a connection to the database
Creating shortcuts
Testing the client software
A review - what I should now know!
Summary
Chapter 6: Understanding the Systems Management Tools
Let's talk management tools
WebLogic Server Administration Control
Servers
Clusters
Machines / IP address or DNS
Data Sources / JDBC connections
Security Realms
WebLogic Server is its own application
Using WLST
Enterprise Manager Fusion Middleware Control
Oracle BI 12c Lifecycle Management
Creating users, roles, and associations
Creating users and groups in WebLogic Server
Assigning users to groups
Creating and assigning Application Roles
JMX, MBeans, Java, and interfacing Oracle BI
Migrating FMW Security to other environments
FMW Security Import/Export utility
Using the Security Realm migration utility
Oracle BI Publisher system management
Monitoring system performance
Have a backup plan!
Recommendations for further learning
A review - what I should know now!
Summary
Chapter 7: Developing the BI Server Repository
Prerequisites
Repository architecture
Physical layer
Business layer
Presentation layer
Federated and fragmented content
Variables and initialization blocks
A review - what I should now know!
Summary
Chapter 8: Creating Dashboards and Analyses
Creating our first analysis
Creating our first Dashboard
Analysis building - more details
Pretty useful stuff!
A review - what I should now know!
Summary
Chapter 9: Agents and Action Framework
Agents
Actions
A review - what I should know now!
Additional research suggestions
Oracle documentation on Actions
Summary
Chapter 10: Developing Reports Using BI Publisher
Don't miss the installation integration checkpoint!
What's all this XML talk?
Where to administer BI Publisher
Where to build a data model
Let's get publishing
Enabling Audit Policy in the Fusion Middleware Control Enterprise Manager
Connecting to Oracle BI server data sources
A review - what I should now know!
Summary
Chapter 11: Usage Tracking
What is usage tracking?
Analyzing usage
Customizing your setup
Additional data
A review - what I should now know!
Summary
Chapter 12: Improving Performance
What is poor performance?
A review - what I should now know!
Summary
Chapter 13: Using the BI Admin Change Management Utilities
Problems with multiple developers
Merges
Multiuser Development Environment
A review - what I should now know!
Additional research suggestions
Summary
Chapter 14: Ancillary Installation Options
Oracle BI 12c on its own server
Custom ports and port management
Installing Oracle BI 12c on *Nix
Listening on port 80
Configuring a HTTP proxy with the NGINX web server
Enabling compression on web servers
Automating starting and stopping
Recommendations for further learning
A review - what should I know now?
Summary
Chapter 15: Reporting Databases
Theories and models
Designing your database - objectives, rules, and goals
Creating a warehouse
Some definitions
A review - what you should know now!
Summary
Chapter 16: Customizing the Style of Dashboards
Multiple skins and styles in one environment
Creating your own look and feel - overview
A review - what I should now know!
Summary
Chapter 17: Upgrading to 12c
Checking the 11g system and files
Generation
Export bundle
Bundle contents
Import via the Configuration Assistant
Import via the BI Migration Script
Connectivity
Consistency check
Security and manual migration
Regression testing
A review - what I should now know!
Summary

What You Will Learn

  • Install OBIEE in Windows, including how to create the underlying Weblogic Application server and the required database
  • Build the BI system repository, the vital engine connecting your data to the front end of Oracle BI
  • Develop effective analysis, draw out meaning from the data, and present it to end users on interactive dashboards
  • Build pixel-perfect, printable reports using the embedded BI Publisher feature
  • Build agents for actionable insight and enable your users to act on Business Intelligence at their desktop or on the move
  • Understand the various aspects of securing the Oracle BI system, from data restrictions to whole dashboard access rights
  • Get acquainted with the system management tools and methods available for the continuous improvement of your system

Authors

Table of Contents

Chapter 1: Oracle BI 12c Architecture
Let's look at the big picture
Terminology differences from Oracle BI 11g
What is Oracle Fusion Middleware?
Why is there a database repository for OBIEE?
Overall components
WebLogic Server
System tools controlled by WebLogic
Security
System requirements
Scaling out Oracle BI 12c
Enterprise Deployment Guide
Directory folder structure
Download Oracle BI 12c
System requirements
References
A review - what I should now know!
Summary
Chapter 2: Installing the Prerequisite Software
Installation overview
Installation media
System requirements
Installing Java
Installing the WebLogic Server
Installing the metadata schemas
Gotchas
A review - what I should now know!
Summary
Chapter 3: Installing on Windows Server 2012
Installation overview
Installation media
Configuring start and stop links
A review - what I should now know!
Summary
Chapter 4: Reviewing the Features of the Reporting Repository
Integrated tools
The home screen
Catalog
New
Administration
A review - what I should now know!
Summary
Chapter 5: Installing and Configuring Client Tools
Installing the client software
Configuring a connection to the OBIEE Server
Configuring a connection to the database
Creating shortcuts
Testing the client software
A review - what I should now know!
Summary
Chapter 6: Understanding the Systems Management Tools
Let's talk management tools
WebLogic Server Administration Control
Servers
Clusters
Machines / IP address or DNS
Data Sources / JDBC connections
Security Realms
WebLogic Server is its own application
Using WLST
Enterprise Manager Fusion Middleware Control
Oracle BI 12c Lifecycle Management
Creating users, roles, and associations
Creating users and groups in WebLogic Server
Assigning users to groups
Creating and assigning Application Roles
JMX, MBeans, Java, and interfacing Oracle BI
Migrating FMW Security to other environments
FMW Security Import/Export utility
Using the Security Realm migration utility
Oracle BI Publisher system management
Monitoring system performance
Have a backup plan!
Recommendations for further learning
A review - what I should know now!
Summary
Chapter 7: Developing the BI Server Repository
Prerequisites
Repository architecture
Physical layer
Business layer
Presentation layer
Federated and fragmented content
Variables and initialization blocks
A review - what I should now know!
Summary
Chapter 8: Creating Dashboards and Analyses
Creating our first analysis
Creating our first Dashboard
Analysis building - more details
Pretty useful stuff!
A review - what I should now know!
Summary
Chapter 9: Agents and Action Framework
Agents
Actions
A review - what I should know now!
Additional research suggestions
Oracle documentation on Actions
Summary
Chapter 10: Developing Reports Using BI Publisher
Don't miss the installation integration checkpoint!
What's all this XML talk?
Where to administer BI Publisher
Where to build a data model
Let's get publishing
Enabling Audit Policy in the Fusion Middleware Control Enterprise Manager
Connecting to Oracle BI server data sources
A review - what I should now know!
Summary
Chapter 11: Usage Tracking
What is usage tracking?
Analyzing usage
Customizing your setup
Additional data
A review - what I should now know!
Summary
Chapter 12: Improving Performance
What is poor performance?
A review - what I should now know!
Summary
Chapter 13: Using the BI Admin Change Management Utilities
Problems with multiple developers
Merges
Multiuser Development Environment
A review - what I should now know!
Additional research suggestions
Summary
Chapter 14: Ancillary Installation Options
Oracle BI 12c on its own server
Custom ports and port management
Installing Oracle BI 12c on *Nix
Listening on port 80
Configuring a HTTP proxy with the NGINX web server
Enabling compression on web servers
Automating starting and stopping
Recommendations for further learning
A review - what should I know now?
Summary
Chapter 15: Reporting Databases
Theories and models
Designing your database - objectives, rules, and goals
Creating a warehouse
Some definitions
A review - what you should know now!
Summary
Chapter 16: Customizing the Style of Dashboards
Multiple skins and styles in one environment
Creating your own look and feel - overview
A review - what I should now know!
Summary
Chapter 17: Upgrading to 12c
Checking the 11g system and files
Generation
Export bundle
Bundle contents
Import via the Configuration Assistant
Import via the BI Migration Script
Connectivity
Consistency check
Security and manual migration
Regression testing
A review - what I should now know!
Summary

Book Details

ISBN 139781786464712
Paperback578 pages
Read More

Read More Reviews

Recommended for You

Oracle Weblogic Server 11gR1 PS2: Administration Essentials Book Cover
Oracle Weblogic Server 11gR1 PS2: Administration Essentials
$ 32.99
$ 23.10