Hyperion Interactive Reporting 11.1.2: Design Advanced Reports

Total time

Hyperion Interactive Reporting 11.1.2: Design Advanced Reports

Oracle University
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

This class focuses on advanced developer tasks and concepts. On the first day, you create connections to various data sources and configure metadata. Using those connections, you build a variety of data models, including meta topics and master data models. Next, you learn advanced querying techniques, such as how to combine queries and utilize underlying SQL.

On the second day, 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. Finall…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Two Dimensional Design (2D Design), Data Warehouse, SQL & MySQL, Business Intelligence (BI), and PL/SQL.

This class focuses on advanced developer tasks and concepts. On the first day, you create connections to various data sources and configure metadata. Using those connections, you build a variety of data models, including meta topics and master data models. Next, you learn advanced querying techniques, such as how to combine queries and utilize underlying SQL.

On the second day, 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.

Learn To:

  • Create connection files
  • Create and modify data models
  • Create complex queries and reports
  • Work with Interactive Reporting content on the Web
  • Maintain Interactive Reporting content
  • Create computed items

* This course is also suitable for customers using Hyperion Interactive Reporting 11.1.1.


Audience
  • Business Analysts
  • Reports Developer
  • Technical Consultant

Course Topics 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

Course Objectives
  • Design complex queries and reports
  • Create computed items in documents
  • Configure connection files for data sources and metadata
  • Work with Interactive Reporting content in Workspace
  • Maintain Interactive Reporting documents with the Optimize Utility
  • Create and administer data models

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.