Oracle Business Intelligence Discoverer 11g Handbook

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