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. Having the right training and certification can help bag the best jobs in this domain.
Topics: 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
Topics: IR Overview (What is BQY& OCE), Relational Data Source Connections, MDDB Data Source Connections, Difference Between Relational & Multidimensional Reporting Tools, Open Catalogue 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
Topics: 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
Topics: 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
Topics: Demonstration of Workspace, Demonstration of Administration Activities, Demonstration of Shared Services
• Improved understanding of data – Improves understanding and use of business-critical information across the enterprise using easy-to-use query and analysis capabilities. • Personalized Presentation – Features drag and drop modeling, data query and personalized dashboard development to deliver relevant information faster. • Interactive and Dynamic – Provides an interactive, dynamic intelligence solution for every class of user. • Multiple Data Sources – Integrates with and leverages almost any existing information source to establish a scalable, standards-based environment for developing BI solutions. • Secure – Provides safe exchange of business information through the ability to secure content to different users across the enterprise.
ESSBase i.e. (Extended Spread Sheet DataBASE) is a multidimensional database management system (MDBMS) that provides a multidimensional database platform upon which to build analytic applications i.e. in ESSBase we make use of OLAP (Online Analytical Processing) .
In Intellipaat self-paced training program you will receive recorded sessions, course material, Quiz and assignments.The courses are designed such that you will get real world exposure and focused on clearing relevant certification exam. After completion of training you can take quiz which enable you to check your knowledge and enables you to clear relevant certification at higher marks/grade also you will be able to work on the technology independently.
In Self-paced courses trainer is not available whereas in Online training trainer will be available for answering queries at the same time. In self-paced course we provide email support for doubt clearance or any query related to training also if you face some unexpected challenges we will arrange live class with trainer.
All Courses are highly interactive to provide good exposure. You can learn at your own place and at your leisure time. Prices of self-paced is training is 75% cheaper than online training. You will have lifetime access hence you can refer it anytime during your project work or job.
Yes, at the top of the page of course details you can see sample videos.
As soon as you enroll to the course, your LMS (The Learning Management System) Access will be Functional. You will immediately get access to our course content in the form of a complete set of previous class recordings, PPTs, PDFs, assignments and access to our 24×7 support team. You can start learning right away.
24/7 access to video tutorials and Email Support along with online interactive session support with trainer for issue resolving.
Yes, You can pay difference amount between Online training and Self-paced course and you can be enrolled in next online training batch.
Yes, we will provide you the links of the software to download which are open source and for proprietary tools we will provide you trail version if available.
Please send an email . You can also chat with us to get an instant solution.
Intellipaat verified certificates will be awarded based on successful completion of course projects. There are set of quizzes after each couse module that you need to go through . After successful submission, official Intellipaat verified certificate will be given to you.
Towards the end of the Course, you will have to work on a Training project. This will help you understand how the different components of course are related to each other.
Classes are conducted via LIVE Video Streaming, where you get a chance to meet the instructor by speaking, chatting and sharing your screen. You will always have the access to videos and PPT. This would give you a clear insight about how the classes are conducted, quality of instructors and the level of Interaction in the Class.
Yes, We do keep launching multiple offers, please see offer page.
We will help you with the issue and doubts regarding the course. You can attempt the quiz again.
This course is designed for clearing the Oracle Hyperion Interactive Reporting Certification exam. The entire training course content is in line with the certification program and helps you clear the certification exam with ease and get the best jobs in the 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 scenario 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 in certification exam.
Intellipaat Course Completion certificate will be awarded on the completion of Project work (on expert review)and upon scoring of at least 60% marks in the quiz. Intellipaat certification is well recognized in top 80+ MNCs like Ericsson, Cisco, Cognizant, Sony, Mu Sigma, Saint-Gobain, Standard Chartered, TCS, Genpact, Hexaware, etc.
We provide 24X7 support by email for issues or doubts clearance for Self-paced training.
In online Instructor led training, trainer will be available to help you out with your queries regarding the course. If required, the support team can also provide you live support by accessing your machine remotely. This ensures that all your doubts and problems faced during labs and project work are clarified round the clock.
"PMI®", "PMP®" and "PMI-ACP®" are registered marks of the Project Management Institute, Inc.
The Open Group®, TOGAF® are trademarks of The Open Group.
The Swirl logoTM is a trade mark of AXELOS Limited.
ITIL® is a registered trade mark of AXELOS Limited.
PRINCE2® is a Registered Trade Mark of AXELOS Limited.
Certified ScrumMaster® (CSM) and Certified Scrum Trainer® (CST) are registered trademarks of SCRUM ALLIANCE®
Professional Scrum Master is a registered trademark of Scrum.org