Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

New Features for Oracle BI Metadata Repository Builders

• New Features
• Upgrade Considerations

1 Introduction to Building Your Metadata Repository

• About Oracle BI Server and Oracle BI Repository Architecture
  • About Oracle BI Server Architecture
  • About Layers in the Oracle BI Repository
• Planning Your Business Model
  • Analyzing Your Business Model Requirements
  • Identifying the Content of the Business Model
    • Identifying Logical Fact Tables
    • Identifying Logical Dimension Tables
    • Identifying Dimensions
    • Identifying Lookup Tables
• Identifying the Data Source Content for the Physical Layer
  • About Types of Physical Schemas in Relational Data Sources
  • About Cubes in Multidimensional Data Sources
  • Identifying the Data Source Table Structure
• Guidelines for Designing a Repository
  • General Tips for Working on the Repository
  • Design Tips for the Physical Layer
  • Design Tips for the Business Model and Mapping Layer
    • Modeling Outer Joins
  • Design Tips for the Presentation Layer
• Topics of Interest in Other Guides
• System Requirements and Certification

2 Before You Begin

• About the Oracle BI Administration Tool
  • Opening the Administration Tool
  • About the Administration Tool Main Window
  • Setting Preferences
  • About Administration Tool Menus
    • File Menu
    • Edit Menu
    • View Menu
    • Manage Menu
    • Tools Menu
    • Actions Menu
    • Window Menu
    • Help Menu
  • Editing, Deleting, and Reordering Objects in the Repository
  • Using the Browse Dialog to Browse for Objects
  • Changing Icons for Repository Objects
  • Sorting Objects in the Administration Tool
  • About Features and Options for Oracle Marketing Segmentation
• About the Oracle BI Server Command-Line Utilities
  • Running bi-init to Launch a Shell Window Initialized to Your Oracle Instance
• About Options in Fusion Middleware Control and NQSConfig.INI
• About the SampleApp.rpd Demonstration Repository
• Using Online and Offline Repository Modes
  • Opening a Repository in Offline Mode
  • Opening a Repository in Online Mode
    • Guidelines for Using Online Mode
  • Checking Out Objects
  • Checking In Changes
  • About Read-Only Mode
• Checking the Consistency of a Repository or a Business Model
  • About the Consistency Check Manager
  • Checking the Consistency of Repository Objects

3 Setting Up and Using the Multiuser Development Environment

• About the Multiuser Development Environment
  • About the Multiuser Development Process
• Setting Up Projects
  • About Projects
    • About the Project Dialog
  • Creating Projects
  • About Converting Older Projects During Repository Upgrade
• Setting Up the Multiuser Development Directory
  • Identifying the Multiuser Development Directory
  • Copying the Master Repository to the Multiuser Development Directory
  • Setting Up a Pointer to the Multiuser Development Directory
• Making Changes in a Multiuser Development Environment
  • Checking Out Repository Projects
    • About Repository Project Checkout
    • Checking Out Projects
    • Using the extractprojects Utility to Extract Projects
  • About Changing and Testing Metadata
  • About Multiuser Development Menu Options
    • About Closing a Repository Before Publishing It to the Network
• Checking In Multiuser Development Repository Projects
  • About the Multiuser Development Merge Process
    • How are Multiuser Merges Different from Standard Repository Merges?
  • Checking In Projects
  • Tracking Changes to the Master Repository
• Branching in Multiuser Development
  • About Branching
  • Using the Multi-Team, Multi-Release Model in Oracle Business Intelligence
  • Synchronizing RPD Branches
• Viewing and Deleting History for Multiuser Development
  • Viewing Multiuser Development History
  • Deleting Multiuser Development History
• Setting Multiuser Development Options

4 Importing Metadata and Working with Data Sources

• Creating New Oracle BI Repository Files
• Performing Data Source Preconfiguration Tasks
  • Setting Up ODBC Data Source Names (DSNs)
  • Setting Up Oracle Database Data Sources
  • Setting Up Essbase Data Sources
    • Updating Essbase Information in opmn.xml
    • Adding Essbase Information to bi-init.cmd
  • Setting Up Hyperion Financial Management Data Sources
  • Setting Up Oracle RPAS Data Sources
• Importing Metadata from Relational Data Sources
  • About Importing Metadata from Oracle RPAS Data Sources
• Importing Metadata from Multidimensional Data Sources
• Importing Metadata from XML Data Sources
  • About Using XML as a Data Source
  • Importing Metadata from XML Data Sources Using the XML Gateway
    • Examples of XML Documents Generated by the Oracle BI Server XML Gateway
    • Accessing HTML Tables
  • Importing Metadata from XML Data Sources Using XML ODBC
    • Example of an XML ODBC Data Source
  • Examples of XML Documents
• Using a Standby Database with Oracle Business Intelligence
  • About Using a Standby Database with Oracle Business Intelligence
  • Creating the Database Object for the Standby Database Configuration
  • Creating Connection Pools for the Standby Database Configuration
  • Updating Write-Back Scripts in a Standby Database Configuration
  • Setting Up Usage Tracking in a Standby Database Configuration
  • Setting Up Event Polling in a Standby Database Configuration
  • Setting Up Oracle BI Scheduler in a Standby Database Configuration

5 Working with ADF Business Component Data Sources

• What Are ADF Business Components?
  • About Operational Reporting with ADF Business Components
• What Happens During Import?
• About Specifying a SQL Bypass Database
• Setting Up ADF Business Component Data Sources
  • Creating a WebLogic Domain
  • Deploying OBIEEBroker as a Shared Library in Oracle WebLogic Server
  • Deploying the Application EAR File to Oracle WebLogic Server from JDeveloper
  • Setting Up a JDBC Data Source in the WebLogic Server
  • Setting the Logging Level for the Deployed Application in Oracle WebLogic Server
• Importing Metadata from ADF Business Component Data Sources
• Enabling the Ability to Pass Custom Parameters to the ADF Application

6 Setting Up Database Objects and Connection Pools

• Setting Up Database Objects
  • About Database Types in the Physical Layer
  • Creating a Database Object Manually in the Physical Layer
    • When to Allow Direct Database Requests by Default
  • Specifying SQL Features Supported by a Data Source
• About Connection Pools
  • About Connection Pools for Initialization Blocks
• Creating or Changing Connection Pools
  • Setting Connection Pool Properties in the General Tab
    • Common Connection Pool Properties on the General Tab
    • Multidimensional Connection Pool Properties on the General Tab
  • Setting Connection Pool Properties in the Connection Scripts Tab
  • Setting Connection Pool Properties in the XML Tab
  • Setting Connection Pool Properties in the Write Back Tab
  • Setting Connection Pool Properties in the Miscellaneous Tab
• Setting Up Persist Connection Pools
  • About Setting the Buffer Size and Transaction Boundary

7 Working with Physical Tables, Cubes, and Joins

• Working with the Physical Diagram
• Creating Physical Layer Folders
  • Creating Physical Layer Catalogs and Schemas
    • Creating Catalogs
    • Creating Schemas
  • Using a Variable to Specify the Name of a Catalog or Schema
  • Setting Up Display Folders in the Physical Layer
• Working with Physical Tables
  • About Physical Tables
    • About Physical Cube Tables
  • About Physical Alias Tables
  • Creating and Managing Physical Tables
    • Creating or Editing Physical Tables
    • Creating Alias Tables
  • Creating and Managing Columns and Keys for Physical Tables
    • About Measures in Multidimensional Data Sources
    • Creating and Editing a Column in a Physical Table
    • Specifying a Primary Key for a Physical Table
    • Deleting Physical Columns for All Data Sources
  • Setting Physical Table Properties for XML Data Sources
  • Working with Cube Variables for SAP/BW Data Sources
  • Viewing Data in Physical Tables or Columns
• Working with Essbase Data Sources
  • About Using Essbase Data Sources with Oracle Business Intelligence
    • About Incremental Import
  • Working with Essbase Alias Tables
    • Determining the Value to Use for Display
    • Explicitly Defining Columns for Each Alias
  • Modeling User-Defined Attributes
  • Associating Member Attributes to Dimensions and Levels
  • Modeling Alternate Hierarchies
  • Modeling Measure Hierarchies
  • Improving Performance by Using Unqualified Member Names
• Working with Hyperion Financial Management Data Sources
  • About Query Support for Hyperion Financial Management Data Sources
• Working with Dimensions and Hierarchies in the Physical Layer
  • Working with Physical Dimension Objects
  • Working with Physical Hierarchy Objects
  • Viewing Members in Physical Cube Tables
  • Adding or Removing Cube Columns in a Hierarchy
• Working with Physical Foreign Keys and Joins
  • About Physical Joins
    • About Primary Key and Foreign Key Relationships
    • About Complex Joins
    • About Multi-Database Joins
    • About Fragmented Data
  • Defining Physical Joins with the Physical Diagram
  • Defining Physical Joins with the Joins Manager
• Deploying Opaque Views
  • About Deploying Opaque Views
  • Deploying Opaque View Objects
    • Using the Create View SELECT Statement
  • Undeploying a Deployed View
  • When to Delete Opaque Views or Deployed Views
  • When to Redeploy Opaque Views
• Using Hints
  • How to Use Oracle Hints
    • About the Index Hint
    • About the Leading Hint
  • About Performance Considerations for Hints
  • Creating Hints
• Displaying and Updating Row Counts for Physical Tables and Columns

8 Working with Logical Tables, Joins, and Columns

• Creating the Business Model and Mapping Layer
  • Creating Business Models
  • Automatically Creating Business Model Objects
    • Automatically Creating Business Model Objects for Multidimensional Data Sources
  • Duplicating a Business Model and Subject Area
• Working with the Business Model Diagram
• Creating and Managing Logical Tables
  • Creating Logical Tables
    • Creating and Managing Logical Table Sources
  • Specifying a Primary Key in a Logical Table
  • Reviewing Foreign Keys for a Logical Table
• Defining Logical Joins
  • Defining Logical Joins with the Business Model Diagram
  • Defining Logical Joins with the Joins Manager
    • Creating Logical Joins with the Joins Manager
    • Creating Logical Foreign Key Joins with the Joins Manager
  • Specifying a Driving Table
  • Identifying Physical Tables That Map to Logical Objects
• Creating and Managing Logical Columns
  • Creating Logical Columns
  • Basing the Sort for a Logical Column on a Different Column
  • Assigning a Descriptor ID Column to a Logical Column
  • Creating Derived Columns
    • Configuring Logical Columns for Multicurrency Support
  • Setting Default Levels of Aggregation for Measure Columns
    • Setting Up Dimension-Specific Aggregate Rules for Logical Columns
    • Defining Aggregation Rules for Essbase and Other Multidimensional Data Sources
  • Associating an Attribute with a Logical Level in Dimension Tables
  • Moving or Copying Logical Columns
• Enabling Write Back On Columns
• Setting Up Display Folders in the Business Model and Mapping Layer
• Modeling Bridge Tables
  • Creating Joins in the Physical Layer for Bridge and Associated Dimension Tables
  • Modeling the Associated Dimension Tables in a Single Dimension
  • Modeling the Associated Dimension Tables in Separate Dimensions

9 Working with Logical Dimensions

• Creating and Managing Dimensions with Level-Based Hierarchies
  • About Level-Based Hierarchies
    • Using Dimension Hierarchy Levels in Level-Based Hierarchies
  • Manually Creating Dimensions, Levels, and Keys with Level-Based Hierarchies
    • Creating Dimensions in Level-Based Hierarchies
    • Creating Logical Levels in a Dimension
    • Associating a Logical Column and Its Table with a Dimension Level
    • Identifying the Primary Key for a Dimension Level
    • Selecting and Sorting Chronological Keys in a Time Dimension
    • Adding a Dimension Level to the Preferred Drill Path
  • Automatically Creating Dimensions with Level-Based Hierarchies
  • Populating Logical Level Counts Automatically
• Creating and Managing Dimensions with Parent-Child Hierarchies
  • About Parent-Child Hierarchies
    • About Levels and Distances in Parent-Child Hierarchies
    • About Parent-Child Relationship Tables
  • Creating Dimensions with Parent-Child Hierarchies
  • Defining Parent-Child Relationship Tables
    • Adding the Parent-Child Relationship Table to the Model
    • Maintaining Parent-Child Hierarchies Based on Relational Tables
• Modeling Time Series Data
  • About Time Series Functions
    • About the AGO Function
    • About the TODATE Function
    • About the PERIODROLLING Function
  • Creating Logical Time Dimensions
    • Selecting the Time Option in the Logical Dimension Dialog
    • Setting Chronological Keys for Each Level
  • Creating AGO, TODATE, and PERIODROLLING Measures

10 Managing Logical Table Sources (Mappings)

• Creating Logical Table Sources
  • Setting Priority Group Numbers for Logical Table Sources
• Defining Physical to Logical Table Source Mappings and Creating Calculated Items
  • Unmapping a Logical Column from Its Source
• Defining Content of Logical Table Sources
  • Verifying that Joins Exist from Dimension Tables to Fact Table
  • About WHERE Clause Filters
• Working with Parent-Child Settings in the Logical Table Source
• Setting Up Aggregate Navigation by Creating Sources for Aggregated Fact Data
• Setting Up Fragmentation Content for Aggregate Navigation
  • Specifying Fragmentation Content for Single Column, Value-Based Predicates
  • Specifying Fragmentation Content for Single Column, Range-Based Predicates
    • Specifying Multicolumn Content Descriptions
    • Specifying Parallel Content Descriptions
    • Specifying Unbalanced Parallel Content Descriptions
  • Specifying Fragmentation Content for Aggregate Table Fragments
    • Specifying the Aggregate Table Content
    • Defining a Physical Layer Table with a Select Statement to Complete the Domain
    • Specifying the SQL Virtual Table Content
    • Creating Physical Joins for the Virtual Table

11 Creating and Maintaining the Presentation Layer

• Creating and Customizing the Presentation Layer
  • Creating Subject Areas
    • Automatically Creating Subject Areas Based on Logical Stars and Snowflakes
  • Removing Any Unneeded or Unwanted Columns
  • Renaming Presentation Columns to User-Friendly Names
  • Exporting Logical Keys in the Subject Area
  • Setting an Implicit Fact Column in the Subject Area
  • Maintaining the Presentation Layer
• Working with Subject Areas
• Working with Presentation Tables and Columns
  • Creating and Managing Presentation Tables
    • Nesting Folders in Answers
  • Creating and Managing Presentation Columns
• Working with Presentation Hierarchies and Levels
  • Creating and Managing Presentation Hierarchies
    • Modeling Dimensions with Multiple Hierarchies in the Presentation Layer
    • Editing Presentation Hierarchy Objects
  • Creating and Managing Presentation Levels
• Setting Permissions for Presentation Layer Objects
  • Generating a Permission Report for Presentation Layer Objects
  • Sorting Columns in the Permissions Dialog
• Creating Aliases (Synonyms) for Presentation Layer Objects

12 Creating and Persisting Aggregates for Oracle BI Server Queries

• About Aggregate Persistence in Oracle Business Intelligence
• Identifying Query Candidates for Aggregation
• Using the Aggregate Persistence Wizard to Generate the Aggregate Specification
• Writing the Create Aggregates Specification Manually
  • What Constraints Are Imposed During the Create Process?
  • How to Write the Create Aggregates Specification
  • Adding Surrogate Keys to Dimension Aggregate Tables
    • About the Create/Prepare Aggregates Syntax
    • About Surrogate Key Output from Create/Prepare Aggregates
• Running the Aggregate Specification Against the Oracle BI Server
• Troubleshooting Aggregate Persistence

13 Applying Data Access Security to Repository Objects

• About Data Access Security
  • Where Do I Find Information About Security Tasks?
• Setting Up Row-Level Security
  • Setting Up Row-Level Security (Data Filters) in the Repository
  • Setting Up Row-Level Security in the Database
• Setting Up Object Permissions
  • About Permission Inheritance for Users and Application Roles
• Setting Query Limits
  • Accessing the Query Limits Functionality in the Administration Tool
  • Limiting Queries By the Number of Rows Received
  • Limiting Queries By Maximum Run Time and Restricting to Particular Time Periods
  • Allowing or Disallowing Direct Database Requests
  • Allowing or Disallowing the Populate Privilege
• About Applying Data Access Security in Offline Mode
  • Setting Up Placeholder Application Roles for Offline Repository Development

14 Completing Oracle BI Repository Setup

• Saving the Repository and Checking Consistency
• Testing and Refining the Repository
  • Using nqcmd to Run Sample Queries
  • Using NQClient to Run Sample Queries
• Making the Repository Available for Queries
• Creating Data Source Connections to the Oracle BI Server for Client Applications
• Publishing to the User Community

15 Setting Up Data Sources on Linux and UNIX

• About Setting Up Data Sources on Linux or UNIX
• Configuring Data Source Connections Using Native Gateways
  • Troubleshooting OCI Connections
  • About Updating Row Counts in Native Databases
• Using DataDirect Connect ODBC Drivers on Linux and UNIX
  • Configuring the DataDirect Connect ODBC Driver for Microsoft SQL Server Database
  • Configuring the DataDirect Connect ODBC Driver for Sybase ASE Database
  • Configuring the DataDirect Connect ODBC Driver for Informix Database
• Configuring Database Connections Using Native ODBC Drivers
• Configuring Oracle RPAS ODBC Data Sources on AIX UNIX
• Configuring Essbase Data Sources on Linux
• Configuring DB2 Connect on IBM z/OS and s/390 Platforms

16 Managing Oracle BI Repository Files

• Comparing Repositories
  • Turning Off Compare Mode
• Equalizing Objects
  • About Equalizing Objects
  • Using the Equalize Objects Dialog
  • Using the equalizerpds Utility
• Merging Repositories
  • Performing Full Repository Merges
    • About Full Repository Merges
    • Performing Full Repository Merges With a Common Parent
    • Performing Full Repository Merges Without a Common Parent
  • Performing Patch Merges
    • About Patch Merges
    • Generating a Repository Patch
    • Applying a Repository Patch
• Querying and Managing Repository Metadata
  • Querying the Repository
    • Constructing a Filter for Query Results
  • Querying Related Objects
• Changing the Repository Password

17 Using Expression Builder and Other Utilities

• Using Expression Builder
  • About the Expression Builder Dialogs
  • About the Expression Builder Toolbar
  • About the Categories in the Category Pane
  • Setting Up an Expression
    • Navigating Within Expression Builder
    • Building an Expression
    • About the INDEXCOL Conversion Function
• Using Administration Tool Utilities
  • Using the Replace Column or Table Wizard
  • Using the Oracle BI Event Tables Utility
  • Using the Externalize Strings Utility
  • Using the Rename Wizard
  • Using the Update Physical Layer Wizard
  • Generating Documentation of Repository Mappings
  • Generating a Metadata Dictionary
  • Removing Unused Physical Objects
  • Persisting Aggregates
• Using the Calculation Wizard

18 Using Variables in the Oracle BI Repository

• About Repository Variables
  • About Static Repository Variables
  • About Dynamic Repository Variables
• Creating Repository Variables
  • Using Repository Variables in Expression Builder
• About Session Variables
  • About System Session Variables
  • About Nonsystem Session Variables
• Creating Session Variables
• Working with Initialization Blocks
  • About Using Initialization Blocks with Variables
    • Initializing Dynamic Repository Variables
    • Initializing Session Variables
    • About Row-Wise Initialization
  • Creating Initialization Blocks
    • Assigning a Name and Schedule to Initialization Blocks
    • Selecting and Testing the Data Source and Connection Pool
  • Associating Variables with Initialization Blocks
  • Establishing Execution Precedence
  • When Execution of Session Variable Initialization Blocks Cannot Be Deferred
  • Enabling and Disabling Initialization Blocks

A Managing the Repository Lifecycle in a Multiuser Development Environment

• Planning Your Multiuser Development Deployment
  • About Business Organization and Governance Process Best Practices
  • About Technical Team Roles and Responsibilities
• Multiuser Development Architecture
  • About Multiuser Development Concepts
  • About Multiuser Development Styles
  • Multiuser Development Sandbox Architecture
  • Multiuser Development and Lifecycle Management Architecture
• Understanding the Multiuser Development Environment
  • About Multiuser Development Environment Task Flow
  • About Multiuser Development Projects
  • How to Create Branches
    • How to Create a Main Branch
    • How to Create a Side Branch
    • How to Create a Delegated Administration Branch
  • Which Merge Utility Should I Use?
• MUD Tips and Best Practices
  • Best Practices for Branching
  • Best Practices for Setting Up Projects
  • Best Practices for Three-Way Merges
  • Best Practices for MUD Merges
  • Best Practices for Two-Way Merges
  • Best Practices for Production Migration
  • Best Practices for Application Roles and Users
• Troubleshooting Multiuser Development

B MUD Case Study: Eden Corporation

• About the Eden Corporation Fictional Case Study
• Phase I - Initiating Multiuser Development (MUD)
  • Starting Initiative S
  • Setting Up MUD Projects
  • First Developer Checks Out
  • Second Developer Checks Out
  • First Developer Checks In
  • Second Developer Checks In
  • MUD Administrator Test Migration Activities
  • Phase I Testing
  • Phase I Migration to Production
  • Phase I Summary
• Phase II - Branching, Fixing, and Patching
  • Setting Up the Second Branch
  • Developers Check Out Projects
  • Patch Fix for the Main Branch
  • Finishing and Merging Phase II Branch
  • Phase II Summary
• Phase III - Independent Semantic Model Development
  • Security Considerations for Multiple Independent Semantic Models
  • Sales Semantic Model Developers Check Out
  • HR Semantic Model Developer Builds Content
  • Phase III Summary

C Logical SQL Reference

• SQL Syntax and Semantics
  • Syntax and Usage Notes for the SELECT Statement
    • Basic Syntax for the SELECT Statement
    • Usage Notes
    • Subquery Support
    • SELECT List Syntax
    • FROM Clause Syntax
    • WHERE Clause Syntax
    • GROUP BY Clause Syntax
    • ORDER BY Clause Syntax
  • Syntax and Usage Notes for SELECT_PHYSICAL
    • Syntax for the SELECT_PHYSICAL Statement
    • Aggregate Functions Not Supported in SELECT_PHYSICAL Queries
    • Queries Supported by SELECT_PHYSICAL
    • Using the NATURAL_JOIN Keyword
    • Special Usages of SELECT_PHYSICAL
  • Rules for Queries with Aggregate Functions
    • Computing Aggregates of Baseline Columns
    • Computing Aggregates of Measure Columns
    • Display Function Reset Behavior
    • Alternative Syntax
    • Using FILTER to Compute a Conditional Aggregate
  • Operators
    • SQL Logical Operators
    • Mathematical Operators
  • Conditional Expressions
    • CASE (Switch)
    • CASE (If)
  • Expressing Literals
    • Character Literals
    • Datetime Literals
    • Numeric Literals
  • Calculated Members
    • CALCULATEDMEMBER Syntax
    • Rules for the CALCULATEDMEMBER Expression
    • Using Solve Order to Control Formula Evaluation Sequence
    • Examples of Calculated Members in Queries
  • Variables
