Forum Discussion

RafMarques's avatar
RafMarques
New Contributor III
2 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
2 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.

RafMarques's avatar
RafMarques
New Contributor III
2 years ago

Hi,

I tried this now but it complains about ","

U3#WBSDim.Base.Where(Text2 = XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Name))

I believe I can't use it since, based on the documentation, it should be used with Name and GetDataCell.

"Use this function with the Name() and GetDataCell() portion of a Member Filter."

Thank you