Forum Discussion

Jared's avatar
Jared
New Contributor II
2 years ago

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

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!

Cube View
  • JackLacava's avatar
    JackLacava
    2 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.

  • EricOsmanski's avatar
    EricOsmanski
    Valued Contributor
    2 years ago

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

     

  • Jared's avatar
    Jared
    New Contributor II
    2 years ago

    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's avatar
      JackLacava
      Honored Contributor
      2 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.

      • Jared's avatar
        Jared
        New Contributor II
        2 years ago

        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!