Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
HFM - Parent.Entity under Multiple Parent

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!
Answers
-
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.
- you can apply mathematical calculation to the FR report like to substract the value from shared member.
- move the share member to (555) to the different entity hierarchy.
Thanks,
Anand Thota.
-
Thanks for your feedback Anand Thota.
The thing is that I do not want the entity to appear twice.
Thanks
Roman
-
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
-
Hello Sounak,
I have tried ticking this, but still it comes back with the doubles.
Thanks and regards
-
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
-
Hi,
Have you marked the parent- entity combination as inactive under 'manage Ownerships'?
Regards,
S
-
This is what I have set
-
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
-
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.
-
Thanks for the reply User_75A0A
I will try this out, much appreciated.