BI Report on Group Mappings based upon Dynamic Criteria

Summary

Trying to build a custom report that returns all members from a set of Groups with Dynamic Member

Content

We have a set of Groups that are built on Dynamic Criteria. They correspond to the way our Human Resources Department divides up the various business groups across our company. The groups all have names that start with the same four-character string, "HRBP".

We want a report that lists all the members of all these groups together with a column that reflects the Group Name.

Here's how far we got:

1. We created a custom report that listed the group names and their descriptions.