Hyperion Interactive Reports Online Training Course
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
