Create a Cubeview Entity List From "In Use" and Member Property "ReadWriteDataGroup"

[Jared]

Hello All, 

I am trying to create a cube view or report if necessary to list our active Entities. I've been able to filter by "In Use", but we also need to include the Member Property of "ReadWriteDataGroup" where its set to "Administrator".  Is that even possible or would a Business Rule Member List contain the arguments necessary?

Thanks for any suggestions!

[EricOsmanski]

E#Member.Base.Where((UserInReadWriteDataGroup = True) And (InUse = True))

[Jared]

Thanks for the reply! 

I found that member filter, but since we always have something in that field, it's always True. I need a way to filter based on ReadWriteDataGroup = or <> Administrator.

Any ideas?

[JackLacava · Accepted solution]

---

@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.

[Jared]

I came to the same conclusion. We are utilizing all of the text fields, so it looks like a custom member list will be our option.

thanks!