Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library 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
Oracle Business Intelligence Enterprise Edition 12c

Oracle Business Intelligence Enterprise Edition 12c - Second Edition

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
Lock Free Chapter
1
1. Oracle BI 12c Architecture
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
chevron up
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

Analyzing usage

Now that we are getting data into the tables and have set up the BI repository to access the data, we can start creating analyses to see what is going on. Typical analyses that I would create are:

  • Top 10 slowest dashboards
  • Top 10 slowest analyses
  • User activity over time
  • Non-users
  • Dashboard usage analysis
  • Error reports

Usage measures

Before using some of the measures, you need to understand what each one does and how they are relevant. The following describes each field in the main usage tracking table:

  • TOTAL_TIME_SEC: The time (in seconds) that the Oracle BI Server spent working on the query while the client waited for responses to its query requests. This setting is the same as the response time in the NQQuery.log file. Usually it is the difference between the start time and the end time. The same results are returned from the following function:
        ROUND((CAST(END_TS as DATE)-CAST(START_TS as DATE))*86400)
  • COMPILE_TIME_SEC: The time (in seconds) required to compile the query...
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Oracle Business Intelligence Enterprise Edition 12c
End of Section 11
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options
font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

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

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon