Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Conventions

New Features for Oracle Business Intelligence Users

• New Features for Oracle BI EE 12c Release 1 (12.2.1)

Introducing Oracle Business Intelligence Enterprise Edition

• Introduction to Oracle BI Enterprise Edition
• Where Do I Store and Manage Oracle BI EE Objects?
• Signing In to Oracle BI Enterprise Edition
• Signing Out of Oracle BI Enterprise Edition
• Navigating Oracle BI Enterprise Edition
• What Is the Oracle BI EE Home Page?
• What Is the Oracle BI EE Global Header?
• Where Can I Get Help or More Information?
• About Privileges and Permissions
• About Acting for Other Users
• Acting for Other Users
• Setting Preferences
• How Does Oracle BI EE Interact with Other Products?
  • Integration of Oracle BI EE with Oracle BI Publisher
  • Integration of Oracle BI EE with Oracle BI Mobile App Designer
  • Integration of Oracle BI EE with Oracle Business Intelligence Mobile
  • Integration of Oracle BI EE with Oracle Enterprise Performance Management System
  • Interaction of Oracle BI EE with Oracle BI Applications
  • Integration of Oracle BI EE with Microsoft Office
• Downloading BI Desktop Tools
• Topics of Interest in Other Guides
• System Requirements and Certification

Creating Analyses

• What Are Analyses?
  • How Do I Work with Analyses?
  • How Are Analyses Processed?
  • Embedding an Analysis in a Dashboard
• What Are Subject Areas and Columns?
  • What Are the Types of Columns?
  • How Are Columns Indicated Visually?
  • How Will Measure Columns Created in Previous Releases Be Upgraded?
• Understanding the Double Column Feature
• What Is the Analysis Editor?
  • Managing Panes in the Analysis Editor Tabs
• What Is the Process for Constructing Analyses?
• Creating New Analyses
• Specifying the Criteria for Analyses
  • Understanding Null Suppression
  • Example 1: Adding a Filter to a Row Edge on a Measure When Null Values Are Included
  • Example 2: Adding a Filter to a Row Edge on a Measure When Null Values Are Included
  • Example 3: Adding a "Not Null" Filter to a Row Edge on a Measure When Null Values Are Included
  • Editing the Formula for a Column
  • Combining Columns Using Set Operations
    • Guidelines for Selecting Columns to Combine
    • Difference Between Combining Columns Using Set Operations and Adding Columns from Related Subject Areas
    • Example: Combining Columns from One Subject Area
    • Combining Columns from One or More Subject Areas
  • Viewing Metadata Information from the Subject Areas Pane
• Saving Columns to the Catalog
• Changing the Sort Order of Subject Areas and Subject Area Folders
  • Where Else is the Subject Areas Sort Order Reflected?
• Displaying the Results of Analyses
  • Creating Additional Compound Layouts
  • Alerting Users to No Data in the Results of Analyses
• Adding Prompts to Analyses
• Examining the Logical SQL Statements for Analyses
• Saving Analyses
• Creating Agents from Analyses
• Editing Analyses
  • Editing Upgraded Analyses that Contain "Advanced SQL"
• About Embedding an Analysis in a Dashboard
• Working with Direct Database Requests
  • Setting Privileges for Direct Requests
  • Executing a Direct Database Request
  • Seeing the Results of Direct Database Requests
• Using Variables
  • What Are Session Variables?
  • What Are Repository Variables?
  • What Are Presentation Variables?
  • What Are Request Variables?
  • What Are Global Variables?
• Where Can I Reference Variables?
• What Is the Syntax for Referencing Variables?
• What Predefined Presentation Variables Are Available?
• Example of Referencing a Variable in a Title View

Adding Views for Display in Dashboards

• What Are Views?
  • Related Topics
• What Types of Views Are Available?
  • What Types of Graphs Are Available?
  • What Types of Funnel Graphs Are Available?
  • What Types of Graphs Are Available to Trellis Views?
  • What Types of Gauges Are Available?
  • What Types of Logical SQL Views Are Available?
  • What Types of Waterfall Graph Formats Are Available?
