Hyperion Training
Intellipaat
Course Summary
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. Work on real world Hyperion projects.
-
+
Course Description
About Hyperion Online Training Course
What you will learn in this Training?
- Learn Hyperion and get complete knowledge of the tool
- Know Interactive Reporting Web Client and EPM Work space
- Construct queries with a relational data source
- Generate reports using Interactive Reporting Studio
- Learn to Request items and process queries
- Learn the methods of Filtering and Sorting data
- Generate Tabular, Chart, Cross-tabular and Band-style Reports
- Get equipped for Oracle Hyperion Interactive Reporting Certification
Who should take this Hyperion Course?
- 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.Why Take Hyperion Training Course?
- Poor data quality costs US businesses up to $600 billion annually – TDWI
- The Financial Analytics Market will be worth $6.65 Billion by 2018 – businesswire.com
- A Hyperion Planning Architect in United States can earn $130,000 – indeed.com
-
+
Course Syllabus
Hyperion Course Content
Getting started with HyperionIntroduction 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 FlowIntroduction to IR, Relational vs. Multidimensional Reporting Tools, ODBC and DSN, OCE OptimizationIR 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 ManagerSQL Queries and Important Operations and FunctionsBuilding 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 ConceptPivot, report and Table sections, Spotlighter, and Getting started with Java ScriptingAdding & 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 ScriptingInsights into ToolbarRun 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 HyperlinkAdvanced operations on BQY and Java ScriptingExtracting 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 UtilityWorkspace and Admin DemonstrationsDemonstration of Workspace, Demonstration of Administration Activities, Demonstration of Shared Services
This course is listed under
Development & Implementations
, Enterprise Applications
, Industry Specific Applications
, Data & Information Management
, IT Strategy & Management
, Project & Service Management
and Quality Assurance & Testing
Community
Related Posts: