Entering permissions in access cubes

Select Dashboards > OLAP > Manage Permissions. Select the data source and the access cube.

In each cell of the grid an icon indicates the permission that is currently assigned. You assign permissions by clicking cells in the grid.

You can select a permission to apply to each cell that you click. This is useful in applying the same permission to multiple cells. Or, to apply several different permissions you can enable a context menu, which is displayed each time you click a cell. The context menu lists the available permissions.

Click GRID CLICK MODE in the toolbar. Select the permission to apply or enable the context menu. An icon in the toolbar indicates the currently selected option.

To update the dashboard with recently created roles, click Update Roles.

By default, roles form the columns of the grid. The elements of the access cube form the rows. There is a Roles button and a button for the access cube. You can drag the buttons to exchange the column and row elements. The button that is in the column position has options to show all elements or to select elements. In the Select Elements dialog box, use Ctrl and Shift to select multiple elements or enable the multi-selection mode in the toolbar.

The button that is in the row position has options to select elements and to sort elements. There are also toggle options which show or hide rows in which every cell in a row has the same permission. For example, if all cells in a row have No Access, use the Show No Access option to show or hide the row.

Click a column heading to sort cells in ascending or descending order. Or, select Keep role to display only the selected column.