• How Has the Behavior of Charts Created in Previous Releases Changed?
• Adding Views to the Results of Analyses
• What Is the Recommended Visualizations Feature?
• Editing Views
  • Editing Table and Pivot Table Views
    • Applying Formatting to Tables and Pivot Tables
  • Editing Graph Views
    • Formatting the Visual Appearance of Graphs
  • Editing Trellis Views
    • What Terms are Used with Trellis Views?
    • What Makes a Trellis View Unique?
    • What Are the Functions of Trellis Views?
    • What Are Microcharts?
    • About Simple Trellis Versus Advanced Trellis
    • Design Considerations for Trellis Views and Microcharts
  • Editing Gauge Views
  • Editing Map Views
    • Using Auto Correct
    • What are the Functions of Map Views?
    • What Terms Are Used with Map Views?
    • What Are the Components of Map Views?
    • What Are Layers?
    • Creating Map Views
    • How Do Formats Affect Layers?
    • Applying Formats to Layers
    • Setting the Initial View Ports for Map Views
    • Editing Map Views and Displaying Map Views on Dashboard Pages
  • Editing Narrative Views
  • Editing Column Selector Views
  • Editing View Selector Views
  • Editing Legend Views
  • Editing Performance Tile Views
  • Editing Treemap Views
    • Understanding Treemap Views
    • Working with Treemap Views
  • Editing Heat Matrix Views
    • Understanding Heat Matrix Views
    • Working with Heat Matrix Views
  • Modifying the Layout of Data in Views
    • Understanding Drop Targets
    • Adding and Rearranging Columns in Views
    • Setting Properties for View Bodies and Drop Targets
    • Displaying Running Sums and Relative Values for Measure Columns in Pivot Tables
    • Defining Section Sliders in Graphs, Gauges, and Funnels
• Modifying Values and Performing Write Back
  • About Modifying Values and Various Types of Users
  • Process for Write Back
  • Adding the Write-Back Capability to a Column
  • Adding the Write-Back Capability to a Table View
  • About the Modes for Write Back in Views
• Interactions in Views
  • Click Interactions in Views
    • How Will Interactions Created in Views in Previous Releases Be Upgraded?
  • Right-Click Interactions in Views
• Drilling in Views
  • In Which Columns Can I Drill?
  • How Do I Allow Drilling in Columns?
  • What are the Effects of Drilling on Filters and Selection Steps?
  • Related Topics
• Sorting Data in Views
  • Common Sort Functionality
  • Sorting Data
  • Clearing Sorts
  • Sorting in Tables and Pivot Tables
  • Example 1: Sorting with a Single Column on Each Edge
  • Example 2: Sorting with Two Columns on the Row Edge
  • Example 3: Sorting with Two Measures on the Column Edge
  • Sorting in Graphs by Using the Right-Click Menu
  • How Will Sort Specifications Created in Previous Releases Be Upgraded?
• Resizing Rows and Columns in Table Views, Pivot Table Views, and Advanced Trellis Views
• Saving Views
• Renaming Views or Compound Layouts
• Rearranging Views
• Printing Views
• Changing Print and Export Options for Views
• Previewing How Views Are Displayed on a Dashboard
• Removing Views
• Refreshing the Results in Views
• Customizing Views for Delivery to Agent Users
• What Is Master-Detail Linking of Views?
  • What Are Master Views?
    • What Types of Columns Can Be Master Columns
    • What Information Do Master-Detail Events Pass?
    • What Are Channels?
  • What Are Detail Views?
  • How Does Master-Detail Linking of Views Work?
• Linking Views in Master-Detail Relationships
  • Defining the Master View
  • Defining the Detail View
  • Example of a Table and Graph Linked in a Master-Detail Relationship
    • About the Regional Sales Master View
    • About the Regional Sales Detail View
    • How the Master-Detail Linking Works for Regional Sales Master View and Regional Sales Detail View

Building and Using Dashboards

• What Are Dashboards?
• Who Creates and Edits Dashboards?
• What Is the Dashboard Builder?
• What Controls the Look-and-Feel of a Dashboard?
• About the ALTA Style
• Creating Dashboards
• Editing Dashboards
  • Adding New Pages to Dashboards
  • Adding Content to Dashboards
    • Dragging and Dropping Objects to the Page Layout Area in the Dashboard Builder
• Adding Oracle BI Publisher Reports to Dashboard Pages
  • How Do Oracle BI Publisher Reports and Dashboard Pages Interact?
    • About Oracle BI Publisher and Dashboard Pages
    • About Adding Reports to Dashboard Pages
  • Adding Reports to Dashboard Pages
  • Using Prompts with Parameterized Reports
• Changing the Properties of a Dashboard and its Pages
• Changing the Properties of Objects Added to Dashboard Pages
• Delaying the Execution of Dashboard Pages
• About Creating Custom Layouts for Printing and Exporting Dashboard Pages
  • Items Not Supported When Using Custom Print Layouts
• Creating Custom Layouts for Printing and Exporting Dashboard Pages
• Editing, Replacing, or Removing Custom Layouts
• Deleting Objects on Dashboard Pages
• Deleting Dashboard Pages
  • Deleting The Current Dashboard Page
  • Deleting One or More Dashboard Pages
• Saving Dashboards by Other Names and in Other Locations
• Opening and Using Dashboards
• What Are Saved Customizations for Dashboard Pages?
  • Example Scenarios for Creating and Using Saved Customizations
    • Scenario 1: Saved Customizations Created by a Group for Use by Others
    • Scenario 2: Saved Customizations Created for Use by an Individual User
