Oracle business intelligence 11g developer's guide
Master Oracle Business Intelligence 11 g 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 l...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York :
McGraw-Hill
[2013]
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628963806719 |
Tabla de Contenidos:
- Cover
- Title Page
- Copyright Page
- About the Author
- About the Technical Editors
- Contents at a Glance
- Contents
- Foreword
- Acknowledgments
- Introduction
- What You Will Learn
- What's in the Book
- Intended Audience
- About the Examples, and Retrieving the Sample Data Set
- Chapter 1: Oracle Business Intelligence Overview and Architecture
- Introducing Oracle Business Intelligence
- The Development Toolkit
- Platform Support
- How Does Oracle Business Intelligence Work?
- So Where Does the Data Come From?
- What Does Oracle Business Intelligence "Not Do"?
- A History of Oracle Business Intelligence
- Oracle Product Release History
- Oracle Business Intelligence 11g Release 1 Architecture
- Oracle Business Intelligence 11g and Oracle Fusion Middleware
- Chapter 2: Installation and Upgrading Oracle Business Intelligence
- Preparing for the Installation
- Microsoft Windows-Specific Preinstallation Tasks
- Linux- and Unix-Specific Preinstallation Tasks
- Database Server Requirements
- Creating the Supporting Database Schemas
- What Schemas Are Created During the Installation Process?
- Running the Repository Creation Utility to Create Repository Schemas
- Additional Repository Creation Utility Considerations for Linux/Unix and Microsoft Windows 64-Bit Platforms
- Performing a New Installation of Oracle Business Intelligence 11g
- Installation Options
- Using the Simple Install Option
- Using the Enterprise Install - Create New BI System Option
- Using the Software Only Install Option
- Post-Installation Configuration Steps
- Configuring Data Source Connectivity
- Installing Oracle Business Intelligence Client Tools
- Upgrading from Oracle Business Intelligence 10g
- Overview of the Upgrade Process
- Using the Upgrade Assistant
- Post-Upgrade Configuration Tasks.
- Chapter 3: Modeling Repositories Using Relational, File, and XML Sources
- What Is the Oracle Business Intelligence Repository?
- An Oracle Business Intelligence Repository Modeling Primer
- The Three-Layer Repository Architecture
- Other Information Stored in the Oracle BI Repository
- Identifying the Logical Dimensional Model
- What Tools Do I Use to Build the Repository?
- Example: 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
- How the Oracle BI Server Performs Calculations
- A Guide to Repository Functions
- The Calculation Wizard
- Advanced Repository Modeling Scenarios
- Repository Development Tools and Concepts
- Advanced Repository Modeling Concepts
- Overview of File and XML Source Support
- What File, XML, and Oracle ADF Sources Can You Use with Oracle Business Intelligence?
- Supported vs. Unsupported Sources
- How Does This Differ from Relational and OLAP Sources?
- Modeling File Sources, Including Microsoft Excel
- Overview
- Setting Up Connectivity and Importing File Metadata Using ODBC Drivers
- Creating the Physical Model
- Modeling XML Sources
- Overview
- Setting Up Connectivity to XML Sources.
- Chapter 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
- Connecting to Oracle Essbase
- Viewing and Amending the Physical Model
- Creating the Business Model
- Creating the Subject Area
- Leveraging Essbase Security and Filters
- Managing Changes to Essbase Metadata
- Querying Essbase Data-MDX Considerations
- Creating Repositories from Microsoft Analysis Services Data Sources
- Connecting to Microsoft Analysis Services
- Creating the Physical Model
- Creating the Business Model
- Creating the Subject Area
- Managing Changes to Microsoft Analysis Services Metadata
- Querying Microsoft Analysis Services Data-MDX Considerations
- Creating Repositories from Oracle OLAP Data Sources
- Connecting to Oracle OLAP
- Creating the Physical Model
- Creating the Business Model
- Creating the Subject Area
- Managing Changes to Oracle OLAP Metadata
- Querying Oracle OLAP Data-OLAP_TABLE and OLAP DML Considerations
- Combining OLAP and Relational Data in Business Models
- Vertical Federation of OLAP and Relational Data
- Horizontal Federation of OLAP and Relational Data
- Adding Attributes to OLAP Data Using Lookups
- Chapter 5: Configuring and Maintaining the Oracle BI Server
- Configuring the Oracle BI Server
- Configuration Settings Handled by Fusion Middleware Control.
- Manually Configured Settings
- Additional BI Server Functions and Management Tasks
- Managing the Oracle BI Server Query Cache
- Overview of the BI Server Query Cache
- Managing the Query Cache
- Usage Tracking
- Overview of Usage Tracking
- Setting Up Usage Tracking
- The Aggregate Persistence Wizard
- Overview of Aggregate Handling in the BI Server
- Creating Aggregates with the Aggregate Persistence Wizard
- Working with Write Back
- How Is Write Back Configured and Performed?
- Example: Configuring Write Back to a Relational Data Source
- Chapter 6: Creating Analyses, Dashboards, KPIs, and Scorecards
- An Introduction to Analyses, Dashboards, and Interactive Reporting
- What Are Analyses and Dashboards?
- An Initial Look Around the Oracle Business Intelligence Web Site
- Creating Analyses
- Defining the Analysis Criteria
- Creating Analysis Views
- Analysis Prompts
- Creating Dashboards
- Creating a Simple Dashboard
- Creating Dashboards with Multiple Pages, Conditional Display, and Section-Level Permissions
- Dashboard Prompts, Presentation Variables, Saved Filters, and Other Dashboard Additions
- Dashboard Prompts
- Saved Filters
- Managing Favorites
- Presentation Variables and Using Variables in BI Objects
- Creating and Populating Presentation Variables
- Referencing Presentation Variables and Other Variable Types in Analyses and Other BI Objects
- Examples of Variables in Use on a Dashboard
- Managing the Catalog and Oracle BI Presentation Services
- Managing the Catalog
- Administering Oracle BI Presentation Services
- Creating KPIs and Scorecards
- Overview of KPIs and Scorecards
- Creating KPIs
- Creating KPI Watchlists
- Creating Scorecards
- Accessing Dashboards and Reports Using Mobile Devices
- Overview of Mobile Access Using the iPad and iPhone.
- Configuring an Apple iPad for Oracle BI Mobile
- Analyzing Data Using the iPad and iPhone
- Chapter 7: Actionable Intelligence
- What Is Actionable Intelligence and the Action Framework?
- Actions
- Agents and Conditions
- Introduction to the Action Framework
- Creating Actions, Actions Links, and Action Link Menus
- Actions, Configuration, and Security
- Action Types
- Navigation Actions
- Invocation Actions
- Creating Agents and Conditions
- Overview of Agents and Conditions
- Creating an Agent
- Creating Conditions
- Chapter 8: Security
- An Overview of Oracle Business Intelligence Security
- Configuring Row-Level Security
- Row-Level Security Using the BI Server and the Oracle BI Repository
- Configuring Subject Area, Catalog, and Functional Area Security
- Example: Subject Area Security Through the Oracle BI Repository
- Subject Area Security Using Presentation Server Catalog Privileges
- Understanding Oracle Business Intelligence Security Infrastructure, Application Roles, and Application Policies
- Oracle Platform Security Services
- Application Roles and Policies
- The Default Security Profile
- Working with Users and Groups in the Embedded LDAP Server
- Example: Creating New Users and Adding them to Groups
- Managing Application Roles and Policies
- Example: Creating and Managing Application Roles
- Creating and Managing Application Policies
- Connecting to External Directories and Other Sources for Authentication and Authorization
- Example: Configuring Oracle Business Intelligence to Connect to Microsoft Active Directory
- Example: Using Database Tables for User Authorization
- Chapter 9: Creating Published Reports
- Introduction to Oracle BI Publisher
- Oracle BI Publisher Data Model Editor
- Oracle BI Publisher Online Layout Editor
- How Does Oracle BI Publisher Generate Reports?.
- Oracle BI Publisher Features Covered in This Chapter.
