Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HFM Dynamic POV Member lists

649098Mar 6 2009 — edited Feb 13 2012
Hi there,

We are using the (@POV) directive in some of our dynamic entity member lists to get the user Scenario, Year and Period when building entity member lists (example below). However, it seems like these member lists which use the @POV directive can only be used in FR reports and are not visible in either HFM web data grids or smart view. Is there a way to use these dynamic POV member lists in HFM grids/forms?
What we are trying to do is build a dynamic entity member list which should always filter based on the Org By Period flag.


{color:#666699}Sub EnumMemberLists()

Dim EntityLists(1)

If HS.Dimension = "Entity" Then
EntityLists(1)="Dyn_Base(@POV)"
End If
End Sub

Sub EnumMembersInList()

If HS.Dimension = "Entity" Then
If HS.MemberListID = 1 Then

myActiveBaseList = HS.Node.List("myParentEntity", "[Base]", "S#" & HS.MemberListScenario & ".Y#" & HS.MemberListYear & ".P#" & HS.MemberListPeriod)

for i = LBound(myActiveBaseList) To UBound(myActiveBaseList)
HS.AddEntityToList " ", myActiveBaseList(i)
next

End If
End If

End Sub {color}
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2012
Added on Mar 6 2009
1 comment
2,904 views