HYPERION INTERACTIVE REPORT Training Overview
Introduction
• Starting Interactive Reporting.
• Opening and Saving a Sample File.
• Creating a sample query.
• Viewing Database Table.
• 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.
• 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