You are previewing Oracle Hyperion Interactive Reporting 11 Expert Guide.
O'Reilly logo
Oracle Hyperion Interactive Reporting 11 Expert Guide

Book Description


Learn Advanced Dashboards, JavaScript, Computations, and Special Topics from the Experts with this Oracle Hyperion Interactive Reporting book and eBook

  • Walk through a comprehensive example of a simple, intermediate, and advanced dashboard with a focus on Interactive Reporting best practices.

  • Explore the data analysis functionally with an in-depth explanation of built-in and JavaScript functions.

  • Build custom interfaces to create batch programs and exports for automated reporting.

  • Demonstrate expertise by learning to build a central code repository.

  • Explore merging through the Dashboard Studio and the beneficial features of the Dashboard Studio Optimize Utility.

  • Become an expert by mastering the concepts and examples presented in this book.

In Detail

Oracle Hyperion Interactive Reporting is one of many products in the Oracle Business Intelligence Enterprise Edition Plus software suite, an industry-leading business intelligence platform. The primary focus of the Interactive Reporting product is to provide strong relational querying and data analysis capabilities, where the software provides significant flexibility for creating custom dashboards, interfaces, and data analysis routines through the use of JavaScript programming and built-in software functionality. While Interactive Reporting is extremely flexible, performing advanced operations in the software is complicated and requires basic programming knowledge and an advanced understanding of the software. This book continues from where The Business Analyst’s Guide to Oracle Hyperion Interactive Reporting 11 completed and provides the reader with the information to successfully execute the advanced features of the product along with examples and specific techniques applicable to everyday use.

The Oracle Hyperion Interactive Reporting 11 Expert Guide provides software users and developers with many examples of the techniques used by software experts. The book begins with an introduction to leveraging advanced features of the project and an introduction to JavaScript. Dashboards are a major focus of the book with four chapters focused on building a simple to complex dashboard including functions, global objects, and syncing selections across dashboards. The book places an emphasis on learning methods for data analysis by using advanced programming and built-in functions, and a unique approach to using code to generate batch reports and exports is provided. The Dashboard Studio Optimize Utility and the Dashboard Studio Merge utility are explained in detail, and the approach to building and using a central code repository for use in dashboards and computations across multiple documents in an enterprise is demonstrated.

This book will help the reader become an expert user of the software, providing the skills necessary to understand, communicate, and perform advanced level tasks. The authors’ experience in developing and supporting Interactive Reporting users is very apparent throughout each chapter of the book. While the book displays content and examples from version 11 of the software, the book is also applicable to previous versions of the software dating back to version 8, so readers not currently using Interactive Reporting 11 will find the book applicable to daily use with the product.


