HYPERION INTERACTIVE REPORT 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 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. <li>About Computed Items.</li>
<li>Adding Computed items.</li>
<li>Common computed item example. </li>
 
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