WEBGROUPS in Oracle BI 10g

While a lot of us are already focusing on Oracle BI 11g, I still also have to service some 10g clients. This one is a Oracle BIA 7.9.6 client with hundreds of responsibilities in Oracle eBS with access to Oracle BI. I used UDML to script the responsibilities into the repository. Via de weblog of KPI Partners I found the solution to assign the responsibilities to a Web Group.

Oracle eBS will be used to store the membership information. A group (responsibility) in the Oracle BI Repository belongs to a organization and a role.  This information can be retrieved from the responsibility in Oracle eBS. The organization is stored via a profile option (‘PER_SECURITY_PROFILE_ID’). In this case we specified an additional custom profile option to store the role (User, Superuser, Reportbuilder, etc.).  Via an Initialization Block the WEBGROUP-variable can be initialized.

Note: Do not forget to uncheck the ‘Use caching’ checkbox, to make sure that you retrieve the current values.

The only thing what’s left to do mis to create the roles and organizations as Webgroups in the Presentation Catalog.

Instead of making all the Oracle eBS responsibilities separately available in the Presentation Catalog, you’ll only have to define the Webgroups. In this case it was a difference of hundreds compared to about 10 to 15.

This could make your life a little bit easier.

One thought on “WEBGROUPS in Oracle BI 10g

  1. Hello I have the SupplierSales Repositary but I need the database & data

    could you please send me the database scripts & data for the tables, which are

    1] D1_CUSTOMER2
    2] D1_CALENDAR2
    3] D1_ORDERS2
    4] D1_PRODUCTS




Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.