Table of Contents

  1. Oracle Hyperion Interactive Reporting 11 Expert Guide
    1. Oracle Hyperion Interactive Reporting 11 Expert Guide
    2. Credits
    3. About the Authors
    4. Acknowledgments
    5. About the Reviewers
      1. Discounts
      2. Free eBooks
      3. Newsletters
      4. Code Downloads, Errata and Support
      5. Instant Updates on New Packt Books
    8. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Permissions
      5. Multidimensional queries
      6. Additional resources
      7. Conventions
      8. Reader feedback
      9. Customer support
        1. Downloading the example code
        2. Errata
        3. Piracy
        4. Questions
    9. 1. Advanced Hyperion Interactive Reporting Techniques
      1. Introduction to the Oracle Hyperion Interactive Reporting 11 Expert Guide
        1. Review of Interactive Reporting concepts
        2. An Introduction to JavaScript in Interactive Reporting
        3. Building simple to advanced dashboards
        4. Advanced computations
        5. Briefing slides and batch exports
        6. The Central Code Repository
        7. Optimizing and Merging
      2. The EPM Workspace
      3. Interactive Reporting interface and components
      4. Review of Interactive Reporting sections
      5. Leveraging code
        1. Query section Computed Items
        2. Results section Computed Items
        3. Table section Computed Items
          1. Pivot section Computed Items
          2. Pivot Settings: True Totals and Surface Values
          3. Editing Pivot Computed Items
          4. Chart section Computed Items
          5. Report section Computed Items
          6. The Expression line
        4. Document Scripts
        5. Dashboards
      6. The Scripting Interface
      7. Summary
    10. 2. Introduction to JavaScript and the Interactive Reporting API
      1. Introduction to objects and collections
      2. The Script Editor
      3. Introduction to JavaScript
        1. Variables
          1. Variable data types
            1. Boolean variables
            2. String variables
            3. Number variables
            4. Null variables
        2. Arrays
          1. Associative Arrays
          2. Functions
        3. Decision logic
          1. Comparison operators
          2. Conditional statements
          3. Logical operators
          4. Loops
        4. Regular expressions
      4. Summary
    11. 3. Creating a Simple Dashboard
      1. Dashboard planning and preparation
      2. The BMV USA Executive Dashboard Example
      3. Creating data-driven dashboard objects
        1. Creating a Vertical Stack Bar chart
            1. Creating the Chart Query
            2. Aggregated data facts
            3. Creating the Vertical Stack Bar chart
              1. Setting the legend
            4. Customizing a Vertical Stack Chart
              1. Visually stack the bars
              2. Maximizing chart display space
              3. Detail-oriented formatting
              4. Color considerations
        2. Creating a Bar-Line chart
            1. Creating the chart query
              1. Limiting the Query data
            2. Create the Bar-Line chart
              1. Switching bar and line facts
            3. Customizing the Bar-Line Chart
              1. Ignoring Null Values
              2. Turning off right values
              3. Line properties
              4. Customizing the grid
        3. Displaying pivots
          1. Creating a simple pivot
            1. Creating the parent query
              1. Limiting by YTD and country
              2. Renaming Request line items
          2. Ranking and Pivot Drill path configuration
            1. Displaying ranked dimensions
            2. Limiting Drill Anywhere paths
            3. Setting the default pivot formatting
            4. Overriding the default pivot formatting
      4. Creating a simple dashboard
        1. Adding dashboard objects
        2. Adding graphics and controls
          1. Adding custom images
          2. Adding Hyperlinks
        3. Basic interactivity
      5. Gauges
        1. Configuring gauges
        2. Gauge properties and color ranges
      6. Live Charts
        1. Configuring Live Charts
        2. Live Chart properties
      7. Summary
    12. 4. Introducing Dashboard Interactivity
      1. Dashboard Section Objects
        1. Graphics
        2. Controls
      2. Creating a Master Dashboard
        1. Placing Objects
        2. Implementing Custom Dashboard Navigation
          1. Scripting Internal Navigation
          2. External Navigation
      3. Creating Supporting Dashboard Sections
        1. Loading Dashboard Section
        2. Home Dashboard Section
        3. Detail Dashboard Sections
          1. Toggling Between Objects
          2. Modifying Element Facts
            1. Dynamic Section Formatting
      4. Document Start-up Scripts
        1. Loading Screen Script
        2. Understanding Toolbars and Menus
          1. Application Toolbars
          2. Application Menus
          3. Section Catalog
          4. Section Title Bar
        3. Prompting the User to Save
      5. Summary
    13. 5. Building the Dashboard Framework
      1. Understanding the Dashboard Framework
        1. Framework Naming Conventions
          1. Section Names
          2. Variable Names
          3. Function Names
          4. Dashboard Shape Names
        2. Understanding the JavaScript Workflow
      2. Implementing the Dashboard Framework
        1. Global Library Shapes
          1. Global Variables
        2. Framework Start-up Events
            1. Initializing the Loading Screen and Document Properties
            2. Declaring Global Library Shapes
            3. Calling Activation Events
        3. Activation Scripts
        4. Setting the Document Scripts on Start-up
      3. Understanding Document Save Options
        1. Save Query Results With Document
        2. Work Offline in Web Client
        3. Compress Document
          1. Setting Compression by Default
        4. Password Protect Document
        5. Password Protect Design Mode
      4. Summary
    14. 6. Advanced Dashboard Techniques
      1. Populating Dashboard Controls with Database-Driven Values
        1. Querying Available Values
          1. Appending Queries
            1. Query Request Items
        2. Staging the Results Set for Code
        3. Scripting the Function
          1. Determining the vDataName Variable
          2. Removing All Values from a LOV
          3. Adding a Custom LOV Value
          4. Customizing Results Section Limits
          5. Adding Values to the LOV Property
          6. Scripting a Default LOV Selection
          7. Completing the Function
          8. Calling gfPopulateFilterLOV
      2. Applying User-Selected Filters to Limit Data
        1. Preparation for Dynamic Limits
          1. Modify the Global Variables Shape
          2. Modifying the Query and Results Sections
        2. Applying Local Filters with JavaScript
          1. Applying a Drop Down Control Selection to a Local Filter
            1. Selecting All Values with a Drop Down
            2. Selecting Filters with a Drop Down
            3. Completing the Function
          2. Applying List Box Selections to a Local Filter
            1. Selecting All Values with a List Box
            2. Selecting Filters with a List Box
            3. Finalizing the Function
          3. Calling Functions with a Function
          4. Set the Function to the Dashboard Filter Object
      3. Synchronizing User Selections across Multiple Dashboards
        1. Synchronizing List Box Controls
          1. Unselecting Values
          2. Selecting Values
          3. Synchronizing Selections
        2. Calling the Functions
      4. Summary
    15. 7. Advanced Data Analysis
      1. Building Queries for Analysis
      2. Computed Items
        1. Building Advanced Computed Items
        2. Building the Definition using JavaScript
        3. Referencing Columns
        4. Functions
          1. Function Formatting Arguments
          2. Additional Help
        5. Options
        6. Deleting Computed Items
        7. Report section Computed Items
      3. Built-in Functions and Calculations
        1. Conditional Functions
        2. Date Manipulation
          1. Current Date & Time
          2. Adding Time
          3. Identifying Specific Days
          4. Date Conversion
          5. Leveraging Mathematical Operations with Dates
        3. Mathematical Operations
        4. Numeric Operations
        5. String Manipulation
        6. Statistical and Trending Operations
          1. Ranking
      4. Using JavaScript
        1. Variables and Functions in Computed Items
        2. Math Functions
          1. Random Number Generation
      5. Summary
    16. 8. Creating Briefing Slides and Executing Batch Exports
      1. Exporting document sections
        1. Exporting natively
        2. Exporting a single section (code)
          1. Export examples
          2. ExportToStream examples
        3. Exporting multiple sections (JavaScript code)
      2. Briefing slides
        1. Building the report for a briefing slide export
          1. Export code for briefing slides
      3. Executing batches of reports
        1. Batch processing example
          1. Batch processing code
          2. Refining the batch code to remove empty results sections
      4. Summary
    17. 9. The Central Code Repository
      1. Understanding the Central Code Repository
        1. Preparing the JavaScript code
        2. Table structure
      2. Configuring the CCR code table and query
        1. Querying the Central Code Repository (CCR)
          1. Creating the Query section
          2. Renaming the Query and Results sections
          3. Buidling the code DataModel
          4. Building the code query
      3. Building the Global Code Dashboard
        1. Creating the Global Code Dashboard
        2. Applying the code to objects
        3. Scripting the Document Startup Event
      4. Advanced concepts
        1. Report Type Grouping
        2. Enterprise Object Library
        3. Batch Report Creation
      5. Summary
    18. 10. Optimizing and Merging
      1. The Dashboard Studio
      2. Dashboard Studio: Merging sections
        1. Merging sections example
        2. Merging two documents into one
        3. Merging many documents into one
        4. Merging documents for users
          1. Merging presentation sections for users
      3. The Dashboard Studio Optimize Utility
        1. Interactive Reporting Studio swap shortcuts
        2. Filtering section types
        3. Editing Interactive Reporting documents
          1. Moving sections
          2. Showing and Cap Hiding
          3. Renaming and Deleting
          4. Locking and Unlocking
          5. Duplicatable and Unduplicatable
          6. Packing section code
        4. Moving objects and sections across Results
          1. Moving sections across Results or Table sections
          2. Modifying Report Dependencies
          3. Moving Filters
        5. Fixing corrupt files
      4. Summary