• Saving Customizations
• Applying Saved Customizations
• Editing Saved Customizations
• Clearing Your Current Customization
• About Dashboard Template Pages for New Users
  • How Dashboard Template Pages Work
  • Where Oracle BI EE Searches for Dashboard Template Pages
  • How Users Can Work with Dashboard Template Pages
• Creating Dashboard Template Pages for New Users
• Publishing Dashboard Pages
• About Creating Links to Dashboard Pages
  • What Are Bookmark Links?
  • What Are Prompted Links?
    • Basic Syntax of Prompted Links
    • Parameters for Prompted Links
    • Guidelines for Manipulating Prompted Links
• Creating Links to Dashboard Pages
• Working with Briefing Books
  • What Are Briefing Books?
    • About the Table of Contents in a PDF Version of a Briefing Book
  • Adding Content to New or Existing Briefing Books
  • Editing Briefing Books
  • Downloading Briefing Books
  • Adding a List of Briefing Books to a Dashboard Page
  • Using Agents to Deliver Briefing Books

Filtering and Selecting Data for Analyses

• Saving Objects as Inline or Named
  • What are Inline or Named Objects?
  • What is the Folder Structure for Named Objects?
  • Saving Filters as Inline or Named
  • Saving Groups and Calculated Items as Inline or Named
• What are Filters and Selection Steps?
  • How Do Filters and Selection Steps Differ?
  • Applying Filters to Attribute Columns to Affect Hierarchical Columns
• Working with Selections of Data
  • Creating Selection Steps
  • Editing Selection Steps
  • Saving Selection Steps as a Group Object
  • Working with Selection Steps and Double Columns
• Creating Column Filters
• Editing Column Filters
• Working with the EVALUATE_PREDICATE Function
  • How Can I Use the EVALUATE_PREDICATE Function with a Filter?
  • Adding the EVALUATE_PREDICATE Function to an Inline Filter
• Applying a Named Filter to an Analysis
• Combining and Grouping Column Filters
• Using a Saved Analysis as a Filter
• Creating and Editing the SQL Statements for a Column Filter in an Analysis
• Working with Calculated Measures
• Working with Groups and Calculated Items
  • What are Groups?
  • What are Calculated Items?
    • How Will Calculated Items Created in Previous Releases Be Upgraded?
  • Creating Groups and Calculated Items
  • Editing Groups and Calculated Items
  • Adding a Group to Another Analysis
  • Nesting Groups and Calculated Items
  • Examples of Calculated Items

Prompting in Dashboards and Analyses

• What Are Inline and Dashboard Prompts?
• What are Column Prompts?
• Other Prompt Types
• What Types of User Input Options Can I Use With a Column or Variable Prompt?
• How Will Prompts Created in Previous Versions Be Upgraded?
• How Do Prompts Work in Oracle BI Mobile?
• Can Dashboard Prompts and Analysis Prompts Interact?
• In What Order Does Oracle BI EE Apply Prompts with Default Values?
• What Is Auto-Complete?
• Creating a Column Prompt
• Overriding a Selection Step With a Column Prompt
• Creating an Image Prompt
• Creating a Currency Prompt
• Creating a Variable Prompt
• Editing Prompts
• Adding a Dashboard Prompt to a Dashboard or Dashboard Page
• Adding a Hidden Dashboard Prompt to a Dashboard or Dashboard Page

Formatting Analyses, Views, and Dashboard Pages

• What Can be Formatted?
  • Applying Formatting to Columns in Analyses
  • Applying Formatting to Views
  • Applying Formatting to Dashboard Pages
• Formatting Columns in Analyses
  • What Kinds of Formatting Can I Apply?
  • Applying Formatting to a Column
  • Saving Formatting Defaults
• What is Cosmetic Formatting?
  • Using a Saved Analysis to Modify the Cosmetic Appearance of Other Analyses
    • Where is the Import formatting from another analysis Button?
    • Which View Types Support Imported Formatting?
    • How is Imported Formatting Applied?
    • Importing Formatting Using a Saved Analysis
• Applying Conditional Formatting to Tables, Pivot Tables, Performance Tiles, Graphs, Heat Matrices, and Trellises
  • How is Conditional Formatting Applied?
  • Can Conditional Formats Be Based on Another Column?
  • What Factors Affect Conditional Formats?
    • Layout, Order, and Conditional Formats
    • Value Suppression and Conditional Formats
  • Applying Conditional Formatting
  • Example of Conditional Formatting for Ranking
