Value Dimension

(1)

Oracle Hyperion Financial Management (HFM): The Value

Oracle Hyperion Financial Management (HFM): The Value Dimension Explained!Dimension Explained! Oracle’s

Oracle’s consolidatioconsolidation n tool,tool, Hyperion Financial Management (HFM)Hyperion Financial Management (HFM),, offers a offers a number of system-gener

number of system-generated dimensions. ated dimensions. Perhaps the most impoPerhaps the most important of thesertant of these dimensions is the “Value” dimension.

dimensions is the “Value” dimension. You’ll really doYou’ll really do yourself a favor if you canyourself a favor if you can understand how the Value dimension works in HFM, as this dimension drives understand how the Value dimension works in HFM, as this dimension drives the consolidations performed by the system. The Value dimension can seem the consolidations performed by the system. The Value dimension can seem complex, especially

complex, especially when trying to validate anwhen trying to validate and reconcile data. d reconcile data. Simply put, theSimply put, the Value dimension is comprised of the different types of stored data

Value dimension is comprised of the different types of stored data in an HFMin an HFM application.

application. Input data, translInput data, translated data, adjustmenated data, adjustment data, and consolidatiot data, and consolidationn data can all be viewed separatel

data can all be viewed separately. y. In this way, the Value dimIn this way, the Value dimension provides anension provides an audit trail of data types.

audit trail of data types.

Below is a screenshot of the Value d

Below is a screenshot of the Value dimension. imension. We will focus on the memWe will focus on the members inbers in the red box for this b

the red box for this blog. log. In the Value dimensioIn the Value dimension, members are groupn, members are grouped ined in triplets.

triplets. The triplets we will loThe triplets we will look at are Entity Curreok at are Entity Currency->Entity Curr Adjncy->Entity Curr Adjs->Entitys->Entity Curr Total and Parent Currency->Parent Curr Adjs->Parent Curr Total.

Curr Total and Parent Currency->Parent Curr Adjs->Parent Curr Total.

Every member of the Entity dimension is assigned a currency in Every member of the Entity dimension is assigned a currency in thethe metadata.

metadata. Entity Currency will sEntity Currency will store the values for an entity itore the values for an entity in its assignedn its assigned currency (sometimes referred to as “default currency” or

currency (sometimes referred to as “default currency” or “local currency”)“local currency”). An. An entity’s Parent Currency is actually what it sounds like –

entity’s Parent Currency is actually what it sounds like – it is the default it is the default currency of an entity’s parent.

currency of an entity’s parent. Parent Currency wilParent Currency will store the vall store the values for anues for an entity translated to the curre

entity translated to the currency of its parent. ncy of its parent. This stored value will beThis stored value will be generated when a consolid

generated when a consolidation is run in the system. ation is run in the system. This consolidation pThis consolidation processrocess performs currency translations based on exchange rates that have been

performs currency translations based on exchange rates that have been enteredentered in the application.

in the application. Shown below is a ‘Canada Shown below is a ‘Canada Company’ entity which is the loneCompany’ entity which is the lone descendant of ‘US Parent’ in the or

(2)

Company’ in the Cash

Company’ in the Cash account, Entity Currency (which is CAD) is 2,500.00 andaccount, Entity Currency (which is CAD) is 2,500.00 and Parent Currency (which is USD) is

Parent Currency (which is USD) is 2,463.462,463.46.. Where ‘Canada Company’ is theWhere ‘Canada Company’ is the lone descendant in the hierarchy of ‘US Parent’, 2,463.36 is the am

lone descendant in the hierarchy of ‘US Parent’, 2,463.36 is the amount in Entityount in Entity Currency (USD) for ‘US Parent’ as well.

Currency (USD) for ‘US Parent’ as well.

Now to add a wrinkle: let’s look at the

Now to add a wrinkle: let’s look at the idea of adjustments being put into theidea of adjustments being put into the application via jo

application via journal entries. urnal entries. The HFM journaThe HFM journal process is a topic for a futurel process is a topic for a future blog, but understand that journal data is stored in a

blog, but understand that journal data is stored in a specific Value dimensionspecific Value dimension member called “Entity Currency

member called “Entity Currency Adjust.”Adjust.” Here we see Here we see that journthat journal entries hal entries haveave their own home because the Value dimension acts like an

