Previous Topic  Next Topic

Example of Using Business View Security

This topic provides an example to illustrate how you can set security for a business view in a catalog in Designer and run a report that uses the business view with different users to apply the security on Server.

This example uses the business view WorldWideSalesBV in the SampleReports.cat catalog file. It is assumed that the Server administrator has already created two users on Server: User1 and User2, with the passwords "abc" and "xyz" respectively. We create a security policy on SampleReports.cat to limit the two users' access to different group members of WorldWideSalesBV. Before starting the example, make sure you already launch Server.

The example contains the following tasks:

• Task 1: Set security on business view groups
• Task 2: Create a crosstab and publish it to Server
• Task 3: View the crosstab

Task 1: Set security on business view groups

In this task, we import the two Server users to Designer and limit their access to different members of the Region group in WorldWideSalesBV.

1. Make sure SampleReports.cat is the currently open catalog file. If not, select File > Open Catalog to open it from <install_root>\Demo\Reports\SampleReports.
2. In the Catalog Manager, go to the Data Source 1 > Security > Business View Security node, right-click and select Edit Business View Security from the shortcut menu.
3. In the Edit Business View Security dialog box, select and select Import from Logi Report Server.
4. In the Connect to Logi Report Server dialog box, specify the required connection information and select Connect.

   Designer imports the principals created on Server and lists them in the Users/Groups/Roles panel.

   

Next, we assign field members' availability to User1 and User2. We give User1 access to the North America region only, and grant User2 access to regions other than North America.

6. Select User1, then in the Resources box, select Region in WorldWideSalesBV.
7. In the Security Options box, clear Use Default.
8. In the Data Security box, allow the Access permission.
9. Select above the Allowed Set box.
10. In the Edit Values dialog box, select North America from the Available Values box and select to add it to the Selected Values box, then select OK to close the dialog box.

    

11. In the Edit Business View Security dialog box, clear the option Allow Unspecified Members, then in the Resource Security box, allow the Visible permission.

    

12. Select User2 and the same field Region in WorldWideSalesBV, then clear Use Default in the Security Options box.
13. In the Data Security box, allow the Access permission, then select above the Denied Set box.
14. In the Edit Values dialog box, select North America from the Available Values box and select . Select OK to close the dialog box.
15. In the Resource Security box of the Edit Business View Security dialog box, allow the Visible permission for User2.

    

16. Select OK in the Edit Business View Security dialog box to save the changes.
17. Close the Catalog Manger.

Task 2: Create a crosstab and publish it to Server

In this task, we create a crosstab using WorldWideSalesBV in the SampleReports catalog and then publish it to Server.

1. In Designer, select File > New > Web Report. Designer creates a blank web report.
2. Select Insert > Crosstab. Designer displays the Create Crosstab wizard.
3. In the Data screen, select WorldWideSalesBV under Data Source 1, then select Next.
4. In the Display screen, select Region as the column field, Category as the row field, and Total Sales as the summary field. Select Finish to create the crosstab.

   

5. Select the View tab to preview the crosstab. It shows full data.

   

6. Select the Design tab to go back to design mode and select File > Save to save the crosstab as mlscrstab.wls.

Next, we publish the crosstab to Server.

7. Select File > Publish > Publish Report to Server.
8. In the Connect to Logi Report Server dialog box, specify the required connection information and select Connect.
9. In the Publish to Logi Report Server dialog box, clear the All checkbox and then select SampleReports.cat and mlscrstab.wls only.
10. Select the Browse button next to the Publish Resource To text box, then in the Select Folder dialog box, select Public Reports in the Folder box and select OK.
11. In the Publish to Logi Report Server dialog box, select the More Options button, select mlscrstab.wls in the resource box, then on the right panel, switch to the Permissions tab.

We need to grant the two users the necessary permissions on the web report, so that after we publish the report to Server, they are able to run them.

12. Select the Enable Setting Permissions checkbox, select the User sub tab, select User1 in the user box and select the Visible and Execute checkboxes; select User2 and do the same.

    

13. Select the OK button to publish the resources to Server.

Task 3: View the crosstab

Now, we can log onto Server as User1 and User2 separately to view the crosstab.

1. Log onto the Server Console as User1 with the password "abc".
2. Open the Public Reports folder and run the web report mlscrstab.wls. The result is:

   

3. Log out and then log in again as User2 with the password "xyz". Run the report and the result is:

   

Previous Topic  Next Topic