• Custom Format Masks
• Custom Format Strings
  • Custom Format Strings for Date and Time Fields
    • General Custom Format Strings
    • ODBC Custom Format Strings
  • Custom Format Strings for Numeric Fields
    • Custom Format Strings for Integral Fields
    • Custom Format Strings for Conversion into Hours
    • Custom Format Strings for Conversion into Hours and Minutes
    • Custom Format Strings for Conversion into Hours, Minutes, and Seconds
    • Custom Format Strings for Displaying Duration

Delivering Content

• What Are Agents?
• What Are Alerts?
• How Agents Work
• What Is the Agent Editor?
• About Controlling Access to Agents
• How Will iBots Created in Previous Releases Be Upgraded?
• About Using Customization in Agents
• Creating Agents
• Viewing Summaries of Agent Settings
• Saving Agents
• Subscribing to Agents
• Displaying a List of the Agents That You Subscribe to or That You Own
• Unsubscribing from Agents
• Customizing Your Agent Subscriptions
  • Displaying Customized Filter Values in Agent Results
• Disabling and Enabling Agents' Schedules
• What Are Devices and Delivery Profiles?
• Configuring Your Devices and Delivery Profiles
• Accessing and Managing Your Alerts
• Subscribing to an RSS Feed for Alerts

Working with Conditions

• What Are Conditions?
• For What Do I Use Conditions?
• What Are the Elements of a Condition?
• What Are Named Conditions?
• What Are Inline Conditions?
• Who Creates Conditions?
• Creating Named Conditions
• Using Conditions to Determine Whether Agents Deliver Their Content or Execute Their Actions
• Using Conditions to Determine Whether Action Links Are Displayed in Dashboard Pages
• Using Conditions to Determine Whether Sections Are Displayed in Dashboard Pages
• Specifying the Settings for Conditions
• Editing Named Conditions
• Editing, Customizing, Testing, Saving, and Disabling Conditions Used in Agents
• Editing, Testing, Saving, and Removing Conditions Used in Action Links in Dashboard Pages
• Editing, Testing, Saving, and Removing Conditions Used in Sections in Dashboard Pages

Working with Actions

• What Are Actions?
• What Are Action Links and Action Link Menus?
• What Action Types Are Available?
  • Actions that Navigate to Related Content
  • Actions that Invoke Operations, Functions or Processes in External Systems
• Who Can Create Actions?
• Where Can I Add Actions?
• What Are Named Actions?
• What Are Inline Actions?
• How Will Actions Created in Previous Releases Be Upgraded?
• What Are Action Parameters?
• About Conditionally Enabling Actions
  • About Conditionally Enabling Actions Added to Analyses
  • About Conditionally Enabling Actions Added to Dashboard Pages
  • About Conditionally Enabling Actions Added to Agents
• About Customizing Information Displayed to Users on Action Execution
• Creating Named Actions
• Specifying the Settings for New Actions
• Adding Actions to Analyses
• About Adding Actions to Dashboard Pages
• Adding Actions to Dashboard Pages Using Action Links
  • Completing the Action Link Properties Dialog
• Adding Actions to Dashboard Pages Using Action Link Menus
• Adding Actions to Agents
• Adding Actions to KPIs
• Adding Actions to Initiatives and Objectives in Scorecards
• Creating a New Action Based on an Existing Named Action
• Editing Named Actions
• Editing Actions and Action Links Added to Analyses
• Editing Actions, Action Links, and Action Link Menus Added to Dashboard Pages
• Editing Actions Added to Agents
• Editing Actions and Action Links Added to KPIs
• Editing Actions and Actions Links Added to Initiatives and Objectives in Scorecards
• Saving Inline Actions in Analyses to the Catalog
• Saving Inline Actions in Dashboards to the Catalog
• Testing a Named Action by Executing It

Using KPIs and KPI Watchlists

• What Are KPIs?
• How Are KPIs Evaluated?
• How Can I Use KPIs?
• What Are Dimensions and Pinned Dimension Values?
• About KPI Privileges and Permissions
• How Do I Create a KPI?
• Creating KPIs
• Editing KPIs
  • Editing KPIs from the Catalog
  • Editing KPIs from a KPI Watchlist
• What Are Target Settings?
  • Prerequisites for Setting Up Target Settings in KPIs
  • Overview of Setting Up Target Settings in KPIs
  • User Interaction with Target Settings
• Generating Analyses from KPIs
• Creating Agents from KPIs
• Contacting the Business Owner of KPIs
• About Overriding Statuses of KPIs
• About Adding Comments to KPIs
• What Are KPI Watchlists?
• Creating KPI Watchlists
• Editing KPI Watchlists
• About KPI Contribution Wheel Diagrams
• Understanding KPI Contribution Wheel Diagrams
• Creating KPI Contribution Wheels
• Editing KPI Contribution Wheels
• Changing Explore Dimensions Within KPI Contribution Wheels
• About KPI Contribution Wheels and Dashboards

Scorecarding