their own home because the Value dimension acts like an audit trail!audit trail! The simple mathematical formulas to keep in mind are as follows: The simple mathematical formulas to keep in mind are as follows: Entity Currency + Entity Currency Adjust = Entity Currency Total Entity Currency + Entity Currency Adjust = Entity Currency Total Entity Currency Total x foreign currency rate (which in

Entity Currency Total x foreign currency rate (which in this example is 0.9758) =this example is 0.9758) = Parent Currency

Parent Currency Below we see

Below we see journal entry data in the amount of 100.00 in Entity Curr Adjs (thejournal entry data in the amount of 100.00 in Entity Curr Adjs (the system abbreviation o

system abbreviation of Entity Currency Adjuf Entity Currency Adjust). st). This 100.00 gets addeThis 100.00 gets added to thed to the 2,500.00 in Enti

2,500.00 in Entity Currency to give us 2,600.00 in Entity Curr Totaty Currency to give us 2,600.00 in Entity Curr Total. l. The 2,600.00The 2,600.00 is then translated to 2,537.08 at Parent Currency by the

is then translated to 2,537.08 at Parent Currency by the system.system.

Clients often want to know why a

Clients often want to know why a journal posted to Entity Currency Adjust doesjournal posted to Entity Currency Adjust does not show up as a translated valu

not show up as a translated value in Parent Currency Adje in Parent Currency Adjust. ust. The ValueThe Value dimension does no

dimension does not work that way. t work that way. Entity Currency and EEntity Currency and Entity Currency Adjntity Currency Adjustust are first added together in the En

are first added together in the Entity Currency Total triptity Currency Total triplet. let. The Entity CurrencyThe Entity Currency Total value is then transla

Total value is then translated to produce a value in Pareted to produce a value in Parent Currency. nt Currency. ParentParent Currency Adjust is reserved for journals that are

Currency Adjust is reserved for journals that are posted in the currency of anposted in the currency of an entity’s parent.

entity’s parent. Parent Currency combParent Currency combined with Parent Currenined with Parent Currency Adjust equalscy Adjust equals Parent Currency Total in this triplet.

Parent Currency Total in this triplet. The mathematical formula to would The mathematical formula to would be:be:

Parent Currency + Parent Currency Adjust = Parent

Parent Currency + Parent Currency Adjust = Parent Currency TotalCurrency Total

Building on our previous example, below we have added a Parent Curr Adjs Building on our previous example, below we have added a Parent Curr Adjs (the(the system abbreviation for Parent Currency Adjust) in the amount of

system abbreviation for Parent Currency Adjust) in the amount of 200.00.

200.00. Combined with the translated value of 2,5Combined with the translated value of 2,537.08 in Parent Currency, the37.08 in Parent Currency, the amount in Parent Currency Total is calculated at

(3)

There will be more to come

There will be more to come on the other members of the Value Don the other members of the Value Dimension, butimension, but if you can grasp what I have covered so far you are well on your way to

if you can grasp what I have covered so far you are well on your way to understanding the intricacies of

understanding the intricacies of HFM dimensionality.HFM dimensionality. Author: Joseph Francis, Performance Architects

Author: Joseph Francis, Performance Architects

http://www.perform

http://www.performancearchitecancearchitects.com/wp/201ts.com/wp/2015/05/27/or5/05/27/oracle-hyperioacle-hyperion- n- financial-m

(4)

HFM - Value Dimension and Rules HFM - Value Dimension and Rules

Maybe the complex part of HFM is the

Maybe the complex part of HFM is the value dimension and rules, after youvalue dimension and rules, after you understand these two parts of HFM elements I am

understand these two parts of HFM elements I am sure you will get a sure you will get a betterbetter understand of HFM's consolidation logic. So let me introduce the value

understand of HFM's consolidation logic. So let me introduce the value dimension first.

dimension first.

Value dimension is a system-defined dimension, it represents the types of value Value dimension is a system-defined dimension, it represents the types of value stored in your application. You can find the following image for your quick

stored in your application. You can find the following image for your quick understanding if this dimension.

understanding if this dimension.

Actually, you will find the dimension shows in HFM system as below, depending Actually, you will find the dimension shows in HFM system as below, depending on how many currencies you have

