Read Microsoft PowerPoint - HFM Rules Etc text version

J&M ODTUG Presentation HFM: Detailed Rules, Customisations & Optimisation Tricks

3rd November 2011

Copyright This document is the property of James & Monroe Pty Ltd. Distribution of this document is limited to authorised personnel. Reproduction of this document in part or in full in any form, including email and electronic, is not allowed except by written permission from James & Monroe Pty Ltd. This document contains material from Oracle, and is subject to Oracle copyright of all Oracle specific information.

Unless otherwise specifically stated, the material contained herein is proposed for information purposes only. References to any specific commercial products, process, service by trade name, trademark, manufacturer, or otherwise , does not constitute or imply an obligation to deliver any material, code, or functionality, and should not influence any purchasing decisions.

PARTNER

Agenda

· · · · · · · · · · · · · · · Overview consolidation rules Value Dimension Consolidation settings System accounts Functions that need to be reviewed Consol + elimination rule examples Consolidation journals Minorities calculation Data Unit Hierarchy depth, shallow vs deep Common vs unique members Task and Data audit Utility Automated Error log maintenance Zeros HFM Advanced registry settings 11.1.2

PARTNER

Overview consolidation rules

Items that need consideration: · Beware of consolidation rules · How many companies have minorities, equity accounted and JVs? · Does the ownership of companies change regularly · Is org by period required? · Do you need periodic consolidations for the calculations? All of the requirements above are company specific and there is no golden rule

PARTNER

Value Dimension

PARTNER

Consolidation settings

HFM Application settings Many applications are configured with Consolidation rules as "N" Activating consolidation rules requires the switch to be changed to "Y"

PARTNER

System Accounts

PARTNER

Functions that need to be reviewed

Function used for consolidation rules are shown below: · HS.Con ­ Load back consolidation value · HS.Node.Pcon ­ Retrieve the value from the Pcon system account · HS.Node.Pown ­ Retrieve the value from the Pown system account · HS.Node.Method ­ Retrieve the consolidation method · HS.Node.Consol1 ­ Retrieve the value from the Consol1 system account · HS.Node.Consol2 ­ Retrieve the value from the Consol2 system account · HS.Node.Consol3 ­ Retrieve the value from the Consol3 system account

PARTNER

Consol + elimination rule examples

PARTNER

Consol + elimination rule examples

PARTNER

Consolidation journals

PARTNER

Consolidation journals

PARTNER

Consolidation journals

PARTNER

Minorities calculation

For the minorities calculation the following formula is used Minorities share of Net Profit = %Minority Ownership * Net Profit Before we can have this value calculated we need three steps as shown in the next 4 slides. Define the ownership Change the rules Review the result both as journal and Data grid

PARTNER

Minorities calculation

PARTNER

Minorities calculation

PARTNER

Minorities calculation

PARTNER

Minorities calculation

PARTNER

Data unit

· Data Unit as a replacement for HS.EXP · More efficient loading more values · HS.EXP Single value at a time

PARTNER

Hierarchy depth, shallow vs deep

· For every input value all the parents are calulated in memory · The depth of the hierarchy has an impact, this may be minimal in you application · The effect is increased if we take the custom dimensions into account

Net_income EBIT Operating_inc Gross_Profit Sales Net_income EBIT Operating_inc Trading_Profit Gross_Profit Gross_margin Tot_Sales Ext_Sales Sales

PARTNER

Task and Data audit Utility

What is it? A utility for extracting and truncating task and data audit logs form the HFM . How to get? · Versions prior to 11.1.2.1 From Oracle Support [ID 1067055.1], · From 11.1.2 the utility is under the Utilities directory in HFM

PARTNER

Task and Data audit Utility

Why use the utility? Same functionality is available via HFM, benefit of the utility is that it connects to the database via the UDL and does not impact the HFM web server. If the task and audit logs are not truncated your HFM application can slow down. What to do with the logs? These logs can be loaded into a different SQL database to make them searchable for internal audit purposes

PARTNER

Task and Data audit Utility

PARTNER

Automated Error log maintenance

What is it? A scheduled script to rename the HFM log file Why use the scripts? Some of the current HFM functions are generating a log entry every time they are calculated, this has the effect of generating huge amounts of log entries during month end.

PARTNER

Zeros

· Zeros and very small values have a detrimental impact on HFM · The use of FDM has reduced the number of zeros loaded form the source systems. · Allocations is the main culprit for generating small values · The general rule is no Zeros but the best practice limit is usually 5%

PARTNER

Advanced registry settings 11.1.2

· Do not change these settings without rigorous performance testing · One of the new features of version 11.1.2 allows you to limit the amount of resources every applications uses.

PARTNER

Advanced registry settings 11.1.2

· The different value settings is available for the most of the performance registry settings in HFM. · The order of precedence is the Application specific settings, server specific settings and lastly the HFM Default settings · The settings can be found at the following location in the registry

HKEY_LOCAL_MACHINE\Software\Hyperion Solutions\Hyperion Financial Management\Server

PARTNER

WRAP UP

- QUESTIONS

PARTNER

About James & Monroe

· J&M are an Oracle Platinum Partner with specialisations in EPM and BI · J&M are Microsoft Gold Certified in the BI and Data management solutions competencies

PARTNER

About Today's Speaker

Presenter: Wayne Fallows Organisation: James & Monroe Position: Solutions Architect Bio: Solution Architect with James & Monroe, has worked for over 12 years in the Hyperion and Oracle space. Wayne has spent time as both an internal administrator and external consultant on different sized consolidation projects

Qualifications: Oracle Hyperion Financial Management

PARTNER

Information

Microsoft PowerPoint - HFM Rules Etc

30 pages

Report File (DMCA)

Our content is added by our users. We aim to remove reported files within 1 working day. Please use this link to notify us:

Report this file as copyright or inappropriate

1244298


Notice: fwrite(): send of 206 bytes failed with errno=104 Connection reset by peer in /home/readbag.com/web/sphinxapi.php on line 531