• What Is Oracle Scorecard and Strategy Management?
• What Is a Balanced Scorecard?
• What Is the Scorecard Editor?
• What Are Scorecard Objects?
• How Do I Create a Scorecard?
• About Scorecard Privileges and Permissions
• Using the Edit and View Modes in the Scorecard Editor
• Creating Scorecards
• Opening or Editing Scorecards
• Viewing Overview Information
• About the Point of View Area
• Setting Up the Point of View Controls
• What Are Vision Statements?
• Defining Vision Statements
• What Are Mission Statements?
• Defining Mission Statements
• What Are Perspectives?
• Creating Custom Perspectives
• What Are Key Performance Indicators (KPIs)?
• What Are KPI Contribution Wheels?
• What Are Objectives?
• Creating Objectives
  • Completing the Analytics Pane for Objectives or Initiatives
• What Are Initiatives?
• Creating Initiatives
• Contacting Business Owners
• About Comments
• Working with Comments
  • Working with Comments in the Collaboration pane
  • Working with Comments in Watchlists
  • Working with Comments in the Diagram Tab of a View
• Understanding Initiative or Objective Performance Assessment
  • About Assessment Mappings
  • Example of Determining the Performance Assessment for an Objective Based on Child Objectives
  • Example of Determining the Performance Assessment for an Objective Based on a Child KPI
• Defining Assessment Mappings for Scorecards
• Assigning Weights to Child Objectives, Initiatives and KPIs
• About Status Overrides
• Working with Status Overrides
  • Working with Status Overrides in Watchlists
  • Working with Status Overrides in the Diagram Tab of a View
• What Are Strategy Trees?
  • Understanding a Strategy Tree Diagram
  • Understanding a Strategy Contribution Wheel Diagram
• Creating Strategy Trees
• What Are Strategy Maps?
• Creating Strategy Maps
• What Are Cause & Effect Maps?
• Creating Cause & Effect Maps
• Understanding Watchlists
• What Are KPI Watchlists?
• Working with KPI Details
• What Are Smart Watchlists?
• Creating Smart Watchlists
• What Are Custom Views?
• Creating Custom Views
• Opening Scorecard Objects
• Editing Scorecard Objects
• Deleting Scorecard Objects
• Adding Scorecard Objects to Dashboards
• Troubleshooting

Managing Objects in the Oracle BI Presentation Catalog

• What is the Oracle BI Presentation Catalog?
• Who Uses the Catalog?
• How Will Hidden Dashboards Created in Previous Versions be Upgraded?
• Saving Business Intelligence Objects
• How Can I Search for Objects?
  • Basic Catalog Search
  • Full-Text Catalog Search
• Searching for Objects in the Catalog
• What Results are Returned from a Full-Text Catalog Search?
• Object-Specific Tasks
• What Are Favorites?
• Adding Objects to Favorites
• Accessing Favorite Objects
• Organizing Favorites
• Removing Objects From Favorites
• Exporting Analyses, KPIs, and Analysis Prompts Data
• Accessing Properties
• Levels of Oracle BI EE Security
• What Are Permissions?
• How Are an Object's Permission Assigned?
• Access Control Lists and Permissions
• Permission Definitions
• Permissions Available by Object Type
• Recommendations for Setting Permissions
• Assigning Permissions
• Who Owns an Object?
• Assigning Ownership of Objects
• Taking Ownership of Objects
• What is Archiving?
• Archiving Objects

Using BI Composer to Work with Analyses

• What Is BI Composer?
• Where Is BI Composer Available?
  • Availability of BI Composer in Oracle BI Enterprise Edition
• Comparing the Analysis Editor and BI Composer
  • What Types of Views Can I Work with in BI Composer?
• What Are the Steps for Creating or Editing an Analysis in BI Composer?
• Creating Analyses Using BI Composer
• Editing Analyses Using BI Composer
• Viewing Analyses in BI Composer
• Editing Analyses Created by Using the Analysis Editor

Basic Information to Tell Your Users

• About Exporting Results
  • Exporting Results
• About Exporting Dashboards and Dashboard Pages
• About Sorting Values in Heat Matrix Views, Table Views, Pivot Table Views, and Trellis Views
• About Resizing Rows and Columns in Views
• About Drilling in Results
  • What is Drilling?
  • Where Can I Drill?
    • Drilling in Heat Matrices, Tables, Pivot Tables, and Trellises
    • Drilling in Graphs
• About Running Actions Using Action Links and Action Link Menus in Analyses and Dashboards
• About Running Actions Associated with Action Links in Analyses and Dashboards
• Using Section Sliders in Graphs, Gauges, and Funnels
• About Working with Map Views on Dashboard Pages
  • Panning in Map Views
  • Zooming in Map Views
  • Drilling in Map Views
  • Modifying Thresholds for Formats on a Map View
  • Showing or Hiding Formats on a Map View
