COURSES UPDATE:
NEW JOB ORIENTED CAREER COURSES STARTING FROM 10th Aug 2019. ANY GRADUATE CAN DO THIS. GRAB THIS OPPORTUINITY NOW. WE WILL GIVE GUARANTEE OF YOUR JOB. | OTHER WEEKEND BATCH SCHEDULES |  HADOOP  (02:00:PM)  |    APPIUM And REST ASSURED  (05:00:PM)  |  AWS AND DEVOPS  (05:00:PM)  |  ADVANCED SELENIUM, JAVA AND DEVOPS PIPELINE  (04:00:PM)  |  ANGULAR 6  (10:00:AM)  |   LINUX SHELL SCRIPTING / ADMIN  (11:00:AM)  |  More Information Click Here..  
+91 7588262721 / 9665875790 / 9923488942 info@orilent.com / orilenttap@gmail.com


Lesson 1:  Getting started with Hyperion

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

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

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

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

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

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

Lesson 7: Workspace and Admin Demonstrations
o    Demonstration of Workspace, Demonstration of Administration Activities
o     Demonstration of Shared Service.