Oracle business intelligence discoverer 11g handbook

Oracle business intelligence discoverer 11g handbook

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,...

Descripción completa

Detalles Bibliográficos
Otros Autores: Armstrong-Smith, Michael, author (author), Armstrong-Smith, Darlene, author
Formato: Libro electrónico
Idioma:Inglés
Publicado: New York : McGraw-Hill Education [2014]
Edición:1st edition
Materias:
Business > Computer programs.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628130506719
Tabla de Contenidos:
  • Cover
  • Title Page
  • Copyright Page
  • About the Authors
  • About the Technical Editor
  • Contents at a Glance
  • Contents
  • Acknowledgments
  • Introduction
  • How This Book Is Organized
  • Part I: Getting Started with Discoverer
  • Chapter 1: An Overview of Discoverer
  • Business Intelligence and Your Organization
  • Your Discoverer Investment
  • Connecting to Other Databases
  • Business Intelligence and Trends
  • Recent Business Intelligence Trends and Discoverer
  • Discoverer's Role in Business Intelligence
  • The Nine Parts of Discoverer
  • How to Use This Book
  • Example Database
  • A New Direction in Reporting
  • The Discoverer Interface
  • Ad Hoc Queries vs. Predefined Queries
  • Getting Help with Discoverer
  • Summary
  • Chapter 2: Users and Databases
  • What Starts Right Stays Right
  • The Responsibility of the End User
  • Your Business
  • Your Reporting Requirements
  • Your Database
  • The Discoverer Library Concept
  • The Definition of a Library
  • The Definition of a Library Manager
  • The Report Writer Concept
  • The Definition of a Report Writer
  • The Benefits of Having Report Writers
  • The Benefits of Being a Report Writer
  • Choosing Your Report Writers
  • Summary
  • Chapter 3: Getting Started in Discoverer
  • Key Personnel
  • Discoverer Manager
  • Library Manager
  • Database Administrator
  • E-Business Suite Administrator
  • Report Writers
  • Gaining Access to Discoverer
  • Key Definitions
  • Workbooks and Worksheets
  • Queries
  • Reports
  • Libraries
  • Sticky Features
  • Main Features of Discoverer
  • Discoverer Login Sequence
  • Connecting Using Discoverer Desktop
  • Launching 11g Discoverer Plus or Viewer
  • Starting a Workbook
  • Summary
  • Chapter 4: The Workbook Wizard: The Essential Steps
  • The Workbook Wizard
  • The Workbook Wizard Steps
  • A Simple Workflow
  • The Workbook Wizard Options.
  • Workbook Wizard Step 1: Creating a New Workbook or Opening an Existing Workbook
  • Workbook Wizard Step 2: Selecting the Data
  • Workbook Wizard Step 3: Arranging the Order of the Output
  • Workbook Wizard Step 4: Setting User-Defined Conditions
  • The Query from the Twilight Zone and How to Avoid It
  • Viewing the Results
  • Saving the Query
  • Summary
  • Chapter 5: The Workbook Wizard: The Optional Steps
  • The Text Area in Plus
  • The Optional Steps of the Workbook Wizard
  • Workbook Wizard Step 5: Creating a Sort Order (Tables Only)
  • Sorting: What Is It?
  • Creating a New Sort
  • Quick Sorting
  • Refining a Sort
  • Building a Group Sort
  • Adding Another Sort
  • Rearranging the Sort Order
  • Why Not Sort in the Wizard?
  • Workbook Wizard Step 6: Creating User-Defined Calculations
  • Desktop Calculations Screen
  • Plus Calculations Tab
  • Calculations: What Are They?
  • Creating a Calculation in Desktop
  • Creating a Calculation in Plus
  • Understanding Calculations
  • Why Not Calculate in the Wizard?
  • Discoverer Plus Workbook Wizard Remaining Steps
  • Creating User-Defined Percentages in the Plus Workbook Wizard
  • Percentages: What Are They?
  • Creating a New Percentage
  • Examples of Percentages
  • Why Not Perform Percentages in the Wizard?
  • Creating User-Defined Totals in the Plus Workbook Wizard
  • Totals: What Are They?
  • Creating a New Total
  • Labeling Percentages and Totals
  • Creating User-Defined Parameters in the Plus Workbook Wizard
  • Parameters: What Are They?
  • Differences Between Conditions and Parameters
  • Creating a New Parameter
  • Rearranging the Parameter Order
  • Why Not Create Parameters in the Wizard?
  • Editing the Sheet After the Query Has Run
  • Summary
  • Part II: Editing the Query
  • Chapter 6: Formatting the Output in Discoverer Desktop and Plus
  • Giving Your Headings Meaningful Names (Desktop and Plus).
  • How to Rename Columns in Desktop
  • How to Rename Columns in Plus
  • Rearranging the Order of the Output
  • How to Rearrange Columns
  • Formatting Data
  • Formatting Tools
  • Format Data Dialog Box
  • Formatting Columns
  • Formatting Column Headings
  • Formatting Multiple Headings and Columns in Plus
  • Deleting Columns from a Worksheet
  • How to Delete a Column
  • Resizing Columns
  • Formatting Totals
  • Formatting Totals Using the Format Data Dialog Box
  • Formatting Totals from the Formatting Bar
  • Formatting Exceptions
  • Adding a Title to Your Query
  • Editing the Title
  • Suppressing a Title from Displaying
  • Adding a Background Bitmap (Desktop Only)
  • Setting a Background
  • Clearing a Background
  • Summary
  • Chapter 7: Using Graphs to Present Data
  • The Available Graph Styles
  • Bar (Desktop and Plus)
  • Combination (Plus Only)
  • Cube (Grouped with 3-D Options in Plus)
  • Doughnut (Desktop), Ring (Grouped with Pie in Plus)
  • Horizontal Bar (Desktop and Plus)
  • Line (Desktop and Plus)
  • Pie (Desktop and Plus)
  • The Discoverer Desktop Graph Window
  • The Features of the Discoverer Desktop Graph Window
  • Creating a Graph in Desktop
  • The Desktop Graph Wizard
  • Graphing in Discoverer Plus
  • Creating a Graph in the Plus Workbook Wizard
  • Creating a Graph in Plus after a Query Has Been Generated
  • Modifying a Graph in Plus
  • Modifying a Graph in Desktop
  • To Modify the Graph from the Worksheet
  • To Modify the Graph from the Graph Window
  • Summary
  • Chapter 8: Turning a Discoverer Query into a Report
  • A Workflow for Building Reports
  • Report Workflow
  • Formatting the Report for Printing
  • Print Setup in Desktop
  • Print Setup in Plus
  • Page Setup
  • The Sheet Tab in Desktop
  • The Worksheet Tab in Plus
  • The Table/Crosstab Tab in Plus
  • Headers and Footers
  • Table and Crosstab Gridlines
  • Table Gridlines.
  • Crosstab Gridlines
  • Inserting Page Breaks in Tables (Sorry, No Page Breaks in Crosstabs)
  • Exporting Your Report to Another Application
  • Summary
  • Chapter 9: Using Discoverer to Analyze Data
  • What Is Analysis?
  • Types of Analysis
  • Statistical Analysis
  • Classification Analysis
  • Deviation Analysis
  • Trend Analysis
  • Aging Analysis
  • Fundamentals of Analysis
  • An Analysis Workflow
  • Core Examples Used in This Chapter
  • Description of the Analysis Tools Available
  • Turning a Tool On and Off
  • The Analysis Toolbar Buttons
  • Totals Area
  • Crosstabs Are Great to Analyze
  • Percentage Area
  • Operators Area
  • Conditions Area
  • Finding Exceptions Using Formatting
  • How to Build the Example Queries
  • Statistical Analysis
  • Classification Analysis
  • Deviation Analysis
  • Trend Analysis
  • Aging Analysis
  • Overcoming the Manager Who Is Wary of Your Analysis
  • Summary
  • Chapter 10: Using Discoverer Viewer to See Your Data
  • Why Use Viewer?
  • The Benefits of Viewer
  • Extra Viewer Features
  • The Connect Page
  • The Worksheet List
  • The Main Viewer Page
  • The Table or Crosstab Display Area
  • Tools
  • Sort
  • Rows and Columns
  • Hyper-Drilling
  • Graphs
  • Drilling in Graphs
  • Setting Up User Preferences in Viewer
  • Query Governor
  • Measure Units
  • Axis Labels
  • Summary Data
  • Summary
  • Part III: Advanced Discoverer Techniques
  • Chapter 11: Refining Items, Drilling, and Hyper-Drilling
  • Refining Query Items
  • Adding and Removing Items
  • Common Problems Associated with Adding or Removing Items
  • Pivoting and Drilling
  • Pivoting Data
  • Duplicating Tables and Crosstabs as New Worksheets
  • Renaming Worksheets
  • Drilling Into and Out of Data
  • Drilling into Data from a Graph
  • Hyper-Drilling
  • Drilling Out to Another Worksheet
  • Drilling Out to a URL
  • Drilling Out to an Application
  • Summary.
  • Chapter 12: Building Effective Conditions
  • Adding Conditions
  • Using Show Values to Add a Condition in Desktop
  • Adding Conditions Using the Toolbar
  • Using the Conditions Dialog Box to Add a Condition in Desktop and Plus
  • The Basic Components of a Condition
  • Basic Component 1: The Item
  • Basic Component 2: The Expression
  • Basic Component 3: The Value
  • Editing an Existing Condition
  • Using Advanced Conditions
  • Creating Conditions Based on Calculations
  • Creating Conditions Based on Conditions
  • Using Boolean Operators
  • Using Subqueries
  • Removing Conditions
  • Permanently Removing Conditions
  • Deactivating a Condition
  • Removing Columns Upon Which Conditions Are Based
  • Removing a Database Item Used in Conditions
  • Removing Calculations Used in Conditions
  • Deleting Calculations Used in Conditions
  • Summary
  • Chapter 13: Refining Parameters, Calculations, Sorting, and Percentages
  • Refining Parameters
  • Changing a Condition to a Parameter
  • Creating a Condition from a Parameter
  • Creating Instant Parameters
  • Dynamic Parameters
  • Mandatory and Optional Parameters
  • Parameter Support for Keywords
  • Activating and Deactivating Parameters
  • Cascading Parameters
  • Editing Parameters
  • Using Parameters in the Title, Header, or Footer
  • Refining Calculations
  • Main Components of a Calculation
  • Define the Calculation in Advance
  • Housekeeping After Editing a Calculation
  • Using Standard Functions in a Query
  • Calculating Standard Margin and Markup
  • Ambiguous or Duplicate Item Names
  • Activating and Deactivating Calculations
  • Refining the Sort Order
  • Sort Order Manipulation
  • Deleting a Sort Using the Sort Tab
  • Refining Percentages
  • Using COUNT and Percentages in a Crosstab
  • Workflow to Change a Percentage
  • Workflow to Delete a Percentage
  • Activating and Deactivating Percentages
  • Summary.
  • Chapter 14: Managing Queries.

Ejemplares similares