• Zooming and Scrolling in Graphs
• About Working with Views that Are Linked in Master-Detail Relationships
• Modifying Data in a Table View in a Dashboard Page or Analysis
  • About Handling Errors for Write Back
• Accessing BI Publisher Reports in Dashboards
  • Using the Oracle BI Publisher Toolbar on a Dashboard Page
• About Navigating With Breadcrumbs
• Printing Dashboard Pages
• About Working with Scorecard Objects
• Modifying a KPI's Actual and Target Values

Accessibility Features

• Using Accessibility Features
  • What are Accessibility Features?
  • Signing In Using Keystrokes
  • Changing to Accessibility Mode
• Keyboard Shortcuts
  • Keyboard Shortcuts for Oracle BI EE and Oracle BI Publisher
  • Navigating on the Home Page
  • Navigating in Oracle Business Intelligence Dashboards
• Designing for Accessibility
  • Obtaining General Information
  • Avoiding Common Misconceptions
  • Following Best Practice Recommendations
  • Following General Guidelines for Accessible Content
    • Font Selection
    • Color Selection
    • Color Contrast
  • Designing Dashboards that are Accessible
    • Promoting a Consistent Structure
    • Keeping Dashboard Pages Simple
    • Enhancing On-Screen Content
    • Providing Alternate Displays
    • Including Descriptions for Analyses
    • Working with Styles for Dashboards
    • Avoiding Prohibited Features
• Using Objects to Enhance Accessibility
  • Switching Content with View Selectors
  • Using Static Text Objects for Custom HTML Markup
• Installing and Configuring BI Composer for Oracle BI EE
  • Extending a WebLogic Server Domain to Install BI Composer Runtime Implementation Shared Libraries

Logical SQL Reference

• About Logical SQL in Oracle Business Intelligence
• 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
  • Limiting and Offsetting Rows Returned
    • Limitations of the FETCH and OFFSET Clauses
  • Operators
    • SQL Logical Operators
    • Mathematical Operators
  • Conditional Expressions
    • CASE (Switch)
    • CASE (If)
  • Expressing Literals
    • Character Literals
    • Datetime Literals
    • Numeric Literals
  • Variables
• Aggregate, Running Aggregate, Time Series, and Reporting Functions
  • Aggregate Functions
    • AGGREGATE AT
    • AVG
    • AVGDISTINCT
    • BOTTOMN
    • COUNT
    • COUNTDISTINCT
    • COUNT(*)
    • 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
  • 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
  • IFNULL
  • TO_DATETIME
  • VALUEOF
• Database Functions
  • EVALUATE
  • EVALUATE_ANALYTIC
  • EVALUATE_AGGR
  • EVALUATE_PREDICATE
• System Functions
  • USER
  • DATABASE

User Interface Reference

• Act As dialog
• Action Link dialog
• Action Links dialog
• Action Link Menu Properties dialog
• Action Link Properties dialog
• Action Options dialog
• Action Options dialog: Action Results tab
  • Working with HTML Markup
• Action Options dialog: Invoke Action tab
• Add Application Roles, Catalog Groups, and Users dialog
• Add New Dimension dialog
• Add Comment dialog
• Add Dashboard Page dialog
• Add KPI dialog
• Add a Related Document dialog
• Add/Remove Subject Areas dialog
• Administration page
• Administration: Issue SQL page
• Administration: Manage Agent Sessions page
• Administration: Manage Catalog Groups page
• Administration: Manage Device Types page
• Administration: Manage Map Data page
• Administration: Manage Privileges page
• Administration: Manage Sessions page
• Administration: Subject Area Manager page
• Advanced SQL Filter dialog
• Advanced Ticker Options dialog
• Agent editor
• Agent editor: Actions tab
• Agent editor: Condition tab
• Agent editor: Delivery Content tab
• Agent editor: Destinations tab
• Agent editor: General tab
• Agent editor: Recipients tab
• Agent editor: Schedule tab
• Alert dialog
• Alerts dialog
• Analysis editor
• Analysis editor: Advanced tab
• Analysis editor: Criteria tab
• Analysis editor: Results tab
• Analysis Properties dialog
• Analysis Properties dialog: Data tab
• Analysis Properties dialog: Interactions tab
• Analysis Properties dialog: Results Display tab
• Analysis Simple SQL Statement dialog
• Analytics pane
  • Watchlists
  • Status window
