Oracle - Course Details

HIR1111RDE Hyperion Interactive Reporting 11.1.1 Reports Dashboards Essentials

Oracle Course Description:
you learn advanced reporting techniques, including how to create drill paths, how to implement row-level security, and how to create various computed items. Next, 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:
5 DAYS
Oracle Course Target Audience:
Business Analysts,Reports Developer,Technical Consultant
Oracle Course Prerequisite:
Some knowledge of data warehouse and database concepts,Familiarity with Windows conventions,Working knowledge of SQL,Knowledge of data warehouse design principles
Course Content:
  • Product Overview

    • Oracle’s Enterprise Performance Management System
    • Oracle Business Intelligence Suite Enterprise Edition Plus
    • Oracle Hyperion Product Components
    • Hyperion Interactive Reporting Architecture

  • Viewing Documents

    • Opening and Saving Documents
    • Navigating Documents
    • Refreshing Data and Organizing Sections
    • E-mailing and Printing Documents
    • Viewing Reports in Other Applications

  • Querying Data Sources

    • Querying Overview
    • Requesting Data
    • Filtering Data
    • Sorting Data
    • Aggregating Data
    • Controlling Query Processing

  • Creating Table Reports

    • Results and Table Sections Overview
    • Populating Table Reports with Data
    • Filtering Data
    • Sorting Data
    • Creating Totals
    • Formatting Data
    • Formatting Pages

  • Creating Pivot Reports

    • Populating Pivot Reports with Data
    • Adding Focus to Pivot Reports
    • Creating Totals
    • Formatting Data
    • Drilling into Data
    • Creating Chart Reports from Pivot Reports

  • Creating Chart Reports

    • Populating Chart Reports with Data
    • Adding Focus to Chart Reports
    • Modifying Chart Properties
    • Formatting Data
    • Drilling into Data
    • Creating Pivot Reports from Chart Reports

  • Creating Band-Style Reports

    • Populating Band-Style Reports with Data
    • Adding Focus to Band-Style Reports
    • Displaying Totals
    • Modifying Report Properties
    • Formatting Data
    • Adding Graphics to Reports
    • Embedding Pivot and Chart Reports
    • Formatting Pages

  • Workspace Overview

    • Workspace Modules
    • 508 Compliance
    • Opening, refreshing and saving documents
    • Synchronizing repository content
    • Importing a report into workspace
    • Roles and adaptive States
    • Users and groups

  • Dashboards Overview

    • Dashboard Types
    • Dashboard Benefits
    • Dashboard Content
    • Dashboard Features

  • Creating Dashboards in Workspace with the WebDash Template

    • WebDash Template Overview
    • Importing Documents into the WebDash Template
    • Build Dashboard Configuration Frame
    • Creating Local Filters
    • Creating Frames
    • Populating Frames
    • Modifying Frames
    • Viewing Dashboards

  • Creating Dashboards with Dashboard Studio

    • Dashboard Studio Wizard Overview
    • Creating and Populating Frames
    • Configuring Navigation
    • Configuring Filter Drop-down Lists
    • Configuring Dashboard Properties
    • Configuring Styles
    • Saving Master Documents

  • Configuring Dashboard Options

    • Creating Quick Filters
    • Creating Quick Slices
    • Creating Spotlighted Charts
    • Creating Links to Related Documents
    • Creating Wide Views
    • Configuring Hidden Facts in Pivot Reports
    • Configuring Sort Options in Pivot and Chart Reports
    • Creating Annotations

  • Creating Gauges and Live Charts

    • Selecting dashboard gauge types
    • Creating active dashboard reports
    • Configuring shortcut menus
    • Manipulating active dashboard reports

  • 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