on how many currencies you have set up for the application. (5 currencies in thisset up for the application. (5 currencies in this example.)

(5)

Technically, <EC>, <ECA>, <ECT>, <PC>, <PCA> and <PCT> are the pointers to the Technically, <EC>, <ECA>, <ECT>, <PC>, <PCA> and <PCT> are the pointers to the currency members. For example, if the entity and its parent's local c

currency members. For example, if the entity and its parent's local currenciesurrencies are HKD, the data

are HKD, the data will be stored in "HKD" member when input data in <EA> orwill be stored in "HKD" member when input data in <EA> or translate data to <PA>.

translate data to <PA>.

For the sub group rollup logic in Entity dimension, you can find the picture For the sub group rollup logic in Entity dimension, you can find the picture below. Sub Group's <EC> =

below. Sub Group's <EC> = Sum of the Sum of the children Subsidiaries/Achildren Subsidiaries/Associates/Jointssociates/Joint Ventures' [Contribution Total]

(6)

After the understanding the value dimension, we can move to the

After the understanding the value dimension, we can move to the HFM rule'sHFM rule's calculation logic. Actually, the HFM admin guide describes very clearly about the calculation logic. Actually, the HFM admin guide describes very clearly about the rules so I just copy some of the contents here.

rules so I just copy some of the contents here.

You use Financial Management rules to automate the calculations of data You use Financial Management rules to automate the calculations of data within an application. You can use rules for these purposes:

within an application. You can use rules for these purposes: 

 Calculate data entry level amounts for a specific entity, scenario, andCalculate data entry level amounts for a specific entity, scenario, and

period. period. 

 Prevent data entry for a Prevent data entry for a specific cell in a specific entity, scenario, andspecific cell in a specific entity, scenario, and

period. period. 

 Allow input at the Parent entity level.Allow input at the Parent entity level.



 Calculate data that cannot be Calculate data that cannot be calculated through a hierarchicalcalculated through a hierarchical

aggregation, such as ratios or

aggregation, such as ratios or variance analysis.variance analysis. 

 Perform allocations from a parent entity to a list of Perform allocations from a parent entity to a list of base entities.base entities.



 Perform complex currency conversions, calculate exchange ratePerform complex currency conversions, calculate exchange rate

differences, or perform other calculations necessary for

(7)



 Define formulas to dynamically calculate accounts.Define formulas to dynamically calculate accounts.



 Specify the accounts in Specify the accounts in the application that support intercompanythe application that support intercompany

transactions. transactions.

HFM provides the following rule

HFM provides the following rule typestypes   CalculationCalculation   TranslationTranslation   ConsolidationConsolidation   AllocationAllocation   InputInput   NoInputNoInput 

 Dynamic CalculationDynamic Calculation



 TransactionsTransactions



 Equity PickupEquity Pickup



(8)

(9)

During the consolidation process, rules are executed in a pre

During the consolidation process, rules are executed in a pre-defined sequence.-defined sequence. For each base child of

For each base child of a specific parent, the calculation sequence for the a specific parent, the calculation sequence for the variousvarious elements in the Value dimension takes place in this order:

elements in the Value dimension takes place in this order: 1.

1. Accounts defined as IsCalculated in the metadata are cleared inAccounts defined as IsCalculated in the metadata are cleared in EntityCurrency.

EntityCurrency. 2.

2. Accounts defined as IsCalculated in the metadata are cleared inAccounts defined as IsCalculated in the metadata are cleared in EntityCurrAdjs.

EntityCurrAdjs. 3.

(10)

4.

4. The Sub Calculate() routine The Sub Calculate() routine is executed on is executed on EntityCurrAdEntityCurrAdjs.js. 5.

5. The ParentCurrency data is cleared.The ParentCurrency data is cleared. 6.

6. Default translation is applied to all accounts defined as Default translation is applied to all accounts defined as Revenue,Revenue, Expense, Asset, Liability for the

Expense, Asset, Liability for the total amount of EntityCurrency andtotal amount of EntityCurrency and EntityCurrAd

EntityCurrAdjs. For accounts js. For accounts with the Flow or with the Flow or Balance attribute,Balance attribute, translation is not applied by

translation is not applied by default, the total amount of default, the total amount of EntityCurrencyEntityCurrency and EntityCurrAdjs is rolled up into

and EntityCurrAdjs is rolled up into Parent Currency.Parent Currency. 7.

7. The Sub Translate() routine is executed.The Sub Translate() routine is executed. 8.

8. The Sub Calculate() routine is executed on ParentCurrency.The Sub Calculate() routine is executed on ParentCurrency. 9.

9. Accounts defined as “IsCalculated” in the metadata are Accounts defined as “IsCalculated” in the metadata are cleared incleared in

ParentCurrAdjs. ParentCurrAdjs. 10.

10. The Sub Calculate() routine is executed on ParentCurrAdjs.The Sub Calculate() routine is executed on ParentCurrAdjs. 11.

ParentAdjs ParentAdjs 12.

12. The Sub Calculate() routine is executed on ParentAdjs.The Sub Calculate() routine is executed on ParentAdjs. 13.

13. Proportion and Elimination data are cleared.Proportion and Elimination data are cleared. 14.

14. Default consolidation and eliminations are performed for the totalDefault consolidation and eliminations are performed for the total amount of Parent and

amount of Parent and ParentAdjs.ParentAdjs. 15.

15. The Sub Calculate() routine is executed on Proportion andThe Sub Calculate() routine is executed on Proportion and Elimination.

Elimination. 16.

ContributionAdjs. ContributionAdjs. 17.

17. The Sub Calculate() routine The Sub Calculate() routine is executed on is executed on ContributioContributionAdjs.nAdjs. After the previous steps have been

After the previous steps have been repeated for each base child, this sequencerepeated for each base child, this sequence takes place for the

takes place for the parent entity:parent entity: 1.

1. The EntityCurrency data is cleared.The EntityCurrency data is cleared. 2.

2. The sum of The sum of the total of the total of Proportion, EliminProportion, Elimination, andation, and Contributio

ContributionAdjs for every nAdjs for every child is written into EntityCurrency of child is written into EntityCurrency of thethe parent entity.

parent entity. 3.

3. The Sub Calculate() routine is executed on EntityCurrency.The Sub Calculate() routine is executed on EntityCurrency. 4.

EntityCurrAdjs. EntityCurrAdjs. 5.

(11)

Note: If a parent is

Note: If a parent is further consolidated into another parent, this sequencefurther consolidated into another parent, this sequence continues with step 5 from the c

continues with step 5 from the child consolidation sequenhild consolidation sequence.ce.

http://hyperion

http://hyperioncenter.blogscenter.blogspot.in/2014pot.in/2014/12/hfm-value/12/hfm-value-dimension-a-dimension-and- nd-rules.html

rules.html

The “subcube” describes the structure of data storage

The “subcube” describes the structure of data storage and retrieand retrieval inval in Hyperion’s Financial Management solution

Hyperion’s Financial Management solution1 (HFM). The 1 (HFM). The approach to subcubeapproach to subcube management in HFM has changed significantly with this release to improve management in HFM has changed significantly with this release to improve performance and to facilitate much larger subcube sizes than were

performance and to facilitate much larger subcube sizes than were previouslypreviously possible.

possible.

DEFINING THE S

DEFINING THE SUBCUBE HFM stores data in one of three table types: • DCEUBCUBE HFM stores data in one of three table types: • DCE (Currency subcube)

(Currency subcube)——Stores Entity Currency and Parent Currency values andStores Entity Currency and Parent Currency values and their adjustments. These are often referred to as

their adjustments. These are often referred to as the currency triplets in thethe currency triplets in the Value dimension: o The triplets are formed by the

Value dimension: o The triplets are formed by the entity default currency,entity default currency, journal adju

journal adjustments postments posted in the sted in the entity’s defauentity’s default currency, lt currency, and the totaland the total aggregated value of the two. o

aggregated value of the two. o If the entity’s parent has a different defaultIf the entity’s parent has a different default

currency, a second triplet of data is provided for the parent currency. o It is also currency, a second triplet of data is provided for the parent currency. o It is also possible for a user to force

possible for a user to force a translation into another currency in addition to thea translation into another currency in addition to the . The result of this

. The result of this forced translation is a set of stored forced translation is a set of stored data in the additionaldata in the additional currency. • DCN (Parent

currency. • DCN (Parent subcube)—subcube)—Stores the remaining Value dimensionStores the remaining Value dimension members. o All data in the

members. o All data in the Parent cube is specific to Parent cube is specific to a parent-child combination,a parent-child combination, and as such c

and as such can only be stored or an only be stored or retrieved by specifying this relationship. DCNretrieved by specifying this relationship. DCN tables are structurally similar to DCE tables, with one

tables are structurally similar to DCE tables, with one exception: DCN tablesexception: DCN tables contain an additional fi

contain an additional field for the parent entity ID (LPARENT). • DCT (Journaleld for the parent entity ID (LPARENT). • DCT (Journal transactions)

transactions)——Stores the journal transactions, which when Stores the journal transactions, which when posted, transferposted, transfer data values to DCE (for

(12)

Adjs]). The following graphic shows the Value dimension and which members Adjs]). The following graphic shows the Value dimension and which members are grouped into each subcube:

