The row-level permission setting must operate on datasets.

Background information

Currently, only in the workspace of Quick BI Pro can perform the row-level permission setting. The function in personal workspace is invalid.

Procedure

  1. Log on to the Quick BI console.
  2. Select a workspace, as shown in the following figure.

    To create a new workspace, see Create a workspace.

  3. Click Datasets icon to enter the dataset management page.
  4. Select a dataset and right-click or click the Ellipsis icon.
  5. Select Row-Level Permissions.
  6. Select Enable Row-level Permission Control.
  7. Select fields, which are required to set row-level permission, as shown in the following figure.

    Measure value is all the measurement fields in the dataset.  By controlling the measurement fields, different users can see different measurement results.

  8. n Permissions list, click province. The province items are listed automatically, as shown in the following figure.

  9. Select a member and set row-level permissions from the province item list, as shown in the following figure.

    This member can only see the data in Beijing and Guangdong, and the data from other provinces are not visible to this member.
    Note
    Even only one field of a dataset requires row-level permission control, you must set the list of field members who have the permission to access the controlled field on the controlled field of the dataset for all users in the organizational unit. If the list of field members is not set, the member is not allowed to access any data reports that generated by the dataset by default.
  10. Click OK to complete the row-level permission setting.

Background information

Select shipping_type and province to perform the row-level permission settings.

Procedure

  1. Enable the row-level permission function.
  2. Select shipping_type and province from the drop-down list, as shown in the following figure.

  3. Select a member, for example, user1.

    Set row-level permissions from shipping_type items and province items.

  4. Select a member, for example, user2.

    Set row-level permissions from shipping_type items and province items.

  5. Click OK to complete the row-level permission setting.

Different users can view different data in a same dashboard due to the row-level permission setting is performed.

If an organizational unit member has not been assigned with a dimension member that can be viewed, the report cannot be executed, and a message indicating that the member has no permission on a controlled field is displayed.