Home > Hyperion Enterprise > Methods

Hyperion Enterprise Methods

Introduction

This page attempts to explain how Hyperion Enterprise Methods work and how they can be used. There are three types of methods:

In addition there are two special chart methods:

Chart Methods

Chart methods calculate the value of accounts in the chart of accounts. The default chart of accounts method is CHART. It is automatically created and cannot be deleted. You can create additional chart methods if you need to. The most common use of Chart methods in to calculate total and subtotals.

Example

Account CHART
Formula 		Q1
sales 1,000
costs -500
profit TOTAL 500
assets_fixed 2000
assets_current 2000
total_assets SUBTOTAL (#assets_fixed) 4000
equity -1000
liabs_current -500
liabs_non -2000
total_liabs SUBTOTAL (#equity) -3500
imbalance SIGN (#profit+#total_assets+#total_liabs) 0

Consolidation Methods

Consolidation methods performs calculations when base entity values are used to calculate parent entity values. The default consolidation method is CONSOL. It is automatically created and cannot be deleted. You can create additional consolidation methods if you need to. The default method perform basic consolidation calculations without any formulas. You can add formula for more complex translations.

Example 1

North is a 33.33% joint venture of Top and therefore the Percent Consolidation is 33.33%. There are no formula in the CONSOL method so the default consolidation calculation is used.

Account CONSOL Formula North Top
sales 1000 333.3
costs -500 -166.65
profit 500 166.65
assets_fixed 2000 666.6
assets_current 2000 666.6
total_assets 4000 1333.2
liabs_current -500 -166.65
liabs_non -2000 -666.6
equity -1000 -333.3
fx_reserve 0 0
total_liabs -3500 -1166.55

Example 2

Custom CONSOL method.

Account CONSOL Formula France Top
sales ROUND(@ACC,1) 1000 714
costs ROUND(@ACC,1) -500 -357
profit 500 357
assets_fixed ROUND(@ACC,1) 2000 1429
assets_current ROUND(@ACC,1) 2000 1429
total_assets 4000 2858
liabs_current ROUND(@ACC,1) -500 -357
liabs_non ROUND(@ACC,1) -2000 -1429
equity ROUND(@ACC,1) -1000 -714
fx_reserve 0 -1
total_liabs -3500 -2501

Translation Methods

Translation methods convert accounts from the base entity currency to the parent entity currency. The default translation is TRANS. It is automatically created and cannot be deleted. You can create additional translation methods if you need to. The default method will perform simple currency translations without any formula. You can add formula for more complex translations.

Example 1

Default translation with no formula in TRANS method.

Account TRANS
Formula 		Default
Calculation 		France
EUR 		Top
GBP
    fx_average - EUR 1.42 1.42
    fx_average - GBP 1.00 1.00
-fx_average
    fx_period_end - EUR 1.40 1.40
    fx_period_end - GBP 1.00 1.00
-fx_period_end
Sales 1,000/1.42 1000 704.22
Costs -500/1.42 -500 -352.11
PROFIT 500/1.42 500 352.11
Fixed assets 2,000/1.40 2000 1428.57
Current assets 2,000/1.40 2000 1428.57
TOTAL ASSETS 4,000/1.40 4000 2857.14
Current liabilities -500/1.40 -500 -357.14
Non-current liabilities -2,000/1.40 -2000 -1428.57
Equity -1,000/1.40 -1000 -714.28
Foreign exchange reserve 0 -5.03
TOTAL EQUITY AND LIABILITIES -3500 -2505.03

Example 2

Custom translation with rounding formula in TRANS method.

Account TRANS
Formula 		France
EUR 		Top
GBP
    fx_average - EUR 1.42 1.42
    fx_average - GBP 1.00 1.00
-fx_average
    fx_period_end - EUR 1.40 1.40
    fx_period_end - GBP 1.00 1.00
-fx_period_end
Sales ROUND(VAL(@ACC,#fx_average),1) 1,000 704
Costs ROUND(VAL(@ACC,#fx_average),1) -500 -352
PROFIT 500 352
Fixed assets ROUND(VAL(@ACC,#fx_period_end),1) 2,000 1,429
Current assets ROUND(VAL(@ACC,#fx_period_end),1) 2,000 1,429
TOTAL ASSETS 4,000 2,858
Current liabilities ROUND(VAL(@ACC,#fx_period_end),1) -500 -357
Non-current liabilities ROUND(VAL(@ACC,#fx_period_end),1) -2,000 1,429
Equity ROUND(VAL(@ACC,#fx_period_end),1) -1,000 -704
Foreign exchange reserve 0 -6
TOTAL EQUITY AND LIABILITIES -3,500 -2,464

CHARTDSM Method

The CHARTDSM method is a special chart method which calculates consolidation detail values. It is automatically created and cannot be deleted. The formulas in CHARTDSM are only calculated for applications that store consolidation detail, that is proportion and elimination detail, translation detail, and/or parent adjustments.

Example

France is a 50% joint venture and is a EUR child of a GBP parent.

Account CHARTDSM Input Trans Prop Contrib
sales 1000 704.22 352.11 352.11
costs -500 -352.11 -176.05 -176.05
profit TOTAL 500 352.11 176.05 176.05
assets_fixed 2000 1428.57 714.28 714.28
assets_current 2000 1428.57 714.28 714.28
total_assets SUBTOTAL (#fixed_assets) 4000 2857.14 1428.57 1428.57
liabs_current -500 -357.14 -178.57 -178.57
liabs_non -2000 -1428.57 -714.28 -714.28
equity -1000 -714.28 -357.14 -357.14
fx_reserve BALANCE (#profit,...,#equity) 0 -5.03 -2.51 -2.51
total_liabs SUBTOTAL (#liabs_current) -3500 -2505.03 -1252.51 -1252.51

DYNVIEWACCTS Method

The DYNVIEWACCTS method is a special chart method which calculates the values of dynamic view accounts. It is automatically created and cannot be deleted. Dynamic view accounts store formulas instead of a data values. When you view a dynamic view account the system calculates its value based on the current view. This is useful for ratios and percentages as shown in the following example.

Example

This is the CTD (Category-To-Date) view of a CTD category.

Account CHART DYNVIEWACCTS Q1 Q2 Q3 Q4
sales -1,000 -2,000 -3,000 -4,000
costs 700 1,400 2,100 2,800
profit TOTAL -300 -600 -900 -1,200
percent_dynamic_view #profit/#sales*100 30.0 30.0 30.0 30.0
percent_chart #profit/#sales*100 30.0 30.0 30.0 30.0

This is the PER (Periodic) view of a CTD category.

Account CHART DYNVIEWACCTS Q1 Q2 Q3 Q4
sales -1,000 -2,000 -3,000 -4,000
costs 700 1,400 2,100 2,800
profit TOTAL -300 -600 -900 -1,200
percent_dynamic_view #profit/#sales*100 30.0 30.0 30.0 30.0
percent_chart #profit/#sales*100 30.0 0.0 0.0 0.0
Copyright © 1999-2008 Consolidation Consultancy Limited Last updated: 25 Jan 2008