are grouped into each subcube:

http://charlescbeyer.com/ccb_wp/wp-content/uploads/2013/05/Hyperion_System_9_Financial_Management_Subcub content/uploads/2013/05/Hyperion_System_9_Financial_Management_Subcub e_Architecture_0406.pdf e_Architecture_0406.pdf About Subcubes About Subcubes

Several Financial Management methods work with

Several Financial Management methods work with subcubes.subcubes. A subcube consists A subcube consists of all the cells

of all the cells that share the same members of the that share the same members of the following dimenfollowing dimensions:sions:   YearYear   ScenarioScenario   EntityEntity   ValueValue

There are two types of subcubes

There are two types of subcubes——currency subcubescurrency subcubes and and node subcubes.node subcubes. These These types of subcubes differ in how they

types of subcubes differ in how they use Entity and Value dimension members:use Entity and Value dimension members: 

 A currency subcube contains cells that share A currency subcube contains cells that share applicable non-node Valueapplicable non-node Value dimension members. For currency subcubes, the parent of

dimension members. For currency subcubes, the parent of the Entitythe Entity member is irrelevant. The applicable non-node Value

member is irrelevant. The applicable non-node Value dimensiodimension membersn members are as follows:

are as follows:

o

o Members for user-defined currencies. There is one triplet of ValueMembers for user-defined currencies. There is one triplet of Value

dimension members for each user-defined currency. For

dimension members for each user-defined currency. For example, ifexample, if an application contains a currency named USD, the

an application contains a currency named USD, the currency’scurrency’s

triplet of Value dimension members will be USD, USD Adjs, and USD triplet of Value dimension members will be USD, USD Adjs, and USD Total.

(13)

o

o The triplet that poinThe triplet that points to the ts to the entity’s default currency. This tripletentity’s default currency. This triplet

consists of the

consists of the <Entity Currency>, <Entity Curr Adjs>, and <Entity<Entity Currency>, <Entity Curr Adjs>, and <Entity Curr Total> Value members.

Curr Total> Value members.

o

o [None] Value member.[None] Value member.

Note:

Note: The The non-non-node Value dimension members that point to parent entities’node Value dimension members that point to parent entities’ default currencies

default currencies——<Parent Currency>, <Parent Curr Adjs>, and<Parent Currency>, <Parent Curr Adjs>, and <Parent Curr Total>

<Parent Curr Total>——are irrelevant to currency subcubes.are irrelevant to currency subcubes.



 A node subcube contains cells that share a A node subcube contains cells that share a common node Valuecommon node Value dimension member. For node subcubes, both parent and

dimension member. For node subcubes, both parent and child Entitychild Entity members must be specified. The node Value dimension members are as members must be specified. The node Value dimension members are as follows:

follows:

o

o [Contribution [Contribution Total]Total] o

o [Contribution [Contribution Adjs]Adjs] o o [Contribution][Contribution] o o [Elimination][Elimination] o o [Proportion][Proportion] o

o [Parent Total][Parent Total] o

o [Parent Adjs][Parent Adjs] o

(14)

This is nothin

This is nothing more than Entitg more than Entity Currency + Entity Curr Ay Currency + Entity Curr Adjs. djs. It is the totalIt is the total

local currency inclusive of

local currency inclusive of adjustmadjustments and ents and loaded/submloaded/submitted data.itted data.

Parent Currency

Next up the chain is Parent C

Next up the chain is Parent Currency. urrency. This memThis member takes total local curber takes total local currencyrency

(Entity Curr Total)and translates it to the currency of its immediate parent in

the entity hierarchy.

Back to our good old

Back to our good old friends across the pond in the London sales office, sincefriends across the pond in the London sales office, since

they roll up to a Euro parent company, the system will translate from GBP to

EUR when the consolidation goes from Entity Curr Total to Parent Currency.

(15)

The above shows a translation from GBP to

The above shows a translation from GBP to EUR using a currency rate of €1.25EUR using a currency rate of €1.25 to £1.00

to £1.00

Parent Currency Adjustments

Up from Parent Currency is Parent Curr Adjs.

Parent CurrAdjs is an intersection that allows users the ability to book an

adjusting journal in the currency of the entity’s parent. It is

adjusting journal in the currency of the entity’s parent. It is NOT the Entity NOT the Entity

CurrAdjs trans

