Siebel Analytics Installation and Configuration Guide > Configuring Authentication in Analytics and Operational Applications > Implementing Data-Level Security in the Analytics Repository >

Configuring Analytics Repository Table Joins for Security

You can add security to a new dimension in Siebel Analytics. Set up the joins for that table to the appropriate security tables in the metadata physical and logical layers. The following task uses W_AGREE_D (Agreements) as an example.

To configure the physical table join between W_AGREE_D and W_PARTY_LOGIN

1. Create an alias on W_PARTY_LOGIN specifically to join to W_AGREE_D.
2. Configure the join in the physical layer.
3. Configure a logical table join by adding the appropriate tables in the business layer.

   NOTE:  The columns VIS_PR_POS_ID and VIS_PR_BU_ID in the dimensional tables contain the record's primary owning position and owning organization.

4. Configure the filter on the logical tables that restrict the data.
   1. To set up a filter, 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.

Organization-based security has been implemented using the row-wise initialized variable ORGANIZATION. This implementation is slightly different from that of the position-based security, because the number of organizations is usually limited, compared to the number of positions in a given environment. Therefore, using the row-wise initialized variable ORGANIZATION to filter data using a WHERE IN clause is efficient. However, joining the dimension with the W_PARTY_LOGIN is more efficient, because the number of positions used for filtering the data can be large.

For more information about security groups and filters as well as on how to set up joins in the repository, see Siebel Analytics Server Administration Guide.