Hyperion Interactive Reports Online Training

Home / Hyperion Interactive Reports Online Training

Hyperion Interactive Reports Online Training Course

Duration: 4 –  5 Weeks

Starting Interactive Reporting.

●    Opening and Saving a Sample File.
●    Creating a sample query
●    Viewing Database Tables.
●    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.

●    Changing Views.
●    Formatting Text and other elements.
●    Setting interactive reporting options.
●    Exporting document as web page.
●    Export to HTML Wizard.
●    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.
Introduction to dashboards.
Migrating reports with dashboards