You are previewing Oracle Business Intelligence Discoverer 11g Handbook.
O'Reilly logo
Oracle Business Intelligence Discoverer 11g Handbook

Book Description

Master Oracle Business Intelligence Discoverer 11g

Provide secure, immediate access to critical business information from relational and multidimensional data sources across your organization. Oracle Business Intelligence Discoverer 11g Handbook shows you how to optimize this intuitive ad hoc query, reporting, analysis, and web publishing tool for maximum performance. Real-world examples illustrate the powerful analysis, security, and reporting capabilities. Enable business users at all levels to make faster, more-informed decisions with help from this Oracle Press guide.

  • Configure and manage Oracle Business Intelligence Discoverer 11g
  • Run functional queries using the Workbook Wizard
  • Add sorts, calculations, percentages, totals, and parameters using Oracle Business Intelligence Discoverer Plus
  • Format queries into well-organized reports with graphs, tables, titles, headers, and footers
  • Perform data analysis--statistical, classification, deviation, trend, and aging
  • Use Oracle Business Intelligence Discoverer Viewer 11g to analyze, format, export, e-mail, and print reports
  • Manage integration with Oracle WebLogic Server
  • Refine existing queries using interactive pivoting, drilling, and hyper-drilling
  • Build effective conditions and refine parameters, calculations, sorting, and percentages
  • Manage access and sharing rights, scheduling privileges, and user preferences
  • Build an end user layer and a business area using Oracle Business Intelligence Discoverer Administrator
  • Use Oracle Enterprise Manager's Fusion Middleware Control feature to manage Oracle Business Intelligence Discoverer settings and preferences
  • Implement powerful analytic functions using templates

