Friday Jul 11, 2014

Oracle University courses for EPM 11.1.2.3

The Oracle University offers several courses for Oracle Hyperion Enterprise Performance Management (EPM) 11.1.2.3

The Oracle University provides the training formats in Classroom Training and/or Live Virtual Class (LVC).

A quick summary view of what awaits is below. Visit the Oracle University website for full details.

Enterprise Performance Management 11.1.2.3 Link

Oracle Hyperion Planning 11.1.2: Create & Manage Applications
- This Hyperion Planning 11.1.2.3 training will teach you how to create and administer Planning applications. You'll learn how to manage metadata and add dimensions and members.

Learn To:

  • Create planning applications.
  • Manage metadata and add dimensions and members and import members.
  • Load data.
  • Set up security.
  • Create forms, set up task lists and set up business rules.
  • Manage the approval process.

Oracle Hyperion Financial Mgmt 11.1.2: Create & Manage Applications
- This Oracle Hyperion Financial Mgmt 11.1.2: Create & Manage Applications training teaches you how to create and manage applications using Financial Management. Expert Oracle University instructors will take you through the process of creating an application, entering data and adjusting and viewing data using data grids and data forms.

Learn To:

  • Create accounts, entities, scenarios and custom dimensions.
  • Import and export data and metadata.
  • Create and deploy an application.
  • Enter data in data forms and data grids.
  • Enter intercompany data.
  • Perform data consolidation.
  • Create application metadata.
  • Deploy applications.
  • Load data from external systems.
  • Secure data.
  • Translate and consolidate data.
  • Manage the review process.

Oracle Hyperion Financial Mgmt 11.1.2: Create Rules Using Calc Mgr
- This Oracle Hyperion Financial Mgmt 11.1.2: Create Rules Using Calc Mgr(11.1.2.3)training is based on Oracle Hyperion Financial Management 11.1.2.3, and is designed to teach you the methodology to create rules for advanced business calculations. Expert Oracle University instructors will demonstrate how you can design, maintain and execute complex rules by using Calculation Manager..

Learn To:

  • Create formulas, rules, rule sets and rules templates with Calculation Manager.
  • Reduce database size and calculation time by properly using the custom and value dimensions in rules.
  • Calculate percentages and ratios for dynamic accounts.
  • Create loops by using member lists and data ranges.
  • Create rules with proper data-handling techniques.
  • Create allocation, currency translation, consolidation and elimination rules.

Hyperion Financial Data Quality Management EE Administration
- This Hyperion Financial Data Quality Management EE Administration training will teach you how to implement Oracle Hyperion Financial Data Quality Management, Enterprise Edition (FDMEE), an advanced metadata and data transformation management solution. Explore a single, systematic process for loading source metadata and data from disparate systems into target analytical applications.

Learn To:

  • Define system, application, and user profiles.
  • Perform integration tasks.
  • Create import formats for file systems.
  • Set up locations, period mappings, and category mappings.
  • Create member mappings.
  • Define data load rules and load data to target applications.
  • Create check rules and check entities.
  • Process batches and manage reports.
  • Set up security.
  • Create import and event scripts.
  • Describe FDMEE integration with other source systems.

Oracle Data Relationship Management 11.1.2 Administration
-This Oracle Data Relationship Management 11.1.2 Administration training teaches you how to implement a Data Relationship Management application. Expert Oracle University instructors will teach you how to start building the application structure by adding versions, hierarchies and nodes.

Learn To:

  • Support the application data.
  • Create properties both manually and in bulk through the Migration Utility.
  • Clean the data by creating queries and compares.
  • Update the data with action scripts.
  • Blend versions to create a final version.
  • Create business rules for your data by creating validations and derived properties with formulas and scripts.
  • Fine-tune the display of properties for nodes by setting up node types.
  • Export the data to a file and to a database table.

Oracle Hyperion Planning 11.1.2 for Interactive Users
-This course will teach you create forms, manage task lists, enter and adjust data and execute calculations in Planning. You'll also learn how to manage the approval process, which includes moving a plan through the budget review-and-approval process.

Learn To:

  • Discuss Planning capabilities, Planning’s relationship with Essbase and dimension requirements.
  • Navigate Workspace to access Planning and Financial Reporting.
  • Create and test forms and ad hoc grids.
  • Enter, adjust and analyze data in Planning and Smart View.
  • Set up and test business rules.
  • Set up and implement task lists.
  • Create reports to analyze planning results.
  • Enter and adjust plan and forecast data.
  • Create forms and ad hoc grids.
  • Analyze data in Smart View.
  • Create production quality reports.

Oracle Essbase 11.1.2: Calculate Block Storage Databases
- This Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) training teaches you the principal techniques and theories for the design of calculations in block storage databases with Essbase Release 11.1.2.3. Expert Oracle University instructors will review database structure and configuration and teach you basic calculation building blocks, including FIX and IF statements.

Learn To:

  • Describe Essbase and block storage database structures.
  • Develop and test calculation scripts.
  • Develop advanced calculations.
  • Optimize databases though dynamic calculations.
  • Normalize and allocate data.

Oracle Hyperion Smart View 11.1.2 for Planning
- This Oracle Hyperion Smart View 11.1.2 for Planning (11.1.2.3) training teaches you how to use Smart View to enter, adjust and analyze Planning data. You learn how to annotate and predict data and use ad hoc tools to analyze data.

Learn To:

  • Navigate the Smart View interface.
  • Connect to data sources.
  • Enter, calculate and analyze planning data.
  • Manage the approval process and task lists.
  • Embed dynamic data points in Microsoft Office documents.
  • Run and view predictions in Predictive Planning.

Oracle Hyperion Financial Management 11.1.2 for Interactive Users
- This Oracle Hyperion Financial Management 11.1.2 for Interactive Users (11.1.2.3) training helps you deep dive into learning how to enter, view, consolidate and manage your financial information using this Oracle solution. With the help of expert Oracle University instructors, you'll develop the knowledge and skills to enter and view data, while creating and entering journal entries and inter-company transactions.

Learn To:

  • Navigate Financial Management.
  • Enter and calculate data.
  • Create journal entries.
  • Enter intercompany data.
  • Consolidate data.
  • Analyze and enter data in Smart View.

Oracle Hyperion PSPB 11.1.2: Create & Manage Applications
- This Oracle Hyperion PSPB 11.1.2: Create & Manage Applications training teaches you how to create and administer Public Sector Planning and Budgeting applications within Planning. Expert Oracle University instructors will teach you how to design and manage the budgeting process, which includes building planning unit hierarchies and assigning responsibilities and promotional paths for planning units.

Learn To:

  • Create Public Sector Planning and Budgeting applications.
  • Maintain Public Sector Planning and Budgeting position and employee data.
  • Load metadata and data into applications and set up security.
  • Create and fill positions.
  • Manage employee assignments to positions.
  • Set up and maintain compensation budget defaults and maintain compensation data.
  • Link compensation and line item budgets.
  • Create and review funding requests.
  • Set up and manage the approval process.
  • Review budget books.
  • Manage revision requests.
  • Set up funding requests.
Keep up to-date with what's happening in Oracle University by visiting:
Oracle University Blog

Oracle University EPM Training Delivery Team blog post of interest:
The Coolest Features Available with Oracle Hyperion 11.1.2.3 – Are You Using Them?

Tuesday Mar 20, 2012

Enterprise Manager in EPM 11.1.2.x...a game of hide and seek!

guest article: Maurice Bauhahn:

Users of Oracle Hyperion Enterprise Performance Management 11.1.2.0 and 11.1.2.1 may puzzle why the URL http://<servername>:7001/em may not conjure up Enterprise Manager Fusion Middleware Control. This powerful tool has been installed by default...but WebLogic may not have been 'Extended' to allow you to call it up (we are hopeful this ‘Extend’  step will not be needed with 11.1.2.2). The explanation is on pages 425 and following of the following document:

http://www.oracle.com/technetwork/middleware/bi-foundation/epm-tips-issues-1-72-427329.pdf

A close look at the screen dumps in that section reveals a somewhat scary prospect, however: the non-AdminServer servlets had all failed (see the red down-arrow icons to the right of their names) after the configuration! Of course you would want to avoid that scenario!

A rephrasing of the instructions might help:

  1. Ensure the WebLogic AdminServer is not running (in a default scenario that would mean port 7001 is not active).

  2. Ensure you have logged into the computer as the installing owner of EPM. Since Enterprise Manager uses a LOT of resources, be sure that there is adequate free RAM to accommodate the added load.

  3. On the machine where WebLogic AdminServer is set up (typically the Foundation Services machine), run \Oracle\Middleware\wlserver_10.3\common\bin\config (config.sh on Unix).

  4. Select the 'Extend an existing WebLogic domain' option, and click the 'Next' button.

  5. Select the domain being used by EPM System.
    - Typically, the default domain is created under /Oracle/Middleware/user_projects/domains and is named EPMSystem.
    - Click 'Next'. Under 'Extend my domain automatically to support the following added products'
    - place a check mark before 'Oracle Enterprise Manager - 11.1.1.0 [oracle_common]' to select it.
    - Continue accepting the defaults by clicking 'Next' on each page until
    - on the last page you click 'Extend'.
    - The system will grind for a few minutes while it configures (deploys?) EM.
    - Start the AdminServer.

  6. Sometimes there is contention in the startup order of the various servlets (resulting in some not coming up). To avoid that problem on Microsoft Windows machines you may start and stop services via the following analogous command line commands to those run on Linux/Unix (these more carefully space out timings of these events):
    • Ensure EPM is up:
      \Oracle\Middleware\user_projects\epmsystem1\bin\start.bat
    • Ensure WebLogic is up:
      \Oracle\Middleware\user_projects\domains\EPMSystem\bin\startWebLogic.cmd
    • Shut down WebLogic:
      \Oracle\Middleware\user_projects\domains\EPMSystem\bin\stopWebLogic.cmd
    • Shut down EPM:
      \Oracle\Middleware\user_projects\epmsystem1\bin\stop.bat

 Now you should be able to more successfully troubleshoot with the EM tool:

About


This blog talks about the latest news and upcoming events initiated by the EPM/BI Proactive Support Team.

Authors:

italia.nowodworska@oracle.com
torben.hein@oracle.com
paul.anderson@oracle.com
julie.foster@oracle.com





Search

Archives
« March 2015
SunMonTueWedThuFriSat
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today