Contact Us @ +1-210-503-7101

DATA Warehousing - HYPERION INTERACTIVE REPORT

Hyperion Interactive Report Course Content

Overview:
Oracle Hyperion Interactive Reporting is one of the main products in the Oracle Business Intelligence Enterprise Edition Plus software suite, an industry-leading business intelligence platform. This Software Completely shares common administration, user management, and installation and configuration support with other Hyperion BI modules of Oracle Business Intelligence Suite Enterprise Edition Plus.
Training Objectives of Hyperion Interactive Report:
The main Objective of this Course is to providing 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.
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

    About Tutor

    card image

    US IT Training

    This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.

    US IT Training

    This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.