Create a Cubeview Entity List From "In Use" and Member Property "ReadWriteDataGroup"
- 3 years ago
Jared wrote:
I found that member filter, but since we always have something in that field, it's always True.
I guess you mean that some entities have a different RWGroup, but the user is in that group as well, so the check always succeeds... in fact, if the user is an Administrator, I expect that check might always succeed regardless.
There isn't a way to do this in Where, I'm afraid; the only supported clauses are listed in the Design and Reference Guide in paragraph "Member Expansion Where Clause".
There are obviously plenty of workarounds. You can leverage the Text1-8 properties (conventionally 8, since it's reporting-related) to create alternative "groups" specific to CVs, which you can then fully check with Where clauses; or you can write a custom member list function to implement the precise check on RWGroup that you want.