Forum Stats

  • 3,838,738 Users
  • 2,262,395 Discussions
  • 7,900,743 Comments

Discussions

Categories

HFM - Parent.Entity under Multiple Parent

athlon007
athlon007 Member Posts: 68 Blue Ribbon
in Financial Consolidation

Hi all,

I hope somebody can help me here. We have the following situation (org by period):

In an FR Report we are querying for entities Base of X and Base of Y

The issue is that the parent.entity combination (PMC.5555) exists under X and Y. So for example under parent

X we have the parent and entity PMC.5555 (5555 being the base)

Then under

Y we have the parent and entity PMC.5555 (5555 being the base)

The combination X.PMC is inactive

The combination Y.PMC is active

So now in the report the base entity is coming up twice because PMC.5555 is active.

I hope I was able to explain the issue. I was wondering if there is a memberlist I could make to accommodate this?

Otherwise I will have to go ahead and create a parent just for this case. e.g. PMC2.5555 and only have that one active under Y. E.g. Y.PMC2 active.


Thanks alot for feedback!

Tagged:
· Share on TwitterShare on Facebook

Answers

  • Anand Thota
    Anand Thota Member Posts: 32 Red Ribbon

    Hi Athlon,

    There are couple of ways that you can achieve this.

    Note: if you keep entity as inactive, that particular entity values will not consolidated to the patent entity, but you still can see the value at base entity.

    1. you can apply mathematical calculation to the FR report like to substract the value from shared member.
    image.png


    1. move the share member to (555) to the different entity hierarchy.
    image.png


    Thanks,

    Anand Thota.

    · Share on TwitterShare on Facebook
  • athlon007
    athlon007 Member Posts: 68 Blue Ribbon

    Thanks for your feedback Anand Thota.

    The thing is that I do not want the entity to appear twice.

    2021-03-24_11-07-14.jpg

    Thanks

    Roman

    · Share on TwitterShare on Facebook
  • Sounak_C
    Sounak_C Member Posts: 183 Bronze Badge

    Hi,


    Once you have marked the entity as inactive, I thought in FR, there is an option to display only the active entities for a particular scenario - year - period

    image.png


    Regards,

    S

    · Share on TwitterShare on Facebook
  • athlon007
    athlon007 Member Posts: 68 Blue Ribbon

    Hello Sounak,

    I have tried ticking this, but still it comes back with the doubles.

    Thanks and regards

    · Share on TwitterShare on Facebook
  • Anand Thota
    Anand Thota Member Posts: 32 Red Ribbon

    Hi Athlon,


    i think the base entity is still active (5555) so report will reflect two times, May be moving shared member to different alternative hierarchy will help you.

    Viewing Active Entities (oracle.com)


    Thanks,

    Anand Thota

    · Share on TwitterShare on Facebook
  • Sounak_C
    Sounak_C Member Posts: 183 Bronze Badge

    Hi,


    Have you marked the parent- entity combination as inactive under 'manage Ownerships'?


    image.png

    Regards,

    S

    · Share on TwitterShare on Facebook
  • athlon007
    athlon007 Member Posts: 68 Blue Ribbon

    This is what I have set

    2021-03-26_12-01-01.jpg


    · Share on TwitterShare on Facebook
  • Sounak_C
    Sounak_C Member Posts: 183 Bronze Badge

    Can you introduce a new parent (Y) under G_NI and then share 5599 under Y and then mark Y.5599 as Inactive.


    Regards,

    S

    · Share on TwitterShare on Facebook
  • User_75A0A
    User_75A0A Member Posts: 4 Green Ribbon

    Hi,

    I have solved this kind of request with a @DynamicPOV member list which recursively goes through the organisation and checks for the active descendants. I've solved it with these components (sorry for skipping the indentation, the forum does not seem to support it very well) :

    In the beginning of Sub EnumMembersInList() put these variables:

    EntPOV=HS.MemberListEntity

    ScenPOV=HS.MemberListScenario

    YearPOV=HS.MemberListYear

    PerPOV=HS.MemberListPeriod


    Initiate the member list like this (XX means the number of your member list):

    ElseIf HS.MemberListID = XX Then

    EntPOV=HS.MemberListEntity

    HS.AddEntityToList "", EntPOV


    If HS.Node.NumChild("E#" & EntPOV & ".S#" & ScenPOV & ".Y#" & YearPOV & ".P#" & PerPOV) > 0 Then

    Call ActiveDescendants(EntPOV, ScenPOV, YearPOV, PerPOV)

    End If


    Then in the member list file after all the list paste in the following code:

    Sub ActiveDescendants(xEnt, xScenPOV, xYearPOV, xPerPOV)

    sEntityToCheck = xEnt

    'check the children of the entity

    EntList = HS.Node.List("E#" & sEntityToCheck, "[Children]", "S#" & xScenPOV & ".Y#" & xYearPov & ".P#" & xPerPOV)

    For Each sEntityToCheck In EntList

    HS.AddEntityToList "", sEntityToCheck 'Add entity to the list

    'Check if entity has active children

    If HS.Node.NumChild("E#" & sEntityToCheck & ".S#" & xScenPOV & ".Y#" & xYearPOV & ".P#" & xPerPOV) > 0 Then

    'Yes -> check its children

    Call ActiveDescendants(sEntityToCheck, xScenPOV, xYearPOV, xPerPOV)

    End If

    Next

    End Sub


    Using this member list on the report should solve your issue.

    · Share on TwitterShare on Facebook
  • athlon007
    athlon007 Member Posts: 68 Blue Ribbon

    Thanks for the reply User_75A0A

    I will try this out, much appreciated.

    · Share on TwitterShare on Facebook