Siebel Analytics Applications Installation and Administration Guide > Integrated Security for Analytics Applications >

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.
   • To set up a filter, right-click the group and choose Properties.
   • In the Properties dialog box, click the Permissions box and select the Filter tab.
   • To add a new filter, click on the ellipsis box and find the business model layer table that needs to be secured.
   • Configure the WHERE clause on the table so that the data is filtered.