CurrAdjs translated. lated. Recall that EntitRecall that Entity Currency and Entity Cuy Currency and Entity CurrAdjs getrrAdjs get

added together at Entity Curr

added together at Entity Curr Total, which then translates to ParentTotal, which then translates to Parent

Currency.

Let’s assume that the London sales

Let’s assume that the London sales office had to book a 150K office had to book a 150K EUREUR

adjustment.

adjustment. Instead of figuring out Instead of figuring out what that amount what that amount is in is in GBP and GBP and bookingbooking

in Entity CurrAdjs, the sales office has the option of booking the 150K

in Entity CurrAdjs, the sales office has the option of booking the 150K EUREUR

straight to Parent Curr Adjs.

Parent Currency Total

As before, the totals for Parent Currency and

As before, the totals for Parent Currency and Parent CurrAdjs are addedParent CurrAdjs are added

together to get to

together to get to Parent Curr Total, which is the total post-translated amountParent Curr Total, which is the total post-translated amount

inclusive of any parent

(16)

For the purpose

For the purpose of simplification, we will jump ahead of simplification, we will jump ahead to the Eliminationto the Elimination

Value dimension m

Value dimension member. ember. Though there Though there are other are other Value dimension Value dimension membersmembers

between Parent Curr Total and

between Parent Curr Total and EliminatElimination, these are ion, these are not typically used othernot typically used other

than for percent

than for percent ownership, equity pickup, and blah blah, ownership, equity pickup, and blah blah, accounting speak,accounting speak,

blah debit, blah, credit.

blah debit, blah, credit. We’ll save that for another time.We’ll save that for another time.

Elimination

Elimination.

Elimination. The one word that caThe one word that can make anyone cringe wn make anyone cringe when it comes tohen it comes to

data tie out or passin

data tie out or passing of data between systg of data between systems. ems. EliminationEliminations are necessarys are necessary

when two entities that belong to the same organization have activity with one

another. Though it is important to be able to

another. Though it is important to be able to see that activity at the entitysee that activity at the entity

level, it has to be zeroed out at th

level, it has to be zeroed out at the appropriate consoe appropriate consolidation point. lidation point. After all,After all,

a company can’t make money off of

a company can’t make money off of itself (we’re not running a Ponzi schemeitself (we’re not running a Ponzi scheme

here).

Why do we need to load Elim

Why do we need to load Elimination data if it just netination data if it just nets to zero? s to zero? ValidValid

question

question – – if it doesn’t net to zero, or if it zeroes out across levels, it if it doesn’t net to zero, or if it zeroes out across levels, it isis

important to hav

important to have the detail to suppe the detail to support all of the activity. ort all of the activity. Enter theEnter the

Elimination dimension.

(17)

To keep it s

To keep it simple, let’s say that Company A has imple, let’s say that Company A has a receivable from Companya receivable from Company

B.

B. Company B shouCompany B should have the offsettld have the offsetting Payable on their booking Payable on their books.s.

That intercompany transaction

That intercompany transactions between Company A s between Company A and Company B are and Company B are notnot

eliminated (zeroed above) until the first common parent of each company is

met.

met. To keep things simple, let’s To keep things simple, let’s just say that both companies roll up just say that both companies roll up toto

parent Comp

parent Company AB. any AB. This is where This is where it will elimit will eliminate.inate.

Contribution

Contribution represents what ultimately gets passed from child to

parent.

parent. Keeping it simKeeping it simple, it is equal to Parent Curr Tple, it is equal to Parent Curr Total +otal +

Elimination.

Elimination. This total then gets sent up This total then gets sent up the chain to its the chain to its parent’s Entityparent’s Entity

Currency member.Seen below, Entity Currency for the

Currency member.Seen below, Entity Currency for the parent entity (Totalparent entity (Total

Europe) is the sum of the Contribution amounts from each of its children

(London & Zurich).

(18)

Now, putting it all together, hopefully you should be able to make some sense

of Oracle’s diagram of the Value d

of Oracle’s diagram of the Value dimension, seen below.imension, seen below.

And then the process starts

And then the process starts all over again…all over again…

…with Total Europe at

…with Total Europe at Entity Currency and continues upwards throughEntity Currency and continues upwards through thethe

Value dimension and, ultimately, gets to total company consolidated financial

statements.

http://platfor

http://platformspecialismspecialists.com/2015ts.com/2015/03/30/the-real/03/30/the-real-value-of-co-value-of-consolidationnsolidations-in- s-in-hfm/