Create a Sample Schema for Groups and Group Members
The sample schema described here is deliberately simplistic, and is intended only to illustrate how to configure Oracle Analytics Server to use the schema.
The ACME_BI_GROUPS sample schema contains two tables and a view. The GROUPS table defines the list of external groups. The GROUPMEMBERS table and GROUPMEMBERS_VW view describe group membership for users that exist in your primary identity store.
An advantage of defining tables or views identical to those shown in the diagram is that the configuration of the BISQLGroupProvider can use the default SQL outlined in the table in Configure the BISQLGroupProvider SQL Authenticator.
You must map the users in your LDAP store to groups in your database table by login name. In the diagram, the value of G_MEMBER in the GROUPMEMBERS table must match the value of the LDAP attribute used for login, for example, uid, cn, or mail, as specified in the LDAP authenticator. You should not, for example, map the database groups by uid if the login attribute is mail. Create a GROUPMEMBERS_VW view with an outer join between the GROUPMEMBERS and GROUPS tables.