Hyperion Training

IntelliPaat

How long?

  • online
  • on demand

IntelliPaat

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Who should attend

  • Business Developers and Technical Consultants
  • Data Analysts and Report Analysts
  • Financial Professionals and Managers
  • Database and BI Professionals

What are the prerequisites for learning Hyperion?

Knowledge of JavaScript is essential for taking up this course.

About the course

Our Oracle Hyperion Interactive Reporting certification training course lets you master Hyperion reporting. We provide the best online classes to help you learn Hyperion database, reporting, analytics, creating queries, SQL extraction and so on. In this program, you will work on real-world Hyperion projects.

About Hyperion Online Training Course

This is a complete training for working with the Oracle Hyperion tool for Business Intelligence. Various subjects included in this course are Oracle EPM, Hyperion interactive core services and various reporting tools. You will gain hands-on experience in creating queries, working with tool bars and hyperlinks, SQL extraction with JavaScript, etc.

What will you learn in this training?

  • Complete knowledge of the tool, Hyperion
  • Interactive reporting web client and EPM work space
  • Constructing queries with a relational data source
  • Generating reports using Interactive Reporting Studio
  • Requesting items and processing queries
  • Methods of filtering and sorting data
  • Generating tabular, chart, cross-tabular and band-style reports
  • Getting equipped with the skill set to appear for the Oracle Hyperion Interactive Reporting Certification

Why should you take up Hyperion training course?

  • Poor data quality costs the US businesses up to $600 billion annually – TDWI
  • Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.
  • A Hyperion Planning Architect in the United States can earn $130,000 – indeed.com

Hyperion is one of the most powerful and versatile Business Intelligence tools available for querying, analyzing and generating interactive reports in the financial domain. Some of the biggest companies in the world exclusively work with the Hyperion tool for getting more insights from their data. Hence, having the right training and certification can help bag the best jobs in this domain.

Hyperion Course Content

Getting started with Hyperion

Introduction to Oracle EPM, Hyperion system 11 Components, BI+ Three Tier architecture, Client/Server Reporting Architecture, BI+ Interfaces (Plug In/HTML,etc.), Hyperion IR Core Services, DAS & LCM Utility, Typical IR Env Architecture, Report Process Flow

Introduction to IR, Relational vs. Multidimensional Reporting Tools, ODBC and DSN, OCE Optimization

IR Overview (What is BQY& OCE), Relational Data Source Connections, MDDB Data Source Connections, Difference Between Relational & Multidimensional Reporting Tools, Open Catalog Extension Building, Tnsnames Ora file integration, Oracle/Oracle Net Features, ODBC & DSN Concepts, Filtering Table/Owner/Table Type, OCE Optimization & Best Practices, Modifying the OCE from Connection Manager

SQL Queries and Important Operations and Functions

Building a Query, Different Join Types, Request/Filter & Sort Line (Query & result level), Adding Computed Items (Query & result level), Available/Custom/Selected Values in Filter, Custom SQL in filter, Loading filter values from flat files, Variable & Cascading Filters, Group by & Having Clause in Query Section, Export & Import Options, Break Total/Grand Total, Grouping Column in Results, Suppress Duplicates, Building Subqueries, Different Save Options, Working with Meta Topics (Original & Combined View), Processing Queries (all, Current, Custom), Estimating Query Size, Appending Queries (Union, Union All), Viewing SQL Log & Custom SQL, Query Options, Local Results & Derived Queries Concept

Pivot, report and Table sections, Spotlighter, and Getting started with Java Scripting

Adding & Building Pivot Section, Adding table Section & its significance, Drill Down Feature, Controlling Drill Down using Table Section, Pivot Refresh Data Options (After Process/When Displayed/Manual/Refresh Now), Variance Reporting in Pivot/Annotations in Pivot, Month Name Sorting/Top N analysis, Working with Report section (Creating Report Groups), Synchronize with DB Feature, Working with Spotlighter, Introduction to Java Scripting

Insights into Toolbar

Run Mode and Design Mode, Document Script Concept & Event Trigger, Navigating the Object Model in Script Editor, Hard Coding Values in Drop Down, Loading drop Down Values from Query using Java Script, Loading Drop Down values using Get Cell Function, Tool bars hiding using JavaScript, Filter the result based on User selection on Dashboard through Java Scripting, Working with Radio buttons & Text boxes, Explaining Pivot Properties on Dashboard (including Active/Hyperion link/View Only), Introducing Console Window, Working with Hyperlink

Advanced operations on BQY and Java Scripting

Extracting Last SQL Statement through JavaScript, Extracting report’s metadata using Java Scripting, Handling Dashboard Objects positioning based on coordinates through java Scripting, Repository Based reports & Utilities, Workspace Login/Explore & Folder Organization, Opening a BQY in Web Client, Import BQY on Workspace, Providing Adaptive States on BQY, Editing a published IR document, Administer Module Options (Administrator), CMC Console View, Data Access Service Configuration, Services in Task Manager, Job Status/Job Queue/Job Log, Managing Physical Resources, Shared Services Login, User Directories Management, Application Groups & LCM Utility

Workspace and Admin Demonstrations

Demonstration of Workspace, Demonstration of Administration Activities, Demonstration of Shared Services

Hyperion Certification

This course is designed for clearing the Oracle Hyperion Interactive Reporting Certification exam. The entire course content is in line with the certification program and helps you clear the certification exam with ease and get the best jobs in top MNCs.

As part of this training, you will be working on real-time projects and assignments that have immense implications in the real-world industry scenarios, thus helping you fast-track your career effortlessly.

At the end of this training program, there will be a quiz that perfectly reflects the type of questions asked in the certification exam and helps you score better marks.

Intellipaat Course Completion Certificate will be awarded upon the completion of the project work (after the expert review) and upon scoring at least 60% marks in the quiz. Intellipaat certification is well recognized in top MNCs like Ericsson, Cisco, Cognizant, Sony, Mu Sigma, Saint-Gobain, Standard Chartered, TCS, Genpact, Hexaware, etc.

Videos and materials

Hyperion Training at IntelliPaat

From  $184

Something went wrong. We're trying to fix this error.

Thank you for your application

We will contact the provider to ensure that seats are available and, if there is an admissions process, that you satisfy any requirements or prerequisites.

We may ask you for additional information.

To finalize your enrollment we will be in touch shortly.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.