Any function like @variable to find the user group?

building semantic layer
1

Hi,
Like @variable(‘BOUSER’), is there any function to get the user group instead of user name?

Regds,
SEB

sachineb :uk: (BOB member since 2006-05-30)

2

There is no such function built-in. The only way you can do that is to set up a security table in the data mart. User the @variable(‘BOUSER’) to capture the Enterprise login, then join to the security table to get the user’s org level or group name.

substring :us: (BOB member since 2004-01-16)

3

The reason why there is not such function is that a user can belong to more user groups.

Marek Chladny :slovakia: (BOB member since 2003-11-27)