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.
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
Went back and reviewed and you are correct. I was using a param to pass it along...
E#|!varEntity!|
U3#WBSDim.Base.Where(Text2 = XFMemberProperty(DimType=Entity, Member=|!varEntity!|, Property=Name))
But because you are pulling the E# at .Base it makes it a bit more tricky.
Yeah, that's what I figured.
But all good, thanks for trying and sending some solution to test. At least I will save the XFMemberProperty reference for the future, as I think I will need it in another scenario.
I am suggesting a differente solution to the client, i.e. showing the property in a data column (using UD8) - it won't be in the exact right order but at least they will get the right information.
Thanks
It wouldn't be quite as elegant, but if you don't have a lot of entities, you could create a literal param like...
E#Entity1:U3#WBSDim.Base.Where(Text2 = Entity1), E#Entity2:U3#WBSDim.Base.Where(Text2 = Entity2), etc...
Then on your CV set Use Default Row Headers to False and make Header 1 Entity and Header 2 UD3.
That should give you the report in the style you are looking for, but it would require maintenance as entities are created.
