This content has been marked as final. Show 6 replies
I would suggest structuring something using HS.Custom1.IsBase. See below:
If HS.Custom1.IsBase("CUSTOMPARENT1","") = TRUE Then
If HS.Custom1.IsBase("CUSTOMPARENT2","") = FALSE Then
This only compares in one direction Parent1 -> Parent2, but should be enough to get you pointed in the right direction... You could consider setting up a common parent custom member for these two hierarchies to simplify the filtering of the members.
+'First determine if the member is part of the rollup of the two hierarchies for comparison+
If HS.Custom1.IsBase("CUSTOMPARENT_TOP","") = TRUE Then
+'Next, see if the member does not exist in one of the hierarchies+
If HS.Custom1.IsBase("CUSTOMPARENT1","") = FALSE or HS.Custom1.IsBase("CUSTOMPARENT2","") = FALSE Then
+'Close out your IF statements+
For more details on this function, use http://docs.oracle.com/cd/E17236_01/epm.1112/hfm_admin.pdf, pages 279-281. As a note, the second set of empty quotes in the function dynamically checks the current member.
Hope that helps,
Edited by: SDuplaga on May 22, 2013 11:30 AM
Scott, I tried the first suggestion and it fails right away on the first line. With error "Error in function ISBASE"
Please post the content of the rule for review.
If HS.Custom1.IsBase("BUSINESSLINE","") = TRUE Then
If HS.Custom1.IsBase("OTH_BUSINESSLINE","") = FALSE Then
I even tried:
If HS.Custom1.IsBase("","") Then
Both times I just force calculated on a single base entity.
For Each sC1 In HS.Custom1.List("BUSINESSLINE","[Base]")
If HS.Custom1.IsBase("OTH_BUSINESSLINE",sC1) = FALSE Then
HS.Clear "A#NETREV.C1#" & sC1
Brian, That worked. Thanks.