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.
  • Oracle Business Intelligence Enterprise Edition 12c
  • Toc
  • feedback
Oracle Business Intelligence Enterprise Edition 12c

Oracle Business Intelligence Enterprise Edition 12c

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

Oracle Business Intelligence Enterprise Edition 12c

4.7 (3)
By: Ward, Khan

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
Preface
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Free Chapter
1
1. Oracle BI 12c Architecture
chevron up
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
2
2. Installing the Prerequisite Software
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
3
3. Installing on Windows Server 2012
3. Installing on Windows Server 2012
Installation overview
Installation media
Configuring start and stop links
A review - what I should now know!
Summary
4
4. Reviewing the Features of the Reporting Repository
4. Reviewing the Features of the Reporting Repository
Integrated tools
The home screen
Catalog
New
Administration
A review - what I should now know!
Summary
5
5. Installing and Configuring Client Tools
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
6
6. Understanding the Systems Management Tools
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
7
7. Developing the BI Server Repository
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
8
8. Creating Dashboards and Analyses
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
9
9. Agents and Action Framework
9. Agents and Action Framework
Agents
Actions
A review - what I should know now!
Additional research suggestions
Oracle documentation on Actions
Summary
10
10. Developing Reports Using BI Publisher
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
11
11. Usage Tracking
11. Usage Tracking
What is usage tracking?
Analyzing usage
Customizing your setup
Additional data
A review - what I should now know!
Summary
12
12. Improving Performance
12. Improving Performance
What is poor performance?
A review - what I should now know!
Summary
13
13. Using the BI Admin Change Management Utilities
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
14
14. Ancillary Installation Options
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
15
15. Reporting Databases
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
16
16. Customizing the Style of Dashboards
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
17
17. Upgrading to 12c
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

Let's look at the big picture

Going right for the guts of the platform, it is best to understand how the Oracle BI 12c system is laid out by looking at the logical interoperability of the architectural components. Oracle BI 12c is a combination of several core technologies, which reside as common software components within the Oracle Fusion Middleware (FMW) stack inside the Oracle software eco-system.

The following illustration shows some of Oracle BI 12c's logical architecture components. Users of Oracle BI 11g will find some of this topology familiar, yet clearly different in many ways:

Let's look at the big picture

  • Oracle BI Domain: This is the core architecture of Oracle BI 12c
  • WebLogic Server: This is the chosen application server for Oracle BI 12c
  • Service Instance: The structural housing for all critical Oracle BI artifacts (metadata) that would allow delineated movement from one environment to another (also multi-tenancy in future releases)
  • Javacomponents: These are the components which have been written in Java for Oracle BI 12c. They are deployed to the application server and WebLogic Server
  • BI System Components: These are the components which have been written mainly in C++ for Oracle BI 12c
  • Oracle BI relational repository: This is a set of database schemas (BIPLATFORM and MDS) that store metadata related to a specific Oracle BI 12c instance
  • Oracle BI filesystem: This is the instructional set of physical files and directories containing configuration, logs, and metadata concerning the Oracle BI 12c instance

Similar to the Oracle BI 11g environment, once the software has been installed, all of the components in the architecture topology shown will exist. These components are transparent to the end users (that is, users in the organization who will view dashboards, reports, receive alerts, and so on). However, for the Oracle BI 12c administrators, and those that need to work with the technical aspect of the system, each of these areas of the Oracle BI 12c architecture is very important.

End of Section 2
Next Section
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