Oracle Fusion Middleware Oracle Business Intelligence .
Oracle Fusion MiddlewareMetadata Repository Builder's Guide forOracle Business Intelligence EnterpriseEdition12c (12.2.1.4.0)E91571-04August 2021
Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence EnterpriseEdition, 12c (12.2.1.4.0)E91571-04Copyright 2010, 2021, Oracle and/or its affiliates.Primary Author: Hemala VivekContributing Authors: Christine Jacobs, Stefanie RhoneContributors: Oracle Business Intelligence development, product management, and quality assurance teamThis software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverseengineering, disassembly, or decompilation of this software, unless required by law for interoperability, isprohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it onbehalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software,any programs embedded, installed or activated on delivered hardware, and modifications of such programs)and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government endusers are "commercial computer software" or "commercial computer software documentation" pursuant to theapplicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use,reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/oradaptation of i) Oracle programs (including any operating system, integrated software, any programsembedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oraclecomputer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in thelicense contained in the applicable contract. The terms governing the U.S. Government’s use of Oracle cloudservices are defined by the applicable contract for such services. No other rights are granted to the U.S.Government.This software or hardware is developed for general use in a variety of information management applications.It is not developed or intended for use in any inherently dangerous applications, including applications thatmay create a risk of personal injury. If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure itssafe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of thissoftware or hardware in dangerous applications.Oracle, Java, and MySQL are registered trademarks of Oracle and/or its affiliates. Other names may betrademarks of their respective owners.Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc,and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registeredtrademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products,and services from third parties. Oracle Corporation and its affiliates are not responsible for and expresslydisclaim all warranties of any kind with respect to third-party content, products, and services unless otherwiseset forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not beresponsible for any loss, costs, or damages incurred due to your access to or use of third-party content,products, or services, except as set forth in an applicable agreement between you and Oracle.
ContentsPrefaceAudiencexxiiiDocumentation AccessibilityxxiiiRelated Documentation and Other ResourcesxxiiiConventionsxxivNew Features for Oracle BI Metadata Repository Builders1New Features for Oracle BI EE 12c (12.2.1.1.0)xxvNew Features for Oracle BI EE 12c Release (12.2.1.0)xxvIntroduction to Building Your Metadata RepositoryAbout Oracle BI Server Architecture1-1About Layers in the Oracle BI Repository1-2Analyzing Your Business Model Requirements1-4Identifying the Content of the Business Model1-5Identifying Logical Fact Tables1-5Identifying Logical Dimension Tables1-6Identifying Dimensions1-7About Dimensions with Multiple HierarchiesIdentifying Lookup TablesIdentifying the Data Source Content for the Physical LayerAbout Types of Physical Schemas in Relational Data Sources1-81-91-91-9About Cubes in Multidimensional Data Sources1-10Identifying the Data Source Table Structure1-10Guidelines for Designing a Repository1-11Design Strategies for Structuring the Repository1-11Design Tips for the Physical Layer1-12Design Tips for the Business Model and Mapping Layer1-13Modeling Outer JoinsDesign Tips for the Presentation LayerTopics of Interest in Other Guides1-141-151-16iii
System Requirements and Certification21-17Before You BeginOpening the Administration Tool2-1Setting Administration Tool Options2-2Oracle BI Administration Tool General Options2-2Oracle BI Administration Tool Repository Options2-4Editing, Deleting, and Reordering Objects in the Repository2-6About Naming Requirements for Repository Objects2-6Changing Icons for Repository Objects2-6Sorting Objects in the Administration Tool2-7About the Oracle BI Server Command-Line Utilities2-7About Options in NQSConfig.INI2-10About the SampleApp.rpd Demonstration Repository2-10Download Repository Command2-11What You Need to Know Before Using the Command2-12Using Online and Offline Repository Modes2-13Editing Repositories in Offline Mode2-13Opening Repositories in Offline Mode2-14Publish Offline Changes2-14Editing Repositories in Online Mode2-14Opening Repositories in Online Mode2-15Publishing Online Changes2-15Guidelines for Using Online Mode2-16Checking Out Objects2-17Checking In Changes2-17About Read-Only Mode2-18Opening a MDX XML Repository2-18Checking the Consistency of a Repository or a Business Model32-19About the Consistency Check Manager2-19Running the Consistency Check Manager2-20Using the validaterpd Utility to Check Repository Consistency2-21Common Consistency Check Messages2-23Setting Up and Using the Multiuser Development EnvironmentAbout the Multiuser Development Environment3-1About the Multiuser Development Process3-2Setting Up Projects3-3About Projects3-4iv
Creating Projects3-4About Converting Older Projects During Repository Upgrade3-5Setting Up the Multiuser Development DirectoryIdentifying the Multiuser Development Directory3-6Copying the Master Repository to the Multiuser Development Directory3-7Setting Up a Pointer to the Multiuser Development Directory3-7Making Changes in a Multiuser Development Environment3-8About Changing and Testing Metadata3-8Making Changes to a Repository Using Projects3-9About Repository Project Checkout3-9Checking Out Projects3-10Using the extractprojects Utility3-10Refreshing the Local Project Extract3-12Making Changes to an Entire Repository3-12About Multiuser Development Options3-12Publishing Changes to Multiuser Development RepositoriesAbout the Multiuser Development Merge ProcessHow Are Multiuser Merges Different from Standard Repository Merges?3-133-143-15Publishing to the Network3-15Enforcing Consistent Repositories When Publishing Changes3-16Branching in Multiuser Development3-16About Branching3-16Using the Multi-Team, Multi-Release Model in Oracle Business Intelligence3-18Synchronizing RPD Branches3-18Viewing and Deleting History for Multiuser Development3-19Viewing Multiuser Development History3-19Deleting Multiuser Development History3-19Setting Multiuser Development Options43-63-20Using a Source Control Management System for RepositoryDevelopmentAbout Using a Source Control Management System with the Administration ToolAbout MDS XMLSetting Up Your System for Repository Development Under Source Control Management4-14-24-4Creating an SCM Configuration File4-4Creating an MDS XML Repository and Checking In Files to the SCM System4-6Saving an Existing Repository File in MDS XML Format4-6Creating a New Repository in MDS XML Format4-7Linking to Source Control Files to Convert Your Repository (Small RepositoriesOnly)4-7v
Using Source Control Management in Day to Day Repository Development4-8Updating, Saving, and Checking In Changes for Repositories Under Source Control4-8Handling Errors4-9Testing Repositories Under Source Control4-10Viewing the Source Control Log4-10Using Source Control Management with MUD54-11Putting the MUD Master Repository and MUD Log File Under Source Control4-11Checking In New Versions of the MUD Master and MUD Log File to Source Control4-11Manually Checking In the Updated MUD Master Repository and Log File4-12Using a Script to Check In the Updated MUD Master Repository and Log File4-12Importing Metadata and Working with Data SourcesAbout Importing Metadata and Working with Data Sources5-1Creating an Oracle BI Repository5-2Performing Data Source Preconfiguration Tasks5-2Setting Up ODBC Data Source Names (DSNs)5-3Setting Up Oracle Database Data Sources5-4Oracle 12c Database In-Memory Data Sources5-4Oracle 12c on Exadata Data Sources5-4Advanced Oracle Database Features Supported by Oracle BI Server5-5Oracle Database Fast Application Notification and Fast Connection Failover5-6Additional Oracle Database Configuration for Client Installations5-6Configuring Oracle BI Server When Using a Firewall5-6DataDirect Drivers and Oracle Database5-6Oracle Database Connection Errors in Windows 7 64-bit Environments5-7About Setting Up Oracle OLAP Data Sources5-7Java Data Sources5-7Loading Java Data Sources5-8About Setting Up Oracle TimesTen In-Memory Database Data Sources5-8Configuring TimesTen Data Sources5-8Improving Use of System Memory Resources with TimesTen Data Sources5-9Configuring OBIS to Access the TimesTen DLL on Windows5-10About Setting Up Essbase Data Sources5-10About Setting up Cloudera Impala Data Sources5-11Obtaining Windows ODBC Driver for Cloudera5-11Importing Cloudera Impala Metadata Using the Windows ODBC Driver5-11About Setting Up Apache Hive Data Sources5-12Obtaining Windows ODBC Driver for Client Installation5-12Limitations on the Use of Apache Hive with Oracle Business Intelligence5-12About Setting Up Hyperion Financial Management Data Sources5-15vi
Performing Additional Hyperion Configuration for Client InstallationsSetting Up SAP/BW Data Sources5-17Setting Up Oracle RPAS Data Sources5-18Setting Up Teradata Data Sources5-18Avoiding Spool Space Errors for Queries Against Teradata Data Sources5-19Enabling NUMERIC Data Type Support for Oracle Database and TimesTen5-20Configuring Essbase to Use a Shared Logon5-20Configuring SSO for Essbase, Hyperion Financial Management, or Hyperion PlanningData Sources5-21Importing Metadata from Relational Data Sources5-21Importing Metadata from Multidimensional Data Sources5-23Multidimensional Data Source Connection Options5-24About Importing Metadata from Oracle RPAS Data Sources5-26About Importing Metadata from XML Data Sources5-27About Using XML as a Data Source5-28Importing Metadata from XML Data Sources Using the XML Gateway5-29Examples of XML Documents Generated by the Oracle BI Server XML Gateway5-30About Using HTML Tables as a Data Source5-35Importing Metadata from XML Data Sources Using XML ODBCExample of an XML ODBC Data SourceExamples of XML DocumentsAbout Using a Standby Database with Oracle Business Intelligence65-175-375-385-395-42Configuring a Standby Database with Oracle Business Intelligence5-42Creating the Database Object for the Standby Database Configuration5-43Creating Connection Pools for the Standby Database Configuration5-44Updating Write-Back Scripts in a Standby Database Configuration5-44Setting Up Usage Tracking in a Standby Database Configuration5-45Setting Up Event Polling in a Standby Database Configuration5-45Setting Up Oracle BI Scheduler in a Standby Database Configuration5-45Working with ADF Data SourcesWhat Are ADF Business Components?About Operational Reporting with ADF Business Components6-16-2About Importing ADF Business Components Into Oracle Business Intelligence6-2About Specifying a SQL Bypass Database6-3Setting Up ADF Data Sources6-4Creating a WebLogic Domain for ADF Business Components Used with OracleBusiness Intelligence6-4Deploying OBIEEBroker as a Shared Library in Oracle WebLogic Server6-5Deploying the Application EAR File to Oracle WebLogic Server from JDeveloper6-5Setting Up a JDBC Data Source in the WebLogic Server6-9vii
Setting the Logging Level for the Deployed Application in Oracle WebLogic Server6-9Importing Metadata from ADF Data Sources6-10Performing an Initial Import from ADF Data Sources6-10Using Incremental Import to Propagate Flex Object Changes6-11Automatically Mapping Flex Object Changes to the Logical Model6-12Customizing the Mapping Behavior6-13Manually Mapping Flex Object Changes to the Logical Model6-14Automatically Mapping Flex Object Changes Using the biserverextender Utility6-14Configuring SSL in Oracle WebLogic Server6-15Configuring One-Way SSL in Oracle WebLogic Server6-16Configuring Two-Way SSL in Oracle WebLogic Server6-16Enabling the Ability to Pass Custom Parameters to the ADF Application6-17Propagating Labels and Tooltips from ADF Data Sources6-18What are Labels and Tooltips?6-18About the Session Variable Naming Scheme for UI Hints6-19About Determining the Physical Column for a Presentation Column6-20About Initializing Session Variables Automatically for Propagating UI Hints6-21Using UI Hints From an Oracle ADF Data Source When Creating Analyses6-21Using XML Code in Initialization Blocks to Query UI Hints6-21ADFQuery Element Reference76-22Setting Up Database Objects and Connection PoolsSetting Up Database Objects7-1About Database Types in the Physical Layer7-1Creating a Database Object Manually in the Physical Layer7-2Database General Properties Reference7-3When to Allow Direct Database Requests by Default7-3SQL Features Supported by a Data Source7-4Viewing Database Properties7-6Reviewing Supported Database Features7-7About Connection Pools7-7About Connection Pools for Initialization Blocks7-8Creating or Changing Connection Pools7-8Setting Connection Pool Properties in the General Tab7-9Common Connection Pool Properties in the General Tab7-9Multidimensional Connection Pool Properties in the General Tab7-12Setting Connection Pool Properties in the Connection Scripts Tab7-15Setting Connection Pool Properties in the XML Tab7-16Search Script Example7-17Setting Connection Pool Properties in the Write Back Tab7-17viii
Connection Pool Properties in the Miscellaneous TabSpecifying Application Properties for JDBC (Direct Driver) or JDBC (JNDI) DataSourcesEXECUTE PHYSICAL DATABASESetting Up Persist Connection Pools87-187-197-207-21Removing the Persist Connection Pool Property7-21About Setting the Buffer Size and Transaction Boundary7-22List Connection Pool Command7-22Update Connection Pool Command7-24Using the BIServerT2PProvisioner.jar Utility to Change Connection Pool Passwords7-25Working with Physical Tables, Cubes, and JoinsAbout Working with the Physical Layer8-1Working with the Physical Diagram8-2Creating Physical Layer Folders8-4Creating Physical Layer Catalogs and Schemas8-4Creating Catalogs8-4Creating Schemas8-5Using a Variable to Specify the Name of a Catalog or Schema8-5Setting Up Display Folders in the Physical Layer8-6Working with Physical Tables8-6About Tables in the Physical Layer8-7About Physical Alias Tables8-8Creating and Managing Physical Tables and Physical Cube Tables8-11Creating Physical Tables8-11Creating Alias Tables8-13Setting Physical Table Properties for XML Data Sources8-13Creating and Managing Columns and Keys for Relational and Cube Tables8-13Creating and Editing a Column in a Physical Table8-14Specifying a Primary Key for a Physical Table8-15Deleting Physical Columns for All Data Sources8-15Viewing Physical Column Properties8-15Viewing Data in Physical Tables or Columns8-16Working with Multidimensional Sources in the Physical Layer8-16About Physical Cube Tables8-16About Measures in Multidimensional Data Sources8-17About Externally Aggregated MeasuresAbout Working with Physical Dimensions and Physical Hierarchies8-178-18Working with Physical Dimension Objects8-18Working with Physical Hierarchy Objects8-19Working with Cube Variables for SAP/BW Data Sources8-21ix
Viewing Members in Physical Cube Tables8-22Working with Essbase Data Sources8-22About Using Essbase Data Sources8-23About Incremental Import8-25Working with Essbase Alias Tables8-26Determining the Value to Use for Display8-26Explicitly Defining Columns for Each Alias8-26Modeling User-Defined Attributes8-27Associating Member Attributes to Dimensions and Levels8-27Modeling Alternate Hierarchies8-27Modeling Measure Hierarchies8-29Improving Performance by Using Unqualified Member Names8-30Working with Hyperion Financial Management and Hyperion Planning Data Sources8-30Importing Metadata From Hyperion Financial Management Data Sources8-30Importing Metadata From Hyperion Planning Data Sources8-31About Query Support for Hyperion Financial Management and Hyperion Planning DataSources8-32Working with Oracle OLAP Data Sources8-32About Importing Metadata from Oracle OLAP Data Sources8-33Working with Oracle OLAP Analytic Workspace (AW) Objects8-34Working with Oracle OLAP Dimensions, Hierarchies, and Levels8-34Working with Oracle OLAP Cubes and Columns8-35Working with Physical Foreign Keys and Joins8-36About Physical Joins8-36About Primary Key and Foreign Key Relationships8-37About Complex Joins8-37About Multi‐Database Joins8-38About Fragmented Data8-38Defining Physical Joins with the Physical Diagram8-39Defining Physical Joins with the Joins Manager8-40Deploying Opaque Views8-41About Deploying Opaque Views8-41Deploying Opaque View Objects8-42Using the Create View SELECT Statement8-42Undeploying a Deployed View8-44When to Delete Opaque Views or Deployed Views8-44When to Redeploy Opaque Views8-44Using Hints in SQL Statements8-45How to Use Oracle Hints8-45About the Index Hint8-45About the Leading Hint8-46x
About Performance Considerations for Hints8-46Creating Hints8-46Displaying and Updating Row Counts for Physical Tables and ColumnsDisplaying Row Counts in the Physical Layer98-478-48Working with Logical Tables, Joins, and ColumnsAbout Working with the Business Model and Mapping Layer9-1Creating the Business Model and Mapping Layer9-2Creating Business Models9-2Automatically Creating Business Model Objects9-3Automatically Creating Business Model Objects for Multidimensional Data Sources9-3Duplicating a Business Model and Subject Area9-3About Working with the Business Model Diagram9-3Creating and Managing Logical Tables9-5Creating Logical TablesEnabling Data Driven Fragment Selection in Logical Table Sources9-59-6Specifying a Primary Key in a Logical Table9-6Reviewing Foreign Keys for a Logical Table9-7Defining Logical Joins9-7Defining Logical Joins with the Business Model Diagram9-8Defining Logical Joins with the Joins Manager9-9Creating Logical Joins with the Joins ManagerCreating Logical Foreign Key Joins with the Joins Manager9-99-10Specifying a Driving Table9-11Factors That Determine Join Trimming9-12Identifying Physical Tables That Map to Logical Objects9-15Creating and Managing Logical Columns9-15Creating Logical Columns9-16Basing the Sort for a Logical Column on a Different Column9-16Enabling Double Column Support by Assigning a Descriptor ID Column9-17Creating Derived Columns9-17Configuring Logical Columns for Multicurrency SupportSetting Default Levels of Aggregation for Measure Columns9-189-19Setting Up Dimension-Specific Aggregate Rules for Logical Columns9-20Specifying Dimension-Specific Aggregation Rules for Multiple Logical Columns9-21Defining Aggregation Rules for Multidimensional Data Sources9-22Associating an Attribute with a Logical Level in Dimension Tables9-24Moving or Copying Logical Columns9-24Enabling Write Back On Columns9-25Setting Up Display Folders in the Business Model and Mapping Layer9-27xi
Modeling Bridge Tables9-28Creating Joins in the Physical Layer for Bridge and Associated Dimension Tables9-29Modeling the Associated Dimension Tables in a Single Dimension9-29Modeling the Associated Dimension Tables in Separate Dimensions9-30Modeling Binary Large Object (BLOB) Data and Character Large Object (CLOB) Data109-30Working with Logical DimensionsAbout Working with Logical Dimensions10-1Creating and Managing Dimensions with Level-Based Hierarchies10-2About Level-Based Hierarchies10-2About Using Dimension Hierarchy Levels in Level-Based Hierarchies10-5Manually Creating Dimensions, Levels, and Keys with Level-Based Hierarchies10-6Creating Dimensions in Level-Based Hierarchies10-6Creating Logical Levels in a Dimension10-7Associating a Logical Column and Its Table with a Dimension Level10-8Identifying the Primary Key for a Dimension Level10-11Selecting and Sorting Chronological Keys in a Time Dimension10-12Adding a Dimension Level to the Preferred Drill Path10-13Adding Sequence Numbers to a Time Dimension's Logical Level10-13Rules for Automatically Created Dimensions with Level-Based Hierarchies10-13Automatically Creating Dimensions with Level-Based Hierarchies10-15Populating Logical Level Counts Automatically10-15Creating and Managing Dimensions with Parent-Child Hierarchies10-16About Parent-Child Hierarchies10-16About Levels and Distances in Parent-Child Hierarchies10-17About Parent-Child Relationship Tables10-18Creating Dimensions with Parent-Child Hierarchies10-19Defining Parent-Child Relationship Tables10-20Modeling Aggregates for Parent-Child Hierarchies10-21Storing Facts for Parent-Child Hierarchies10-21Aggregating Parent-Child Hierarchies10-23Adding the Parent-Child Relationship Table to the Model10-25Maintaining Parent-Child Hierarchies Based on Relational Tables10-25Modeling Time Series Data10-25About Time Series Functions10-26About the AGO Function10-27About the TODATE Function10-28About the PERIODROLLING Function10-29Creating Logical Time Dimensions10-30Selecting the Time Option in the Logical Dimension Dialog10-30xii
Setting Chronological Keys for Each LevelCreating AGO, TODATE, and PERIODROLLING Measures1110-32Managing Logical Table Sources (Mappings)About Logical Table Sources11-1How Fact Logical Table Sources Are Selected to Answer a Query11-1How Dimension Logical Table Sources Are Selected to Answer a Query11-2Changing the Default Selection Criteria for Dimension Logical Table SourcesConsistency Among Data in Multiple Sources11-211-3Creating Logical Table Sources11-3Setting Priority Group Numbers for Logical Table Sources11-4Defining Physical to Logical Table Source Mappings and Creating Calculated Items11-7Unmapping a Logical Column from Its SourceDefining Content of Logical Table Sources11-911-9Verifying Joins from Dimension Tables to Fact Tables11-10Joins from Dimension Tables to Fact Tables11-11Logical Table Source Options Reference11-12About WHERE Clause Filters11-13About Working with Parent-Child Settings in the Logical Table Source11-14Setting Up Aggregate Navigation by Creating Sources for Aggregated Fact Data11-14Setting Up Fragmentation Content for Aggregate Navigation11-15Specifying Fragmentation Content for Single Column, Value-Based Predicates11-15Specifying Fragmentation Content for Single Column, Range-Based Predicates11-16Specifying Multicolumn Content Descriptions11-17Specifying Parallel Content Descriptions11-17Specifying Unbalanced Parallel Content Descriptions11-19Specifying Fragmentation Content for Aggregate Table Fragments1210-3111-19Specifying the Aggregate Table Content11-21Defining a Physical Layer Table with a Select Statement to Complete the Domain11-21Specifying the SQL Virtual Table Content11-21Creating Physical Joins for the Virtual Table11-22Creating and Maintaining the Presentation LayerAbout the Presentation Layer12-1Creating and Customizing the Presentation Layer12-2About Creating Subject AreasAutomatically Creating Subject Areas Based on Logical Stars and Snowflakes12-212-3About Removing Columns12-4Renaming Presentation Columns to User-Friendly Names12-5xiii
Exporting Logical Keys in the Subject Area12-5Setting an Implicit Fact Column in the Subject Area12-5Maintaining the Presentation Layer12-6Working with Subject Areas12-6Working with Presentation Tables and Columns12-8Creating and Managing Presentation Tables12-8Reordering Presentation Layer Tables12-9About Presentation Columns12-9Changing the Presentation Column Name12-10Reordering Presentation Columns12-10Nesting Folders in Answers and BI Composer12-10Working with Presentation Hierarchies and Levels12-11Creating and Managing Presentation Hierarchies1312-12Modeling Dimensions with Multiple Hierarchies in the Presentation Layer12-13Editing Presentation Hierarchy Objects12-15Creating and Managing Presentation Levels12-16Setting Permissions for Presentation Layer Objects12-17Generating a Permission Report for Presentation Layer Objects12-18Sorting Columns in the Permissions Dialog12-18Creating Aliases (Synonyms) for Presentation Layer Objects12-19Controlling Presentation Object Visibility12-19Creating and Persisting Aggregates for Oracle BI Server QueriesAbout Aggregate Persistence in Oracle Business Intelligence13-1Aggregate Persistence Improvements13-2About Aggregate Persistence Errors13-3Identifying Query Candidates for Aggregation13-4Using Oracle BI Summary Advisor to Identify Query Candidates for Aggregation13-5About Oracle BI Summary Advisor13-5Gathering Summary Advisor Statistics13-5Generating and Using Summary Advisor Recommendations13-6About Measure Subset Recommendations13-6Setting Up the Statistics Database13-7Columns in the S NQ SUMMARY ADVISOR Table13-7Turning On Usage Tracking13-8Turning On Summary Advisor Logging13-8Generating an Aggregate Specification Script13-9Summary Advisor Stop Criteria Run Constraints13-11Using the nqaggradvisor Utility to Run the Oracle BI Summary Advisor13-12Using the Aggregate Persistence Wizard to Generate the Aggregate Specification13-14xiv
Using Model Check Manager to Check for Modeling ProblemsAbout Model Check Manager13-16Running Model Check Manager13-17Resolving Model Errors13-18Checking Models Using the validaterpd Utility13-18Writing the Create Aggregates Specification Manually13-19What Constraints Are Imposed During the Create Process?13-20Writing the Create Aggregates Specification13-21Delete Statement for Aggregate Specification13-21Create Statement for Aggregate Specification13-21Multiple Aggregates in Aggregate Specification13-22Where Clause for Aggregate Specification13-22Adding Surrogate Keys to Dimension Aggregate Tables1413-1613-23About the Create/Prepare Aggregates Syntax13-24About Surrogate Key Output from Create/Prepare Aggregates13-24Running the Aggregate Specification Script13-25Life Cycle Use Cases for Aggregate Persistence13-26Using Double Buffering to Refresh Highly Available Aggregates13-28Creating Aggregates on TimesTen Sources13-29Enabling PL/SQL for TimesTen13-30Enabling Performance Enhancement Features for TimesTen13-30Applying Data Access Security to Repository ObjectsAbout Data Access SecurityWhere to Find Information About Security TasksRow-Level Security14-214-214-3Setting Up Row-Level Security14-4Data Filters14-5Setting Up Data Filters in the Repository14-6Specifying a Functional Group for an Application RoleSetting Up Row-Level Security in the DatabaseObject PermissionsSetting Up Object PermissionsAbout Permission Inheritance for Users and Application Roles14-714-814-914-1014-11Overview of User and Application Role Commands14-13Rename Application Role Command14-13Delete Application Role Command14-15Rename Users Command14-17Delete Users Command14-18Setting Query Limits14-20xv
Accessing the Query Limits Functionality in the Administration Tool14-20Limiting Queries By the Number of Rows Received14-21Limiting Queries By Maximum Run Time and Restricting to Particular Time Periods14-21Allowing or Disallowing Direct Database Requests14-22Allowing or Disallowing the Populate Privilege14-23About Applying Data Access Security in Offline Mode14-23Setting Up Placeholder Application Roles for Offline Repository Development1514-23Completing Oracle BI Repository SetupConfiguring the Repository for Oracle Scorecard and Strategy Management15-1Configuring the Repository for Comments and Status Overrides15-2Saving the Repository and Checking Consistency15-3Using nqcmd to Test and Refine the Repository15-4nqcmd Command Line Arguments1615-4Upload Repository Command15-6Making the Repository Available for Queries15-8Creating Data Source Connections to the Oracle BI Server for Client Applications15-8Publishing to the User Community15-8Setting Up Data Sources on Linux and UNIXAbout Setting Up Data Sources on Linux and UNIX16-1Settings for Data Source Connections Using Native Gateways16-2Sample obis.properties Entries for Oracle Database and DB2 (32-Bit)16-3Configuring Data Source Connections Using Native Gateways16-5About Updating Row Counts in Native Databases16-5Troubleshooting OCI Connections16-6Using DataDirect Connect ODBC Drivers on Linux and UNIX16-7Configuring Oracle Business Intelligence to Use DataDirect16-7Additional DataDirect Configuration for Oracle Essbase16-7Configuring the DataDirect Connect ODBC Driver for Microsoft SQL Server Database16-8Configuring the DataDire
Obtaining Windows ODBC Driver for Cloudera 5-11 Importing Cloudera Impala Metadata Using the Windows ODBC Driver 5-11 About Setting Up Apache Hive Data Sources 5-12 Obtaining Windows ODBC Driver for Client Installation 5-12 vi. Limitations on the Use of Apache Hive with Oracle Business Intelligence 5-12
1 Introduction to Oracle Fusion Middleware Disaster Recovery 1.1 Overview of Oracle Fusion Middleware Disaster Recovery 1-1 1.1.1 Problem Description and Common Solutions 1-1 1.1.2 Terminology 1-2 1.2 Setting Up Disaster Recovery for Oracle Fusion Middleware Components 1-5 1.2.1 Oracle Fusion Middleware Disaster Recovery Architecture Overview 1-5
7 Accessibility Features and Tips for Oracle Forms and Reports . that Oracle has developed for Oracle Fusion Middleware products and services. . Mode in Developing Services with Oracle Service Bus For information about enabling Fusion Middleware Control accessibility mode, see: .
new open source WebLogic Remote Console, enhancements to Kubernetes tooling and support, Oracle Java SE 8 and 11 certification, GraalVM EE certification, and improvements to Oracle Database integration. The next planned release of Oracle Fusion Middleware is Oracle Fusion Middleware 14.1.2,
Explains how to install and deinstall Oracle Business Intelligence products (including Oracle BI Enterprise Edition, Oracle BI Publisher, and Oracle Real-Time Decisions). Includes a description for each screen. Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence, 11g Release 1 (11.1.1)
The way we see it, Oracle Fusion HCM is much more than an upgrade to a smarter technology. It is a key that can unlock barriers to transforming your organization. With our Oracle Fusion Middleware expertise alongside our Oracle Fusion Applications experience, we believe this can be a catalyst to change. As part of Oracle’s plainly-
deploying Oracle Forms applications on the Web. Oracle Fusion Middleware Forms Services delivers out-of-the-box functionality and native services to ensure that Oracle Forms applications automatically scale and perform over any network. Oracle Fusion Middleware Forms Services enables rich, extensible Java clients that are optimized for the Web.File Size: 635KBPage Count: 18
A Configuring Oracle Managed File Transfer in a Compact Domain B Secondary Topology for Oracle Managed File Transfer Oracle Managed File Transfer and SOA Suite Topology B-1 C Updating the JDK After Installing and Configuring an Oracle Fusion Middleware Product About Updating the JDK Location After Installing an Oracle Fusion Middleware
Oracle Fusion Middleware Oracle WebCenter Forms Recognition AP Project Migration Guide Oracle WebCenter Content: Imaging Oracle Fusion Middleware Administering Oracle WebCenter Content: Imaging Conventions The following text conventions are used in this document: Convention Meaning
