Oracle^® Business Intelligence Applications Installation and Configuration Guide > Integrated Security for Oracle BI Applications >

Configuring Oracle BI Repository Table Joins for Security

You can add security to a new dimension or fact in Oracle Business Intelligence. You set up the joins for that table to the appropriate security tables in the metadata physical and logical layers. The following tasks uses a dimension W_AGREE_D (Agreements) as an example.

To add security support to a dimension

1. Create an alias on W_POSITION_DH specifically to join to the underlying physical table.
2. Configure the join in the physical layer.
3. Add the W_POSITION_DH alias to the dimension's Logical table source.
4. Add new logical columns CURRENT_BASE_LOGIN, CURRENT_LVL1ANC_LOGIN,...to the logical table, and map them to the corresponding physical columns.
5. Open the security groups: Hierarchy Level (Base), Hierarchy Level 1,..., Hierarchy Level (Top), and add filters as follows:
   1. Right-click the group and choose Properties.
   2. In the Properties dialog box, click the Permissions box and select the Filter tab.
   3. To add a new filter, click on the ellipsis box and find the business model layer table that needs to be secured.
   4. Configure the WHERE clause on the table so that the data is filtered.

To add security support to a fact

1. Join the underlying physical table to Dim_W_POSITION_DH_Position_Hierarchy.
2. Join the logical table to the Dim - Security Dimension.
3. Open the security groups: Hierarchy Level (Base), Hierarchy Level 1,..., Hierarchy Level (Top), and add filters as follows:
   1. Right-click the group and choose Properties.
   2. In the Properties dialog box, click the Permissions box and select the Filter tab.
   3. To add a new filter, click on the ellipsis box and find the business model layer table that needs to be secured.
   4. Configure the WHERE clause on the table so that the data is filtered.