Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Oracle Business Intelligence Enterprise Edition 12c
  • Table Of Contents Toc
  • Feedback & Rating feedback
Oracle Business Intelligence Enterprise Edition 12c

Oracle Business Intelligence Enterprise Edition 12c

By : Ward, Khan
4.7 (3)
Buy this Book
close
close
Oracle Business Intelligence Enterprise Edition 12c

Oracle Business Intelligence Enterprise Edition 12c

4.7 (3)
By: Ward, Khan
Buy this Book

Overview of this book

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

Why is there a database repository for OBIEE?

Similar to the previous Oracle BI version, Oracle BI 12c requires a relational database repository schema to hold metadata concerning the installation, report scheduling, usage tracking, auditing, and other aspects of the environment. As an initial set of steps in the installation process, these very necessary repositories are created using the Repository Creation Utility (RCU) against the selected database server. Chapter 2, Installing the Pre-requisite Software, goes into greater detail about this crucial repository structure. In Oracle BI 11g, two database schemas were installed with the RCU-Metadata Services (MDS) and BIPLATFORM. However, in Oracle BI 12c there can be up to nine database repository schemas for Oracle BI 12c that can be installed via the Oracle BI 12c RCU. There are now even more repository schemas that must be installed for Oracle BI 12c to be correctly installed and configured. The additional required schemas will have the suffixes WLS, WLS_RUNTIME, STB, and OPSS. Other schemas available are for auditing purposes, if optionally chosen for the implementation.

Note

Another interesting fact is that the Oracle BI Metadata Repository (RPD) is still a file, typically prefixed as RPD (that is, .rpd extension) and even in the latest version of Oracle BI the metadata is not stored in any database repository.

The Oracle BI Metadata Repository is the metadata storage mechanism in which Oracle BI developers model and map physical data sources to logical business representations in order for the resulting analytics to be easily consumed by end users.

The term Oracle BI Domain, as noted previously and shown in the illustration, is used as a way to group all Oracle BI 12c components within the Fusion Middleware (that is, WebLogic Server) architecture. This should not be confused with the WebLogic Application Server Domain, which is given the default name bi when following the default Oracle BI 12c installation options. The latter is a WebLogic Java Application Server term. The former is a Fusion Middleware term. Since Fusion Middleware is so closely related to the WebLogic Application Server, this is good to keep in mind from a technical perspective.

Note

When learning about the overall component composition, a very important detail to keep in mind is the manner in which the components are managed. Since WebLogic Server is a Java application server, it manages all of the Oracle BI components developed in the Java programming language. The Oracle BI System Components are now managed by the WebLogic Management Framework (WMF) which is the same system that manages the WebLogic Scripting Tool (WLST) functionality.

End of Section 5
Next Section

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist download
font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY