Forum Discussion

bharathsm's avatar
bharathsm
New Contributor
2 days ago

Cube View : Top10 Business- One member above the base hierarchy

I need assistance in selecting the immediate parent of a base member. Currently, I am using a Business Rule (BR) to identify the Top 10 Business, but I am unable to retrieve the correct members. My requirement is not to select the base members themselves, but rather the member directly above each base member in the hierarchy.

Scenario:  
I am using the following formula to select U6#Top_Business.Base.options. However, instead of retrieving the base members, I need to capture their immediate parent. Is there a member filter formula available that can achieve this?

U6#Root.CustomMemberList(BRName = -----, MemberListName = Ranked, RankType = Top, RankCount = 10, LoopMemberFilter = [U6#Top_Business.Base.options(Cube=Main_Cube, ScenarioType=Actual, MergeMembersFromReferencedCubes=False)], DataCellToRankMemberFilter = Cb#Main_Cube:E#Top:C#USD:S#Actual:T#2025M11:V#YTD:A#Example:F#Example_activity:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U7#Top:U8#Top)

No RepliesBe the first to reply