• Aggregate and Running Aggregate Functions
  • Aggregate Functions
    • AGGREGATE AT
    • AVG
    • AVGDISTINCT
    • BOTTOMN
    • COUNT
    • COUNTDISTINCT
    • COUNT(*)
    • FIRST
    • GROUPBYCOLUMN
    • GROUPBYLEVEL
    • LAST
    • MAX
    • MEDIAN
    • MIN
    • NTILE
    • PERCENTILE
    • RANK
    • STDDEV
    • STDDEV_POP
    • SUM
    • SUMDISTINCT
    • TOPN
  • Running Aggregate Functions
    • MAVG
    • MSUM
    • RSUM
    • RCOUNT
    • RMAX
    • RMIN
  • Time Series Functions
    • AGO
    • PERIODROLLING
    • TODATE
• String Functions
  • ASCII
  • BIT_LENGTH
  • CHAR
  • CHAR_LENGTH
  • CONCAT
  • INSERT
  • LEFT
  • LENGTH
  • LOCATE
  • LOCATEN
  • LOWER
  • OCTET_LENGTH
  • POSITION
  • REPEAT
  • REPLACE
  • RIGHT
  • SPACE
  • SUBSTRING
  • TRIMBOTH
  • TRIMLEADING
  • TRIMTRAILING
  • UPPER
• Math Functions
  • ABS
  • ACOS
  • ASIN
  • ATAN
  • ATAN2
  • CEILING
  • COS
  • COT
  • DEGREES
  • EXP
  • EXTRACTBIT
  • FLOOR
  • LOG
  • LOG10
  • MOD
  • PI
  • POWER
  • RADIANs
  • RAND
  • RANDFROMSEED
  • ROUND
  • SIGN
  • SIN
  • SQRT
  • TAN
  • TRUNCATE
• Calendar Date/Time Functions
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • DAY_OF_QUARTER
  • DAYNAME
  • DAYOFMONTH
  • DAYOFWEEK
  • DAYOFYEAR
  • HOUR
  • MINUTE
  • MONTH
  • MONTH_OF_QUARTER
  • MONTHNAME
  • NOW
  • QUARTER_OF_YEAR
  • SECOND
  • TIMESTAMPADD
  • TIMESTAMPDIFF
  • WEEK_OF_QUARTER
  • WEEK_OF_YEAR
  • YEAR
• Conversion Functions
  • CAST
  • CHOOSE
  • IFNULL
  • INDEXCOL
    • Example With Hierarchy Levels
  • TO_DATETIME
  • VALUEOF
• Database Functions
  • EVALUATE
  • EVALUATE_ANALYTIC
  • EVALUATE_AGGR
  • EVALUATE_PREDICATE
• Hierarchy Navigation Functions
  • ISANCESTOR
  • ISCHILD
  • ISDESCENDANT
  • ISLEAF
  • ISPARENT
  • ISROOT
• System Functions
  • USER
  • DATABASE

D Merge Rules

• General Merge Rules and Behavior
• Special Merge Algorithms for Logical Table Sources and Other Objects
  • Merging Objects that Use the Vector Merge Algorithm
  • Merging Logical Table Sources
  • Merging Security Filters
  • Inferring the Use Logical Column Property for Presentation Columns
  • Merging Aliases

E Deleting Unwanted Objects from the Repository

• About the Object Pruning Utility
• Using the Object Pruning Utility
  • Creating the Input File
  • Running the Prune Utility
    • Log File
    • Error Log File
• Deletion Rules for the Object Pruning Utility

F Administration Tool Keyboard Shortcuts

Glossary

Index