Oracle - Course Details

HIR1111:DAR Hyperion Interactive Reporting 11.1.1: Design Advanced Reports

Oracle Course Description:
you learn how to import Interactive Reporting content into Workspace, create shared Workspace pages, and run and schedule Interactive Reporting jobs. Finally, you learn how to maintain documents by using the Optimize Utility.
Oracle Course Duration:
Oracle Course Target Audience:
Reports Developer,Technical Consultant
Oracle Course Prerequisite:
Hyperion Interactive Reporting 11.1.1: Design Reports Dashboards course or equivalent knowledge of the subject matter,Working knowledge of SQL,Knowledge of data warehouse design principles
Course Content:
  • Creating Connection Files

    • About Connection Files
    • Creating Basic Connection Files
    • Setting Advanced Options
    • Configuring Metadata

  • Creating Data Models

    • Interactive Reporting Architecture
    • Report Development Process
    • Database Terminology and Star Schema Design Principles
    • Adding Topics to Data Models
    • Joining Topic Items in Data Models

  • Enhancing Data Models

    • Modifying Topic and Item Properties
    • Setting Query Governors and Global Filters
    • Creating Meta Topics and Master Data Models
    • Synchronizing Data Models with Databases

  • Creating Complex Queries

    • Creating Local Joins
    • Creating Filter Local Joins
    • Creating Derived Tables
    • Processing Results to Database Tables
    • Merging Result Sets with Query Operators
    • Creating Subqueries
    • Creating Correlated Subqueries
    • Exporting, Importing, and Customizing SQL

  • Creating Complex Reports

    • Defining Drill Paths
    • Displaying Multiple Results in Band-Style Reports
    • Implementing Row-Level Security

  • Creating Computed Items

    • Computed Items Overview
    • Creating Grouping Columns
    • Creating Computed Items with Strings, Dates, and Numbers
    • Defining Next and Prior Statements
    • Modifying Null Values
    • Filtering Computed Items
    • Defining If…Else Statements

  • Importing Interactive Reporting Documents into Workspace

    • Navigating the Workspace User Interface
    • User Provisioning Overview
    • Importing Content into Workspace
    • Importing Interactive Reporting Documents as Files
    • Working with Shared Workspace Pages

  • Creating and Scheduling Interactive Reporting Jobs in Workspace

    • Importing Interactive Reporting Documents as Jobs
    • Running Interactive Reporting Jobs on Demand
    • Scheduling Interactive Reporting Jobs
    • Managing Jobs

  • Optimizing Documents

    • Optimize Utility Overview
    • Loading Documents into the Optimize Utility
    • Renaming Sections with the Optimize Utility
    • Changing Parent Sections for Reports and Filters
    • Changing Parent Sections for Band-Style Reports
    • Locking Document Sections
    • Compacting Document Scripts