Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« BCMS PHASE 1 | Main | EPM system and role of EPM consultant »

Concept of Shared Members in HFM

We all know that members in HFM can be shared in different hierarchies, but the same can be shared amongst the parents lying under the same hierarchy as well. This is used to assist organizational changes during different periods/ months. Here is an example where an entity has to be shared amongst parents sitting under same hierarchy.

A member EN_Z is originally present under  EN_A in one hierarchy. This needs to be  made present under two parents i.e, EN_A  and EN_B.

Application Settings

  • DefaultValueForActive: Set it to 1.This is used for activating the ICP Entities to set % consolidation towards parent. 
  • OrgByPeriodApplication: Set it to Y.This specifies if new consolidation structures can co-exist with the past consolidation structures.
  • ConsolidationRule: Set it to Y.             
CSM-1.1.PNG

Consolidation Methods: Consolidation methods are important to be assigned to the ICP entities for setting a value in % consolidation parameter under ownership management (PCON). These parameters were set.

CSM-2.2.PNG

Changes in Entity Attribute Section: IsICP  attribute flag to be set as "N" for the entity chosen to be shared amongst parents sitting under same hierarchy. The entity which is flagged IsICP appears under the [ICP_Entities] as child. 

CSM-3.2.PNG

Changes in Entity Hierarchy Section:  Changes to be made in the entity hierarchy section in metadata file, so that the child entity appears under both the parents. 

CSM-4.1.PNG

Load Metadata: Load metadata changes with "merge" option.

CSM-5.png

Rules: Load blank rules in the application. This is required because :-

  • Rules in the application don't allow data input at the POV for system defined members( POV used in the coming sections of the document)
  • Assign method to the ICP entity and make it as active.
  • Assign consolidation method to the entity.

Assign Method to shared entity:  Select following POV in the grid, and ConsolMethod lying under Custom1 dimension. C1 should be  made as column and shared entity under [ICP Entities] as row. Insert 1 for assigning a method.

POV :

  • Scenario: Actual,
  • Year : 2017,
  • Period: P01,
  • View: YTD,
  • Entity: Select parent ( either EN_A or EN_B, whichever is required to be made active.),
  • Value : [None],
  • Account : System defined account [Method],
  • Product : [None],
  • Interco : [None],
  • DataType : [None]
CSM-6.png
CSM-7.png

Making entity as Active for particular period:  Select below POV in the grid, and select [None] lying under Custom1 dimension. C1 should be  made as column and shared entity under [ICP Entities] as row. Insert 1 for activating an entity.

 POV :

  • Scenario: Actual,
  • Year : 2017,
  • Period: P01,
  • View: YTD,
  • Entity: Select parent ( either EN_A or EN_B,, whichener is required to be made active.),
  • Value : [None],
  • Account : System defined account [Active],
  • Product : [None],
  • Interco : [None],
  • DataType : [None]
CSM-8.png
CSM-9.png

Ownership Management: Select POV as year, period, Actual, and parent entity to shared member. Here, EN_B. The settings done above automatically appear for the shared entity. (Here, Active as Yes and Method as "Proportional".)

 

CSM-10.png

Set PCON as 50. PMIN is automatically populated/calculated. Click Save.


CSM-10.1.pngLoad Rules : Load the original rules to the application.

Load Data : To the entity EN_Z under EN_B.

CSM-11.2.PNG

      Run Consolidations: Run consolidations and refresh to see the data at the parent (EN_B).

CSM-12.3.PNG







Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles