Book description
Master Oracle Business Intelligence 11g Reports and Dashboards
Deliver meaningful business information to users anytime, anywhere, on any device, using Oracle Business Intelligence 11g. Written by Oracle ACE Director Mark Rittman, Oracle Business Intelligence 11g Developers Guide fully covers the latest BI report design and distribution techniques. Find out how to execute effective queries, build accurate models, use scorecards and KPIs, create dynamic reports, set up dashboards, and publish to smartphones and wireless devices. This Oracle Press guide contains comprehensive details on Oracle Exalytics In-Memory Machine, the best-in-class, preintegrated BI platform.
- Install or upgrade to Oracle Business Intelligence 11g
- Develop and manage custom Oracle Business Intelligence repositories
- Access relational, file, and multidimensional data sources
- Design print-quality reports with Oracle Business Intelligence Publisher
- Create web-enabled analyses, dashboards, and visualizations
- Integrate with other applications using Oracle Business Intelligence 11g Action Framework
- Employ authentication, authorization, and row-level security
- Configure and deploy Oracle Exalytics In-Memory Machine
Table of contents
- Cover
- Copyright
- Contents
- Foreword
- Acknowledgments
- Introduction
- 1. Oracle Business Intelligence Overview and Architecture
- 2. Installation and Upgrading Oracle Business Intelligence
-
3. Modeling Repositories Using Relational, File, and XML Sources
- What Is the Oracle Business Intelligence Repository?
- An Oracle Business Intelligence Repository Modeling Primer
-
Creating the Oracle BI Repository
- Step 1: Create the New Repository and Importing Source Data
- Step 2: Create Aliases for Imported Table Names, and Physical Display Folders to Organize Them
- Step 3: Create Primary and Foreign Keys in the Physical Model
- Step 4: Create the Business Model, Outline Logical Tables, and Add Logical Columns
- Step 5: Create Logical Keys and Logical Joins
- Step 6: Define Logical Dimensions and Hierarchies
- Step 7: Define Calculations and Other Derived Columns
- Step 8: Publish the Business Model as Subject Areas
- Step 9: Check the Repository for Consistency Warnings and Errors
- Step 10: Publish the Repository as the Default, Online Repository
- Calculations and Formulas
- Advanced Repository Modeling Scenarios
- Overview of File and XML Source Support
- Modeling File Sources, Including Microsoft Excel
- Modeling XML Sources
-
4. Creating Repositories from Oracle Essbase and Other OLAP Data Sources
-
Overview of Oracle Business Intelligence Support for Multidimensional Data Sources
- Supported OLAP Data Sources
- How the Oracle BI Server Accesses OLAP Data Sources
- Multidimensional-Specific Repository Metadata Objects
- Automatic Creation of Business Models
- Pass-Through Security for Data and Metadata Filters
- Leveraging OLAP Functions and Analytics
- Federation of OLAP, Relational, and Other Sources
- End-User Analysis Features for OLAP Data
- Creating Repositories from Oracle Essbase Data Sources
- Creating Repositories from Microsoft Analysis Services Data Sources
- Creating Repositories from Oracle OLAP Data Sources
- Combining OLAP and Relational Data in Business Models
-
Overview of Oracle Business Intelligence Support for Multidimensional Data Sources
- 5. Configuring and Maintaining the Oracle BI Server
-
6. Creating Analyses, Dashboards, KPIs and Scorecards
- An Introduction to Analyses, Dashboards, and Interactive Reporting
- Creating Analyses
- Creating Dashboards
- Dashboard Prompts, Presentation Variables, Saved Filters, and Other Dashboard Additions
- Presentation Variables and Using Variables in BI Objects
- Managing the Catalog and Oracle BI Presentation Services
- Creating KPIs and Scorecards
- Accessing Dashboards and Reports Using Mobile Devices
- 7. Actionable Intelligence
-
8. Security
- An Overview of Oracle Business Intelligence Security
- Configuring Row-Level Security
- Configuring Subject Area, Catalog, and Functional Area Security
- Understanding Oracle Business Intelligence Security Infrastructure, Application Roles, and Application Policies
- Working with Users and Groups in the Embedded LDAP Server
- Managing Application Roles and Policies
- Connecting to External Directories and Other Sources for Authentication and Authorization
- 9. Creating Published Reports
- 10. Systems Management
-
11. Managing Change
- Overview of Managing Change
- Tools and Utilities to Manage Change Within Oracle Business Intelligence Systems
- Types of Oracle Business Intelligence Development Environments
- Managing System Configuration Changes
- Incremental Releases of Repositories Using Merging and Patching
- Incremental Releases of Catalogs Using Merging and Patching
- Source-Controlling Business Intelligence Metadata
- Concurrent Online Editing of the Repository
- The Multiuser Development Environment
- 12. Oracle Exalytics In-Memory Machine
- Index
Product information
- Title: Oracle Business Intelligence 11g Developers Guide
- Author(s):
- Release date: September 2012
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071798754
You might also like
book
Oracle Business Intelligence Discoverer 11g Handbook
Master Oracle Business Intelligence Discoverer 11g Provide secure, immediate access to critical business information from relational …
book
Oracle E-Business Suite R12.x HRMS – A Functionality Guide
Design, implement, and build an entire end-to-end HR management infrastructure with Oracle E-Business Suite In Detail …
book
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach
Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured …
book
Oracle SOA Suite 11g Handbook
Master Oracle SOA Suite 11 g Design and implement an agile service-oriented enterprise computing infrastructure using …