I have googled for a few hours but cant find a global variable to display the user group(s) on the OBI Publisher report.
Is that possible without setting up a session variable in the repository (because right now we use OBI without the BI Server repository). If it does not work, how
do I access a OBI Repository session variable in OBI Publisher? From somewhere I need to get the runtime session user groups.
I created a user called "regionaluser" in the web logic security realm. then I added this user to the catalog group "regionalusers". how do I now retrieve this information to place it in my sql queries in the bi publisher data model to limit the data set?
So far I can use the following in the BI Publisher Data Modell :
SELECT * FROM XXX WHERE
USERID = :xdo_user_name;
Now I need the same for the user group, but :xdo_user_group does not exist. How to add it or create this variable?
The LDAP is configured correctly now. I created a BIConsumer_new catalog group in the presentation services admin console. I can use that
console to set the permissions for the BI publisher report (somehow it does not work when I try to set the permissions using the bi publisher admin page - the permissions window does not open).
the question is still out there. how can I query with that catalog group OR ldap group in the BI Publisher data model?