Skip to main content
J
Jared
Newcomer
March 15, 2023
Solved

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

  • March 15, 2023
  • 2 replies
  • 0 views

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?

Jared_G_0-1678899488416.png

Thanks for any suggestions!

Best answer by JackLacava
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.

2 replies

E
OneStream Employee
EricOsmanskiOneStream Employee
OneStream Employee
March 15, 2023

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

 

    J
    JaredAuthor
    Newcomer
    March 15, 2023

    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?

    J
    OneStream Employee
    JackLacavaOneStream EmployeeAnswer
    OneStream Employee
    March 16, 2023
    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.

      J
      JaredAuthor
      Newcomer
      March 16, 2023

      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!

      Terms & ConditionsAccessibility statement