# Configuring Roles for Data Restrictions

Use this option to configure restrictions to users or groups in accessing or viewing the data through reports and dashboards.

# Limitations

Note the following limitations when configuring object-level restrictions in the OLAP database:

  • The restrictions configured will not be applied to SQL Server Analysis Services server administrators.

  • The restrictions configured will NOT be applied to Analysis Server service account.

  • All the restricted users should not be included in roles with Full Permission.

  • The Open iT Reporting Services data sources should use either:

    • Windows Integrated Security

    • Credentials supplied by the user running the report.

     Analysis Server Administration: Configuring Role SSRS Credentials

    Analysis Server Administration: Configuring Role SSRS Credentials

  • The restricted role must have at least Read permission to the OLAP Applications cube.

  • Avoid including users to multiple roles to avoid conflicts in restrictions. If a user belongs to multiple roles, all the allowed properties in each role will be visible to the user.

# Configuring Data Restrictions

To set object-level roles in OLAP cube:

 Analysis Server Administration: Configuring Role Data Restrictions

Analysis Server Administration: Configuring Role Data Restrictions

  1. Choose the role to configure.

  2. Click the Configure button.

    A Configure Role dialog will appear.

  3. Choose among the available Dimensions.

  4. Choose among the available Attribute Hierarchy under the selected dimension.

  5. Choose from the following options for selecting data:

    • Select All - to allow role members to access the dimension and attribute data.

    • Deselect All - to deny role members to access the dimension and attribute data.

  6. Click Update to apply changes.

    A confirmation message will appear.

  7. Click OK.

# Verifying Data Restrictions in Reporting

After configuration, the restrictions will immediately take effect to ad hoc reporting using the following tools:

  • SQL Server Reporting Services

  • Microsoft Excel

# Verifying Data Restrictions in Real-time Dashboard

Activate the role-based data display on the License Monitor Portal to apply the configuration in the real-time dashboard.

We value your feedback!

Please take a few minutes to complete our survey and share your thoughts on your recent experience with our documentation.

Take survey

Close