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
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
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
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
Demonstration of Workspace, Demonstration of Administration Activities, Demonstration of Shared Services
You will be working on real-time projects and step-by-step assignments that have high relevance in the corporate world, and the course curriculum is designed by industry experts. Upon the completion of the training course, you can apply for some of the best jobs in top MNCs around the world at top salaries. Intellipaat offers lifetime access to videos, course materials, 24/7 support and course material upgrading to the latest version at no extra fee. Hence, it is clearly a one-time investment.
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.