HYPERION

Hyperion Interactive Reporting

Duration of       Hours 

HRS

Duration time may vary depends on course progress

Training Objectives of Hyperion Interactive Report:

The main Objective of this Course is to providing a complete overview of the Interactive Reporting Web Client and EPM Workspace, providing the business analyst with the skills necessary to work with the tool on a daily basis. At End of the Completion of the Course, students must be able to create queries against a relational data source and create reports with Hyperion Interactive Reporting Studio and they will learn the concepts of request items filter and sort data and process queries.


Target Students / Prerequisites:

Students must have Basic knowledge of data warehouse and database concepts and familiar to write SQL queries on multiple database objects and Basic knowledge of JavaScript Required.

Course Content

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 a web page:


  • Exporting document as a 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 a 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 the 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

Have some Questions?

Call us at our care or drop quick contact box

Why with us?
  • Live Quality Training 

  • Live demonstration of of features and practicals.

  • 100% Assurance Placement Assistance

  • Effective Resume building

  • Internship Program for real exposure

  • Interview preparation with mock interview drills

  • Process of applying jobs at right places

  • Guidance of getting flexible, part time jobs

Our chanel partners : AlightPro | Career ITS

© Copyright © 2008 ProCareer Inc. All rights reserved.