This content has been marked as final. Show 5 replies
I am using the rtf template builder. is there maybe a xml attribute that can display me the oracle bi groups the user belongs too?
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?
the answer was to add new , custom roles with the enterprise manager and query those with :xdo_user_roles.