• Apply Saved Filter dialog
• Archive dialog
• Bar Graph (Layer) dialog
• BI Composer wizard
• BI Composer wizard -- Create Analysis: Select Columns panel
• BI Composer wizard -- Create Analysis: Select Views panel
• BI Composer wizard -- Create Analysis: Edit Table panel
• BI Composer wizard -- Create Analysis: Edit Graph panel
• BI Composer wizard -- Create Analysis: Sort and Filter panel
• BI Composer wizard -- Create Analysis: Highlight panel
• BI Composer wizard -- Create Analysis: Save panel
• BI Publisher Report Properties dialog
• Break dialog
• Bubble (Layer) dialog
• Catalog page
  • Catalog area
• Catalog pane
• Catalog pane for KPI Contribution Wheel
• Catalog pane for Scorecard
• Causal Linkage dialog
• Cause & Effect Map Preferences dialog
• Cause & Effect Map Preferences dialog: General tab
• Cause & Effect Map Preferences dialog: Hidden Nodes tab
• Cause & Effect Map tab: Details tab
  • Related Documents area
• Cause & Effect Map tab: Diagram tab
• Change Aggregation Rule dialog
• Change Column Labels
• Choose Request Column dialog
• Choose Starting Nodes dialog
• Collaboration pane
• Color Selector dialog
• Column Properties dialog
• Column Properties dialog: Column Format tab
• Column Properties dialog: Conditional Format tab
• Column Properties dialog: Data Format tab
• Column Properties dialog: Interaction tab
• Column Properties dialog: Style tab
• Column Properties dialog: Write Back tab
• Column Properties dialog for BI Composer
• Compound Layout
• Contact Owner dialog
• Content Properties dialog
• Create Delivery Profile dialog
• Create Device dialog
• Create New Action dialog
  • About Encoding the URL for a Navigate to a Web Page or Invoke an HTTP Request Action
• Create New Agent dialog
• Create New Device Type dialog
• Create Subject Area from filename dialog
• Custom Permissions dialog
• Custom View Properties dialog
• Custom View tab: Details tab
• Custom View tab: Diagram tab
• Customize Condition dialog
• Customize Gauge Limit dialog
• Customize Scale Marker dialog
• Customize Subscription to Agent dialog
• Customize Subscription to Agent dialog: Condition Parameters tab
• Customize Subscription to Agent dialog: Content Parameters tab
• Dashboard builder
  • Page Layout area
  • Properties Buttons for Objects
• Dashboard Filters and Variables dialog
• Dashboard Objects pane
• Dashboard page
• Dashboard Properties dialog
• Definition pane
• Dimension Pinnings dialog
• Display pane
• Edit dialog
• Edit Background Map dialog
• Edit Briefing Book dialog
• Edit Column Formula dialog
• Edit Column Formula dialog: Bins tab
• Edit Column Formula dialog: Column Formula tab
• Edit Dimension Settings dialog
• Edit Footer or Header dialog
• Edit Layer dialog
• Edit Page Settings dialog
• Edit Parameter Filter dialog
• Edit Parameter Mapping dialog
• Edit Saved Customizations dialog
• Embedded Content Properties dialog
• Enter Email Address dialog
• Enter Expression dialog
• Filter editor
• Filters pane
• Folder Properties dialog
• Folders pane
• Font Format: Item dialog
• Font Format: Item dialog: Display Options tab
• Font Format: Item dialog: Font Format tab
• Font Format dialog: Number Format tab
• Gauge Properties dialog
• Gauge Properties dialog: General tab
• Gauge Properties dialog: Scale tab
• Gauge Properties dialog: Style tab
• Gauge Properties dialog: Titles and Labels tab
• Getting Started pane
• Graph Properties dialog
• Graph Properties dialog: General tab
• Graph Properties dialog: Scale tab
• Graph Properties dialog: Style tab
• Graph Properties dialog: Titles and Labels tab
• Graphics dialog
• Heat Matrix Properties dialog
• Heat Matrix Properties dialog: General tab
• Heat Matrix Properties dialog: Titles and Labels tab
• Home page
• Image Map Prompt Properties dialog
• Import Background Maps dialog
• Initiative Linkage dialog
• Initiatives pane
  • Right-Click Menu for Objects in the Initiatives Pane and Strategy Pane
• Insert Filter dialog
• Insert Function dialog
• Insert Global Variable dialog
• Insert Variable dialog
• Invoke Action dialog
• Key Resource dialog
• KPI Contribution Wheel editor
• KPI Contribution Wheel editor: Details tab
• KPI Contribution Wheel editor: Diagram tab
• KPI Contribution Wheel Properties dialog
• KPI editor
• KPI editor: Custom Attributes page
• KPI editor: Dimensionality page
• KPI editor: General Properties page
• KPI editor: Related Documents page
• KPI editor: States page
• KPI Watchlist editor
• KPI Watchlist editor: Details tab
• KPI Watchlist editor: Performance tab
• Layout pane
  • Aggregation Rules and Functions
• Legend pane
• Link or Image Properties dialog
• Manage Favorites dialog
• Map Properties dialog
• Map Properties dialog: Canvas tab
• Map Properties dialog: Interaction tab
• Map Properties dialog: Tools tab
• Mission tab: Details tab
• Mission tab: Document tab
• My Account dialog
• My Account dialog: BI Publisher Preferences tab
• My Account Dialog: Delegated Users tab
• My Account dialog: Delivery Options tab
• My Account dialog: Mobile Preferences tab
• My Account dialog: Preferences tab
• My Account dialog: Roles and Catalog Groups tab
• New Action Link dialog
• New Calculated Item dialog
• New Category dialog
• New Condition dialog
• New Condition Step dialog
• New Dashboard dialog
• New EVALUATE_PREDICATE Function dialog
• New Filter dialog
  • Operators
• New Folder dialog
• New Global Variable dialog
• New Prompt dialog
• New Related Document dialog
• New Scorecard dialog
• Open dialog
• Overview pane
  • Initiative or Objective Overview
  • KPI Overview
• Page Properties dialog
• Performance Tile Properties dialog
• Permissions dialog
• Perspectives pane
• Preview pane
• Print & Export Options dialog
• Privilege dialog
• Prompt editor
• Prompt Links dialog
• Properties dialog
• Publish Page to Dashboard dialog
• Related Items pane
• Rename dialog
• Replace Icon dialog
• Replace Icon dialog: Custom Image tab
• Replace Icon dialog: Standard Images tab
• Report Links dialog
• Results tab: Column Selector editor
• Results tab: Create Segment editor
• Results tab: Create Target List editor
• Results tab: Data View editor
  • Right-Click Menu for Data Views
  • Toolbar Buttons Common to All Views
  • Data View Editor Toolbar
  • Export Menu Options for Views and Results
  • Sorting Options Menu
• Results tab: Filters editor
• Results tab: Legend editor
• Results tab: Narrative editor
• Results tab: Selection Steps editor
• Results tab: Static Text editor
• Results tab: Ticker editor
• Results tab: Title editor
  • Storing Custom Files Locally and Using the fmap Function to Reference Them
• Results tab: View Selector editor
• Save Briefing Book Content dialog
• Save Current Customization dialog
• Saved Customization Permissions and Defaults dialog
• Scale Markers dialog
• Scorecard Breadth pane
• Scorecard Content Properties dialog
• Scorecard Documents pane
• Scorecard editor
• Scorecard editor: Breakdown tab
• Scorecard editor: Cause & Effect Map tab
• Scorecard editor: Custom View tab
• Scorecard editor: Initiative Details tab
• Scorecard editor: KPI Details tab
• Scorecard editor: Mission tab
• Scorecard editor: Objective Details tab
• Scorecard editor: Overview tab
• Scorecard editor: Perspective tab
• Scorecard editor: Smart Watchlist tab
  • Filter pane: Relationship tab
  • Filter pane: Type tab
  • Filter pane: Perspective tab
  • Filter pane: Performance tab
  • Filter pane: Ownership tab
• Scorecard editor: Strategy Map tab
• Scorecard editor: Strategy Tree tab
• Search pane
• Section Condition dialog
• Section Properties dialog
• Sections Formatting dialog
• Sections Formatting dialog: Display Options tab
• Select Column dialog
• Select Java Method dialog
• Select Script Function dialog
• Select Values dialog
• Select Variable dialog
• Select Web Service Operation dialog
• Selected Columns pane
• Selection Steps pane
• Set User dialog
• Settings dialog
• Settings dialog: Assessment Mappings tab
• Settings dialog: Dimension Settings tab
• Settings pane
• Show More Columns dialog
• Sign In page
• Smart Watchlist Properties dialog
• Sort dialog
• Status Override dialog
• Strategy Map tab: Details tab
• Strategy Map tab: Diagram tab
• Strategy pane
• Strategy Tree tab: Details tab
• Strategy Tree tab: Diagram tab
  • Node Options Menu
• Strategy Tree View Properties dialog
• Style and Conditional Formatting dialog
• Style and Conditional Formatting dialog: Conditional Formatting tab
• Style and Conditional Formatting dialog: Style Formatting tab
• Styles pane
• Subject Areas pane
• Table Properties dialog
• Table Properties dialog: Style tab
• Table Properties dialog: Write Back tab
• Tasks pane
  • Tasks Options
• Text Properties dialog
• Treemap Properties dialog
• Treemap Properties dialog: General tab
• Treemap Properties dialog: Style tab
• Trellis Properties dialog
• Trellis Properties dialog: General tab
• Trellis Properties dialog: Style tab
• Trellis Properties dialog: Titles and Labels tab
• Unarchive dialog
• View Group: Group dialog
• View Group: Group dialog: Results tab
• View Group: Group dialog: Selection Steps tab
• Views pane

Index