Faites confiance à votre formation en TI |

Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

Oracle Hyperion Financial Mgmt 11.1.1: Create Rules Using Calc Mgr

Catégorie: Formation

Hyperion

Format: Formation en classe avec formateur

Autres formats:

This course is designed to teach you the methodology to create rules for advanced business calculations in Financial Management applications. You learn how to design, maintain, and execute complex rules by using Calculation Manager. You also learn to increase database performance, write rules for dynamic accounts, create translation rules, create consolidation rules, and effectively troubleshoot rules using log files.

Learn to:

Create formulas, rules, rule sets, and rules templates with Calculation Manager
Reduce database size and calculation time by proper use of 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

Compétences acquises

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
Create formulas, rules, rule sets, and rules templates with Calculation Manager
Reduce database size and calculation time by proper use of the custom and Value dimensions in rules

Qui peut en profiter

Administrator

Application Developers

Préalables

Hyperion Financial Management: Create and Manage Applications

Ce cours est donnÃ© par des formateurs certifiÃ©s Oracle.

Oracle University a nommÃ© ExitCertified Partenaire de lâ€™annÃ©e 2011

Il y a une diffÃ©rence....dÃ©couvrez-la.

Code:	HY-FM-CALCMGR
Format:	Formation en classe avec formateur

Durée:	4
Certifié par:	Oracle

Frais d’inscription (CAD): 4,120$

Oracle University Awards ExitCertified the North American Partner of the Year Award for 2011

Oracle Hyperion Financial Mgmt 11.1.1: Create Rules Using Calc Mgr Contenu détaillé

Introduction to Calculation Manager

Financial Management Rules
Calculation Manager Overview
Viewing Rules
Viewing Flow Charts
Printing Rules

Creating Rules and Formulas

Creating Rules
Creating Formula Components
Member Expressions in Calculation Statements
Operators, Keywords, and Functions
Validating Rules

Managing Rules

Creating and Validating Rule Sets
Deploying Rules
Managing Calculation Manager Objects
Managing Script
Importing and Exporting Calculation Manager Objects

Managing Templates

Templates Overview
System Templates
Adding Templates to Rules
Creating Custom-Defined Templates
Saving Rules and System Templates as Custom-Defined Templates

Reducing Maintenance with Variables

Execution and Replacement Variables
Creating Variables
Assigning Values to Variables in Grids
Standard Variables for the Point of View
Standard Variables for Custom and ICP Dimensions

Managing Rule Scope with Conditions

Adding Condition Rows to Grids
Adding Condition Components to Rules
Trigger Functions for Conditions
Managing Rule Execution for the Value Dimension

Managing the Custom and ICP Dimensions

Subcubes and Performance
Page Dimensions and Rules
Specifying Source Dimensions
Specifying Destination Dimensions

Troubleshooting with Log Files

Log Files Overview
Configuring Timer Logs
Setting Up Debug Logs
Creating Log Information Variables

Working with Member Range Components

Member Ranges and Loops
List Functions and Member Range Components
Adding Member Range Components to Rules
Member Attributes in Loops

Working with Data Range and Fixed Loop Components

Data Units Overview
Creating Variables for Data Range Components
Adding Data Range Components to Rules
Creating Data Range Replacement Variables
Creating Rules with Fixed Loop Components

Managing Financial Management Data

Retrieving and Writing Data
Testing for No Data
Setting Accounts to No Input
Rounding with the Financial Round Template
Rounding and Scaling with the Round Function

Working with Dimension Hierarchies

Working with the Calendar
Managing Calculation Status
Managing Movement Accounts and Data Views
Avoiding Circular Calculations in Hierarchies

Creating Rules for Dynamic Accounts

Dynamic Accounts Overview
Creating Rules with the Dynamic Function
Applying Period Functions to Dynamic Rules

Creating Allocations

Allocations Overview
Creating Rules with the Alloc Function
Creating Rules with the AllocationByEntity System Template
Setting Parent Entities to Input

Creating Currency Translation Rules

Currency Translation Overview
Default Translation Process
Translating Data with Trans and Transperiodic
Calculating Exchange Differences
Working with Currency Overrides

Creating Consolidation and Elimination Rules

Default Consolidation and Elimination Calculation
Consolidation Functions
The Standard Consolidation Template
Creating Consolidation and Elimination Rules

Your Name:

Your Email:

Sign up for newsletter:

Send Email To:

Course Link:

http://exitcertified.ca/oracle-training/HY-FM-CALCMGR.html

Message:


	Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source. Il y a une différence. Apprenez directement de la source.



Canada	United States
Formation à Montréal :: 514.876.1666 Formation à Ville de Québec :: 514.876.1666 Formation à Ottawa :: 613.232.3948 Formation à Toronto :: 416.487.3948 Formation à Vancouver :: 604.633.3948 Formation à Victoria :: 1.866.328.3948 Formation à Calgary :: 403.291.2855 Formation à Edmonton :: 780.441.3948 Formation à Regina :: 1.866.328.3948	Formation à Sacramento :: 916.669.3970 Formation à San Francisco :: 415.975.3948 Formation à San Jose :: 408.288.3948 Formation à Las Vegas :: 1.800.803.3948 Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948	Des questions? Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.

ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :

Formation Sun	Formation Oracle	Formation Symantec	Formation IBM	Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris	Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle	Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec	DB2, OS/400, Formation zSeries, s/390, iSeries, AIX	SUSE, Formation RedHat

Formation MySQL	Formation Apple	Formation en gestion de projet
Base de données MySQL	Cours Apple, Formation Leopard	Formation du PMI

Oracle Hyperion Financial Mgmt 11.1.1: Create Rules Using Calc Mgr

Compétences acquises

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

Create formulas, rules, rule sets, and rules templates with Calculation Manager

Reduce database size and calculation time by proper use of the custom and Value dimensions in rules

Qui peut en profiter

Administrator

Application Developers

Préalables

Hyperion Financial Management: Create and Manage Applications

Formation de Oracle (3027 cours)

Formation de Hyperion (126 cours)

Formation de Consolidation financière (22 cours)

Oracle Hyperion Financial Mgmt 11.1.1: Create Rules Using Calc Mgr Contenu détaillé