HYPERION INTERACTIVE REPORT

HYPERION INTERACTIVE REPORT

Overview:
Oracle Hyperion Interactive Reporting (Interactive Reporting) software is a module of Oracle Business Intelligence Oracle Hyperion Interactive Reporting is one of the main products in the Oracle Business Intelligence Learn Query and report building, and dashboard building Create tabular, pivot, chart, and band-style reports

Training Objectives of Hyperion Interactive Report:
Providing the business analyst with the skills necessary to work with the tool on a daily basis. Create dashboards with Dashboard Studio, Build queries with Interactive Reporting Studio, Navigate and view and interact with documents in Workspace

Target Students / Prerequisites:
Some knowledge of data warehouse and database concepts and Familiarity with Windows conventions

Course Contents:

Starting Interactive Reporting
Starting Interactive Reporting.

Opening and Saving a Sample File
Opening and Saving a Sample File.

Creating a sample query
Creating a sample query

Viewing Database Tables
Viewing Database Tables.

Adding Topics to query
Adding Topics to query

Viewing Results
Reordering Columns.
Sorting Columns
Filtering Data.
Calculating Data.
Pivoting Data.
Drilling Down.
Hiding Data.
Adding Color.

Charting data
Sorting Charts.
Inserting Text Labels.

Designing Reports
Creating smart Reports.
Sorting Columns.
Setting up a Report page.

Inserting Sections and Breaks
Inserting Sections and Breaks.

Changing Views
Changing Views.

Formatting Text and other elements
Formatting Text and other elements.

Setting interactive reporting options
Setting interactive reporting options.

Exporting document as web page
Exporting document as web page.

Export to HTML Wizard
Export to HTML Wizard.

Spot lighter
Spot lighter.

Querying
Query Section.
Building queries.
Processing Queries
Saving Queries
Derived Tables.
Working with query section data.

Results
Results section.
Enhancing your results set.

Working with results table.
Saving Results set.
Exporting Results set
Working with Tables
Table Section.
Creating Tables.
Manipulating Table Data.
Working with Table Components.

Querying Multidimensional Databases
Olap Query Section
Defining OLAP Query Options
Building OLAP Queries.
Refining OLAP Query data.
Processing OLAP Queries.
Applying Filters.

Cube query
Cube Query Catalog.
Member selection.
Query options.
Showing as Chart.
Exporting a Cube query.

Analyzing Data with Pivot Tables
Creating Pivot Table.
Charting a Pivot table.
Working with Pivot table.
Pivoting Data.
Report Designer
Report Section.
Creating a custom report.
Working with a report page.
Formatting report items.

Computed Items
About Computed Items.
Adding Computed items.
Common computed item example.

Applying Sorts
Sorting Data.
Simple Sort.
Sort lines.
Complex Sorting.
Nested Sorting.

Understanding Connectivity in Interactive Reporting
About IR Database connection files.
Working with interactive reporting connection.
Connecting to database.

Data Modeling
About Modeling.
Building a data model.
Understanding joins.
Working with Data Models.

Security for Interactive reporting
Security for Interactive reporting.

Introduction to dashboards
Introduction to dashboards.

Migrating reports with dashboards
Migrating reports with dashboards

About the Trainer

10 + Years of IT experience, provided training for over 1000+ professionals online Real-time IT experience which enables to provide dedicated quality training. Teaching is his passion vast experience in providing online training around the globe with good communication skills.