A review - what I should now know!
by Haroun Khan, Christian Screen, Adrian Ward
Oracle Business Intelligence Enterprise Edition 12c - second Edition
- Oracle Business Intelligence Enterprise Edition 12c - second Edition
- Oracle Business Intelligence Enterprise Edition 12c - second Edition
- Credits
- About the Authors
- About the Reviewer
- www.PacktPub.com
- Customer Feedback
- Preface
- 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. Installing the Prerequisite Software
- 3. Installing on Windows Server 2012
- 4. Reviewing the Features of the Reporting Repository
- 5. Installing and Configuring Client 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
- What is a BAR File?
- Deploying, migrating, and backing up artifacts
- 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. Developing the BI Server Repository
- 8. Creating Dashboards and Analyses
- 9. Agents and Action Framework
- 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
- Administration management of BI Publisher
- Accessing the BI Publisher Administration page
- Verifying application roles
- Creating the data source JDBC connection
- Creating a file (XLS) data source
- Verifying application role data source privileges
- Setting up a data model
- Creating a new Presentation Catalog folder
- Creating a new data model
- Creating an SQL query data set
- Adjusting data set display names
- Creating a parameter
- Creating a list of values
- Connecting the parameter to the list of values
- Getting the sample data
- Creating a BI Publisher report using the Layout Editor
- Auditing and monitoring BI Publisher
- Modifying a few configuration files
- 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. Usage Tracking
- 12. Improving Performance
- 13. Using the BI Admin Change Management Utilities
- 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. Reporting Databases
- 16. Customizing the Style of Dashboards
- 17. Upgrading to 12c
For self-review and recap of the chapter, here are a few questions based on important topics covered in this chapter:
- What are the three layers of an RPD?
- How do you define physical joins?
- How do you set up the levels of a dimension?
- How do you create a level-based measure?
- What is a way of using functions to compare time periods in a report?
- How do you ensure that a fact-less query is routed properly?
- How and why do you add multiple sources to a logical table?
- How do you check that an RPD is consistent?
The following are some additional research suggestions that may help you in understanding this chapter in more detail:
- Help files in the Administration Tool
- Oracle documentation at https://docs.oracle.com/middleware/1221/biee/BIEMG/
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.