Forum Discussion

RafMarques's avatar
RafMarques
New Contributor III
3 years ago

Return items from one dimension based on another dimension

Hello I have a CubeView with 2 nested rows. Row 1 - |!varEntity!|.Base (say this will return 5 entities - this is a drop down in a Dashboard) Row 2 - XFBR(myModule_ParamHelper, GetWBS_by_Entity...
Cube View
Parameters
cjohnson's avatar
cjohnson
New Contributor III
3 years ago

I've done something similar in the past using the XFMemberProperty. If I'm understanding the desired outcome correctly, try something like WBSDim.Base.Where(Text2 = XFMemberProperty(DimType=Entity, Member = |MFEntity|, Property=Name). I want to say MFEntity works in this situation, but it's been a minute since I did this.