Table of Contents

  1. Cover 
  2. Title Page
  3. Copyright Page
  4. About the Authors
    1. About the Technical Editor
  5. Contents at a Glance
  6. Contents 
  7. Acknowledgments
  8. Introduction
    1. How This Book Is Organized
  9. Part I: Getting Started with Discoverer
    1. Chapter 1: An Overview of Discoverer
      1. Business Intelligence and Your Organization
        1. Your Discoverer Investment
        2. Connecting to Other Databases
      2. Business Intelligence and Trends
        1. Recent Business Intelligence Trends and Discoverer
      3. Discoverer’s Role in Business Intelligence
        1. The Nine Parts of Discoverer
      4. How to Use This Book
        1. Example Database
      5. A New Direction in Reporting
        1. The Discoverer Interface
        2. Ad Hoc Queries vs. Predefined Queries
      6. Getting Help with Discoverer
      7. Summary
    2. Chapter 2: Users and Databases
      1. What Starts Right Stays Right
      2. The Responsibility of the End User
        1. Your Business
        2. Your Reporting Requirements
        3. Your Database
      3. The Discoverer Library Concept
        1. The Definition of a Library
        2. The Definition of a Library Manager
      4. The Report Writer Concept
        1. The Definition of a Report Writer
        2. The Benefits of Having Report Writers
        3. The Benefits of Being a Report Writer
        4. Choosing Your Report Writers
      5. Summary
    3. Chapter 3: Getting Started in Discoverer
      1. Key Personnel
        1. Discoverer Manager
        2. Library Manager
        3. Database Administrator
        4. E-Business Suite Administrator
        5. Report Writers
      2. Gaining Access to Discoverer
      3. Key Definitions
        1. Workbooks and Worksheets
        2. Queries
        3. Reports
        4. Libraries
      4. Sticky Features
      5. Main Features of Discoverer
      6. Discoverer Login Sequence
        1. Connecting Using Discoverer Desktop
      7. Launching 11g Discoverer Plus or Viewer
      8. Starting a Workbook
      9. Summary
    4. Chapter 4: The Workbook Wizard: The Essential Steps
      1. The Workbook Wizard
        1. The Workbook Wizard Steps
        2. A Simple Workflow
        3. The Workbook Wizard Options
        4. Workbook Wizard Step 1: Creating a New Workbook or Opening an Existing Workbook
        5. Workbook Wizard Step 2: Selecting the Data
        6. Workbook Wizard Step 3: Arranging the Order of the Output
        7. Workbook Wizard Step 4: Setting User-Defined Conditions
        8. The Query from the Twilight Zone and How to Avoid It
        9. Viewing the Results
        10. Saving the Query
      2. Summary
    5. Chapter 5: The Workbook Wizard: The Optional Steps
      1. The Text Area in Plus
      2. The Optional Steps of the Workbook Wizard
      3. Workbook Wizard Step 5: Creating a Sort Order (Tables Only)
        1. Sorting: What Is It?
        2. Creating a New Sort
        3. Quick Sorting
        4. Refining a Sort
        5. Building a Group Sort
        6. Adding Another Sort
        7. Rearranging the Sort Order
      4. Why Not Sort in the Wizard?
      5. Workbook Wizard Step 6: Creating User-Defined Calculations
        1. Desktop Calculations Screen
        2. Plus Calculations Tab
        3. Calculations: What Are They?
        4. Creating a Calculation in Desktop
        5. Creating a Calculation in Plus
      6. Understanding Calculations
        1. Why Not Calculate in the Wizard?
      7. Discoverer Plus Workbook Wizard Remaining Steps
      8. Creating User-Defined Percentages in the Plus Workbook Wizard
        1. Percentages: What Are They?
        2. Creating a New Percentage
        3. Examples of Percentages
        4. Why Not Perform Percentages in the Wizard?
      9. Creating User-Defined Totals in the Plus Workbook Wizard
        1. Totals: What Are They?
        2. Creating a New Total
        3. Labeling Percentages and Totals
      10. Creating User-Defined Parameters in the Plus Workbook Wizard
        1. Parameters: What Are They?
        2. Differences Between Conditions and Parameters
        3. Creating a New Parameter
        4. Rearranging the Parameter Order
        5. Why Not Create Parameters in the Wizard?
      11. Editing the Sheet After the Query Has Run
      12. Summary
  10. Part II: Editing the Query
    1. Chapter 6: Formatting the Output in Discoverer Desktop and Plus
      1. Giving Your Headings Meaningful Names (Desktop and Plus)
        1. How to Rename Columns in Desktop
        2. How to Rename Columns in Plus
      2. Rearranging the Order of the Output
        1. How to Rearrange Columns
      3. Formatting Data
        1. Formatting Tools
        2. Format Data Dialog Box
      4. Formatting Columns
        1. Formatting Column Headings
        2. Formatting Multiple Headings and Columns in Plus
      5. Deleting Columns from a Worksheet
        1. How to Delete a Column
        2. Resizing Columns
      6. Formatting Totals
        1. Formatting Totals Using the Format Data Dialog Box
        2. Formatting Totals from the Formatting Bar
      7. Formatting Exceptions
      8. Adding a Title to Your Query
        1. Editing the Title
        2. Suppressing a Title from Displaying
      9. Adding a Background Bitmap (Desktop Only)
        1. Setting a Background
        2. Clearing a Background
      10. Summary
    2. Chapter 7: Using Graphs to Present Data
      1. The Available Graph Styles
        1. Bar (Desktop and Plus)
        2. Combination (Plus Only)
        3. Cube (Grouped with 3-D Options in Plus)
        4. Doughnut (Desktop), Ring (Grouped with Pie in Plus)
        5. Horizontal Bar (Desktop and Plus)
        6. Line (Desktop and Plus)
        7. Pie (Desktop and Plus)
      2. The Discoverer Desktop Graph Window
        1. The Features of the Discoverer Desktop Graph Window
      3. Creating a Graph in Desktop
        1. The Desktop Graph Wizard
      4. Graphing in Discoverer Plus
        1. Creating a Graph in the Plus Workbook Wizard
        2. Creating a Graph in Plus after a Query Has Been Generated
      5. Modifying a Graph in Plus
      6. Modifying a Graph in Desktop
        1. To Modify the Graph from the Worksheet
        2. To Modify the Graph from the Graph Window
      7. Summary
    3. Chapter 8: Turning a Discoverer Query into a Report
      1. A Workflow for Building Reports
        1. Report Workflow
      2. Formatting the Report for Printing
        1. Print Setup in Desktop
        2. Print Setup in Plus
      3. Page Setup
      4. The Sheet Tab in Desktop
      5. The Worksheet Tab in Plus
        1. The Table/Crosstab Tab in Plus
        2. Header and Footers
      6. Table and Crosstab Gridlines
        1. Table Gridlines
        2. Crosstab Gridlines
      7. Inserting Page Breaks in Tables (Sorry, No Page Breaks in Crosstabs)
      8. Exporting Your Report to Another Application
      9. Summary
    4. Chapter 9: Using Discoverer to Analyze Data
      1. What Is Analysis?
      2. Types of Analysis
        1. Statistical Analysis
        2. Classification Analysis
        3. Deviation Analysis
        4. Trend Analysis
        5. Aging Analysis
      3. Fundamentals of Analysis
      4. An Analysis Workflow
      5. Core Examples Used in This Chapter
      6. Description of the Analysis Tools Available
        1. Turning a Tool On and Off
      7. The Analysis Toolbar Buttons
        1. Totals Area
        2. Crosstabs Are Great to Analyze
        3. Percentage Area
        4. Operators Area
        5. Conditions Area
        6. Finding Exceptions Using Formatting
      8. How to Build the Example Queries
        1. Statistical Analysis
        2. Classification Analysis
        3. Deviation Analysis
        4. Trend Analysis
        5. Aging Analysis
      9. Overcoming the Manager Who Is Wary of Your Analysis
      10. Summary
    5. Chapter 10: Using Discoverer Viewer to See Your Data
      1. Why Use Viewer?
        1. The Benefits of Viewer
        2. Extra Viewer Features
        3. The Connect Page
        4. The Worksheet List
        5. The Main Viewer Page
      2. The Table or Crosstab Display Area
        1. Tools
        2. Sort
        3. Rows and Columns
      3. Hyper-Drilling
      4. Graphs
        1. Drilling in Graphs
      5. Setting Up User Preferences in Viewer
        1. Query Governor
        2. Measure Units
        3. Axis Labels
        4. Summary Data
      6. Summary
  11. Part III: Advanced Discoverer Techniques
    1. Chapter 11: Refining Items, Drilling, and Hyper-Drilling
      1. Refining Query Items
        1. Adding and Removing Items
        2. Common Problems Associated with Adding or Removing Items
      2. Pivoting and Drilling
        1. Pivoting Data
        2. Duplicating Tables and Crosstabs as New Worksheets
        3. Renaming Worksheets
        4. Drilling Into and Out of Data
        5. Drilling into Data from a Graph
      3. Hyper-Drilling
        1. Drilling Out to Another Worksheet
        2. Drilling Out to a URL
        3. Drilling Out to an Application
      4. Summary
    2. Chapter 12: Building Effective Conditions
      1. Adding Conditions
        1. Using Show Values to Add a Condition in Desktop
        2. Adding Conditions Using the Toolbar
        3. Using the Conditions Dialog Box to Add a Condition in Desktop and Plus
      2. The Basic Components of a Condition
        1. Basic Component 1: The Item
        2. Basic Component 2: The Expression
        3. Basic Component 3: The Value
      3. Editing an Existing Condition
      4. Using Advanced Conditions
        1. Creating Conditions Based on Calculations
        2. Creating Conditions Based on Conditions
        3. Using Boolean Operators
        4. Using Subqueries
      5. Removing Conditions
        1. Permanently Removing Conditions
        2. Deactivating a Condition
      6. Removing Columns Upon Which Conditions Are Based
        1. Removing a Database Item Used in Conditions
        2. Removing Calculations Used in Conditions
        3. Deleting Calculations Used in Conditions
      7. Summary
    3. Chapter 13: Refining Parameters, Calculations, Sorting, and Percentages
      1. Refining Parameters
        1. Changing a Condition to a Parameter
        2. Creating a Condition from a Parameter
        3. Creating Instant Parameters
        4. Dynamic Parameters
        5. Mandatory and Optional Parameters
        6. Parameter Support for Keywords
        7. Activating and Deactivating Parameters
        8. Cascading Parameters
        9. Editing Parameters
        10. Using Parameters in the Title, Header, or Footer
      2. Refining Calculations
        1. Main Components of a Calculation
        2. Define the Calculation in Advance
        3. Housekeeping After Editing a Calculation
        4. Using Standard Functions in a Query
        5. Calculating Standard Margin and Markup
        6. Ambiguous or Duplicate Item Names
        7. Activating and Deactivating Calculations
      3. Refining the Sort Order
        1. Sort Order Manipulation
        2. Deleting a Sort Using the Sort Tab
      4. Refining Percentages
        1. Using COUNT and Percentages in a Crosstab
        2. Workflow to Change a Percentage
        3. Workflow to Delete a Percentage
        4. Activating and Deactivating Percentages
      5. Summary
    4. Chapter 14: Managing Queries
      1. The Discoverer Manager and the End User
        1. Managing Libraries
      2. Sharing Workbooks with Other Users
        1. Superuser Involvement with Shared Workbooks
        2. How to Share a Workbook
        3. Using a Shared Workbook
        4. How to Open a Shared Workbook
      3. Workbook Manipulation
        1. Deleting Workbooks from the Database
        2. Managing Workbook Descriptions and Identifiers
      4. Worksheet Manipulation
        1. Reordering Worksheets
        2. Renaming Worksheets
        3. Deleting Worksheets
        4. Adding a Description to a Worksheet
        5. Copying and Moving Worksheets Between Workbooks
        6. Finding Data in Your Worksheet Results
      5. Scheduling Workbooks
        1. The Benefit of Scheduling Workbooks
        2. How to Schedule a Workbook
        3. How to Share the Results of a Scheduled Workbook
        4. Viewing Results
        5. Unscheduling a Scheduled Workbook
        6. Editing a Scheduled Workbook
        7. Security
        8. Third-Party Scheduling
      6. Running Discoverer Desktop from the Command Line
        1. Running Discoverer from the Command Line
      7. SQL Management
        1. Viewing SQL
        2. Viewing the Explain Plan
        3. Exporting SQL
        4. Importing SQL
        5. Structured SQL
      8. E-mailing Worksheets and Reports
        1. To Send a Discoverer Workbook via E-mail
      9. Summary
    5. Chapter 15: Setting Up User Preferences, the Toolbar, and Working with the Discoverer Administrator
      1. Customizing User Preferences
      2. Desktop Options
        1. General
        2. Query Governor
        3. Table/Crosstab
        4. Formats
        5. Cache Settings
        6. Connection
        7. Advanced
        8. EUL
      3. Plus Options
        1. General
        2. Query Governor
        3. Sheet Format
        4. Formats
        5. Advanced
        6. EUL
      4. The Toolbar
        1. The Discoverer Desktop Toolbar
        2. The Discoverer Plus Toolbar
      5. The Discoverer Administrator
        1. The Discoverer Administrator’s Role
        2. You Can Help Your Discoverer Administrator Identify the Data Needed
        3. What Can the Discoverer Administrator Do for You?
        4. Discoverer Desktop Directory Structures
      6. Summary
  12. Part IV: Using the Discoverer Administration Edition
    1. Chapter 16: Getting Started in the Administration Edition
      1. Key Definitions
        1. End User Layer
        2. Business Areas
        3. Axes
        4. Item Classes
        5. Hierarchies
        6. Summaries
        7. Properties
      2. Sticky Features
      3. The Steps to a Successful Discoverer Implementation
        1. Understand and Anticipate User Requirements
        2. Create the End User Layer
        3. Create a Business Area
        4. Refine the Business Area
        5. Granting Access to the Business Areas
        6. Deploy
      4. Source to Destination
        1. Source Database
        2. Destination Schema
      5. Creating the End User Layer
        1. New User Privileges
        2. Software Installation
        3. Create the EUL
      6. Creating Your First Business Area
        1. Load Wizard Step 1: Create or Open a Business Area
        2. Load Wizard Step 2: Select the Schema
        3. Load Wizard Step 3: Select the Objects to Use
        4. Load Wizard Step 4: Define the Import Options
        5. Load Wizard Step 5: Name the Business Area and Provide Final Preferences
      7. Key Business Area Objects
      8. Checking a Business Area
        1. Check the Business Area Name, Description, and Identifier
        2. Check the Folder Names, Descriptions, and Identifiers
        3. Check the Order of the Folders
        4. Check the Names of the Items
        5. Check the Order of the Items
        6. Check Default Positions
        7. Check Item Aggregation
        8. Check Default Formats
      9. Summary
    2. Chapter 17: Editing the Business Area
      1. Remaining Business Area Checks
        1. Review Folder Names
        2. Managing Lists of Values
        3. Managing Joins
      2. Enhancing Business Areas
        1. Folder Enhancements
        2. Managing Folder Properties
        3. Hierarchy Enhancements
        4. Item Management
        5. Types of Items
        6. Useful Algorithms
        7. Adding Items to a Complex Folder
        8. Sorting Items
        9. Descriptive Lists of Values: Assigning Indexes to an Item
      3. Summary
    3. Chapter 18: Interacting with the End User
      1. Adding New Users
      2. Granting Access to Business Areas
        1. Open Access
        2. Restricted Access and Insider Trading
        3. Workflow to Grant Access
      3. Granting User Edition Privileges
        1. Working with the Privileges Tab
        2. Working with the User/Role or User/Responsibility Tab
        3. Working with the Query Governor Tab
        4. Discoverer Privileges Explained
      4. Adding Meaningful Descriptions to Business Areas, Folders, and Data Items
        1. Adding a Meaningful Description to a Business Area
        2. Adding a Meaningful Description to a Folder
        3. Adding a Meaningful Description to an Item
      5. Adding New Items to Folders
        1. Adding New Items to Simple Folders
        2. Adding New Items to Complex Folders
        3. Adding New Items to Custom Folders
      6. Creating New Folders
      7. Creating Joins Between Folders
      8. Creating Lists of Values
      9. Creating Alternative Sorts
      10. Creating New Items Based on Calculations
      11. Creating New Conditions
        1. Deleting Predefined Conditions
      12. Creating Drill Hierarchies
      13. Modifying an Item’s Type
      14. Creating Summary Data
      15. Rearranging the Order of Folders in a Business Area
      16. Rearranging the Order of Items in a Folder
      17. Changing Refresh Cycles
      18. Allowing Scheduling of Workbooks
        1. Scheduling Privileges
        2. Enabling Scheduling
        3. Storing Workbook Results
        4. Setting Up a Scheduled Workbook Results User
        5. Managing Scheduled Workbooks
        6. List of Scheduled Statuses
      19. Creation of New Functions
        1. Working with Optional Arguments
      20. Summary
    4. Chapter 19: Configuring Discoverer
      1. Architecture
        1. Discoverer Client Tier
        2. Discoverer Middle Tier
        3. Discoverer Database Tier
      2. Discoverer Installation Types
      3. Starting the Discoverer Components
      4. Starting WebLogic Server and Node Manager
        1. Starting WebLogic Server
        2. Automating Your WebLogic Server Login Credentials
        3. Starting WebLogic Node Manager
        4. Starting the Discoverer Managed Server
        5. Starting the Discoverer OPMN Managed Components
        6. Confirming That Discoverer Has Started
      5. Oracle Process Management and Notification (OPMN)
        1. OPMN Basic Commands
      6. Oracle Fusion Middleware Control
        1. Oracle Fusion Middleware Components
        2. Connecting to Fusion Middleware Control
      7. Oracle HTTP Server
        1. Key Apache Directives
        2. Key Oracle HTTP Server Modules
        3. Manual Oracle HTTP Server Configuration
        4. Using Fusion Middleware Control to Manage OHS
      8. Oracle Web Cache
        1. Using Fusion Middleware Control to Manage Web Cache
        2. Maintaining the Web Cache Passwords
        3. Configuring Viewer with Web Cache
        4. Configuring Discoverer for High Availability
      9. Single Sign-On (SSO)
        1. Configuring Single Sign-On
        2. Enabling Discoverer with SSO
      10. Summary
    5. Chapter 20: Advanced Discoverer Administration
      1. Oracle Fusion Middleware Control
        1. Oracle Fusion Middleware Components
        2. Connecting to Fusion Middleware Control
      2. Using Fusion Middleware Control to Manage Discoverer
        1. Components Area: Discoverer Viewer Link
        2. Components Area: Discoverer Plus Link
        3. Components Area: Discoverer Portlet Provider Link
        4. Components Area: Discoverer Web Services Link
        5. Discoverer Drop-Down Menu
      3. Configuring Discoverer Using the System MBean Browser
      4. Discoverer User Preferences
        1. Discoverer Preference Server
        2. Changing Preferences by a User
        3. Changing Global User Preferences Using pref.txt
        4. Changing User Preferences Using the Command Line
        5. Listing of User Preferences
        6. Setting the Timeout Value for Discoverer
      5. Optimizing Discoverer for Optimal Performance
        1. Scaling Discoverer for Optimal Performance
        2. Using Worksheets and Page Items Appropriately
        3. Setting Preferences for Optimal Performance
        4. Using Summary Folders for Optimal Performance
        5. Basing Lists of Values on Tables with Distinct Values
        6. Using Web Cache with Discoverer Viewer
        7. Load Balancing
        8. Performance Troubleshooting
      6. Starting Discoverer Using URL Parameters
        1. URL Parameter Syntax
        2. Specifying Login Information Using URL Parameters
        3. URL Parameter Examples
        4. List of URL Parameters
      7. Migrating Discoverer to OBIEE
        1. Similarities with Discoverer
        2. Discoverer to OBIEE Migration Assistant
        3. Known Issues Migrating Discoverer to OBIEE
        4. OBIEE Mappings from Discoverer Administrator
      8. Summary
    6. Chapter 21: Analytic Functions
      1. What Are Analytic Functions?
      2. Business Questions
      3. Essential Concepts
        1. Discoverer Processing Order
        2. Partitions
        3. Windows
        4. Current Row
      4. Using Analytic Functions
        1. Creating a Ranking Report
        2. Creating a Running Total Report
        3. Creating a Top n/Bottom n Report
        4. Creating a Report to Compare This Year to Last Year
        5. Creating a Three-Month Rolling-Average Report
        6. Creating Previous- and Next-Value Reports
      5. Editing Analytical Functions
        1. Editing the Rank
        2. Editing the Running Total
      6. Sequencing of Conditions
      7. Windowing Options
        1. Explicit Windows
        2. Dynamic Windows
      8. The Power of Analytics
      9. Summary
  13. Part V: Appendixes
    1. Appendix A: Michael’s Gold Mine of Answers to FAQs
      1. Summary
    2. Appendix B: SQL Functions
      1. Standards Used in the Listing
      2. Wildcards
        1. Wildcard Examples
      3. Folders in Discoverer
      4. Alphabetical Listing of Functions
        1. + (Addition)
        2. – (Subtraction)
        3. * (Multiplication)
        4. / (Division)
        5. || (Concatenation)
        6. ABS (Absolute Value)
        7. ACOS
        8. ADD_MONTHS
        9. ASCII
        10. ASCIISTR
        11. ASIN
        12. ATAN
        13. ATAN2
        14. AVG (Average)
        15. AVG_DISTINCT
        16. CASE
        17. CEIL
        18. CHARTOROWID
        19. CHR (Character)
        20. COALESCE
        21. CONCAT
        22. CONVERT
        23. CORR (Correlation)
        24. COS (Cosine)
        25. COSH (Hyperbolic Cosine)
        26. COUNT
        27. COUNT_DISTINCT
        28. COVAR_POP
        29. COVAR_SAMP
        30. CUME_DIST
        31. CURRENT_DATE
        32. DBTIMEZONE
        33. DECODE
        34. DENSE_RANK
        35. DUMP
        36. EUL_DATE_TRUNC
        37. EXP (Exponential)
        38. FIRST_VALUE
        39. FLOOR
        40. GLB
        41. GREATEST
        42. GREATEST_LB
        43. HEXTORAW
        44. INITCAP (Initial Capitals)
        45. INSTR
        46. INSTRB
        47. LAG
        48. LAST_DAY
        49. LAST_VALUE
        50. LEAD
        51. LEAST
        52. LEAST_UB
        53. LENGTH
        54. LENGTHB
        55. LN (Logarithm)
        56. LOG
        57. LOWER
        58. LPAD (Left Pad)
        59. LTRIM (Left Trim)
        60. LUB
        61. MAX (Maximum)
        62. MAX_DISTINCT
        63. MIN (Minimum)
        64. MIN_DISTINCT
        65. MOD (Modulus)
        66. MONTHS_BETWEEN
        67. NEW_TIME
        68. NEXT_DAY
        69. NLSSORT
        70. NLS_INITCAP
        71. NLS_LOWER
        72. NLS_UPPER
        73. NTILE
        74. NULLIF
        75. NUMTODSINTERVAL
        76. NUMTOYMINTERVAL
        77. NVL
        78. NVL2
        79. PERCENTILE_CONT (Percentile Continuous)
        80. PERCENTILE_DISC (Percentile Discrete)
        81. PERCENT_RANK
        82. POWER
        83. RANK
        84. RATIO_TO_REPORT
        85. RAWTOHEX
        86. REGR_xxx (Linear Regression)
        87. REGR_AVGX
        88. REGR_AVGY
        89. REGR_COUNT
        90. REGR_INTERCEPT
        91. REGR_R2
        92. REGR_SLOPE
        93. REPLACE
        94. ROUND (for Dates)
        95. ROUND (for Numbers)
        96. ROWCOUNT
        97. ROWIDTOCHAR
        98. ROWNUM
        99. ROW_NUMBER
        100. RPAD (Right Pad)
        101. RTRIM (Right Trim)
        102. SESSIONTIMEZONE
        103. SIGN
        104. SIN (Sine)
        105. SINH (Hyperbolic Sine)
        106. SOUNDEX
        107. SQRT (Square Root)
        108. STDDEV (Standard Deviation)
        109. STDDEV_DISTINCT (Distinct Standard Deviation)
        110. STDDEV_POP
        111. STDDEV_SAMP
        112. SUBSTR (Substring)
        113. SUBSTRB
        114. SUM
        115. SUM_DISTINCT
        116. SUM_SQUARES
        117. SYSDATE (System Date)
        118. TAN (Tangent)
        119. TANH (Hyperbolic Tangent)
        120. TO_CHAR (Dates)
        121. TO_CHAR (Labels)
        122. TO_CHAR (Numbers)
        123. TO_DATE
        124. TO_LABEL
        125. TO_MULTI_BYTE
        126. TO_NUMBER
        127. TO_SINGLE_BYTE
        128. TRANSLATE
        129. TRUNC (Dates)
        130. TRUNC (Numbers)
        131. UID
        132. UPPER
        133. USER
        134. USERENV
        135. VARIANCE
        136. VARIANCE_DISTINCT
        137. VAR_POP (Population Variance)
        138. VAR_SAMP (Sample Variance)
        139. VSIZE
        140. WIDTH_BUCKET
      5. Time Zones
      6. Using Formats When Rounding Dates
      7. Date Format Masks
        1. Day Format Masks
        2. Month Format Masks
        3. Year Format Masks
        4. Other Date Masks
        5. Time Format Masks
        6. Special Format Masks
        7. Prefixes and Suffixes
      8. Number Format Masks
      9. ASCII Character Set
      10. Summary
    3. Appendix C: Databases and Views
      1. Database Schemas
        1. Relational Schemas
        2. Star Schemas
      2. Accessing E-Business Suite Using Discoverer
        1. E-Business Suite Business Views
        2. NoetixViews
        3. Company-Built Views
        4. Embedded Data Warehouse
      3. Summary
    4. Appendix D: Tutorial Database
      1. Entity-Relationship Diagram for the Global Widgets Sales Database
      2. The Global Widgets Tables
        1. GS Sales
        2. GS Channel
        3. GS Products
        4. GS Prodline
        5. GS Customer
        6. GS City
        7. GS District
        8. GS Regsion
        9. Fiscal Time
        10. GS Day
        11. GS Month
        12. GS Quarter
        13. GS Year
      3. Entity-Relationship Diagram for the Fan Trap
      4. The Fan Trap Tables
        1. FAN Department
        2. FAN Budget
        3. FAN Expenses
      5. Summary
  14. Index