I need to display the “UserGroup” of the User who logs in to BO at the report, can some one help me out…
Thanks in advance…
Basha (BOB member since 2004-05-25)
I need to display the “UserGroup” of the User who logs in to BO at the report, can some one help me out…
Thanks in advance…
Basha (BOB member since 2004-05-25)
That’s very difficult to do. You’d have to include a handful of repository tables in your universe or have a 2nd dataprovider that reads from the repository. Even then it’s difficult to do due to the recursive nature of the repository.
Steve Krandel (BOB member since 2002-06-25)
Also remember that a user can be a member of many groups. You’d have to “code” to handle that as well.
Dwayne Hoffpauir (BOB member since 2002-09-19)
What Ecactly you mean by code…? Do you mean logic in at the report level…?
Thanks again…
Basha (BOB member since 2004-05-25)
It could be either in the data provider that Steve explained, or in the report.
Dwayne Hoffpauir (BOB member since 2002-09-19)
Thanks Steve and Dwayne…
Could you tell me which tables in the repository contains the User and UserGroup Info…?
Thanks again…
Basha (BOB member since 2004-05-25)
Look HERE for a discussion on that topic.
Also checkout the universe against the BO Repository.
Chris Pohl (BOB member since 2002-06-18)