Business Views - Can you filter based off of CE group membership?

[gharing]

I would like to create a Business View filter that allows me to filter off of the current CE user's group membership.

I know you can do this with the current CE user's name ({CurrentCEUserName}), but cannot figure out if there is a way to do it by group.

Essentially, I want the following in a filter:
{ReportTable.GroupName} IN {CurrentCEGroupName}

Any help would be appreciated.

Thanks.

 

[Bobbber]

Create the additional filter in the Data Foundation. Then right click it in the left pane, and assign the group rights to it.

Bob

 

[splitthird]

I don't think it can be done. I believe this is intentional because a user may be a member of any number of groups and that doesn't map very neatly to a single line of selection formula whcih is what is required in the Data Foundaton in the Business View technology.