HFM - Parent.Entity under Multiple Parent

athlon007

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!

Anand Thota

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.

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

Thanks,

Anand Thota.

athlon007

Thanks for your feedback Anand Thota.

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

Thanks

Roman

Sounak_C

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

Regards,

S

athlon007

Hello Sounak,

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

Thanks and regards

Anand Thota

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

Sounak_C

Hi,

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

Regards,

S

athlon007

This is what I have set

Sounak_C

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

User_75A0A

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.

athlon007

Thanks for the reply User_75A0A

I will try this out, much appreciated.