Repository Security Table joins

[bryani]

I'm trying to set up a universe that will allow users to enter a name (M_ACTOR_C_NAME) and return all group names that they are associated with. How should the various rows/fields be linked to each other in order to retrieve the correct results?

 

[nimmy99]

Take the following two table from your repository DB:
OBJ_M_ACTORLINK
OBJ_M_ACTOR
link the follwing fields
M_ACTL_N_ACTORID from OBJ_M_ACTORLINK table
M_ACTOR_N_ID from OBJ_M_ACTOR table
detect for cardinality, otherwise set to M to 1. Then try.

 

[bryani]

Thanks ... I'm able to set up the universe now.