HYPERION INTERACTIVE REPORTING Online Training 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.
 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