In Microsoft Analysis Services there is a possibility to set the rights on dimension members for the roles of Analysis Services. Do not forget that each BAT user has a corresponding role [batidentifier] _user_login in the cube. In Analysis Services 2008 and above the rights are set on the attributes of the dimension. The paragraph […]

On the tab “User Parameters” you will see the empty list. Let’s add the parameter “Country”: In the field SQL you should set the query which returns two fields: a key and a name. This query should return all possible parameter values. In most cases you will build a query which returns a key and […]

Let us create a new role on the tab “Roles” with the name “Country Managers”: In the lower part of the form in the field Applicable let’s check the box “Applicable” and press the button “Save”. We created a new role and “explained” it that the parameter “Country” is applicable to it. Now let’s go […]

Let us show how it is possible to quickly set the access rights on dimension members with the help of a special wizard and user parameters. Go to the “Cubes” tab. Select the item “Edit Permissions on Dimensions” in the context menu for the cube “Adventure Works”: The wizard will be opened. This wizard asks […]

We showed how to quickly set the access rights on cubes and dimensions for the report module users with the help of roles, parameters and their values. Take into account that: There can be many users (not two as shown in the previous example); All information about the parameter values is stored in the repository […]

You are already familiar with the ability to grant access rights on cubes for report users and BAT-roles. You also know that granting the rights is achieved by creating the roles on cubes with appropriate set of access rights. If you remove those roles from cubes then all the security settings for report users and […]

To backup all roles created by BAT on some cube, switch to the “Roles Backup” tab. Press the “Backup Roles” button on the toolbar: In the appeared wizard fill in the server address and its version and press “Test Connection” button: If you fill in everything correctly, you’ll get a message box: Close this message […]

To restore the roles from a backup to the database you need to go through next steps. Select the appropriate roles backup and press the “Restore Roles” button on the toolbar (you can do it also using the corresponding item of main or context menu): In the appeared wizard you should input the address of […]

Statistics Review Administrators

On the “MDX Statistics” tab you can view the MDX queries run by the users and the amount of time they were executed: This functionality is useful when it is necessary to find out who of the users is too demanding to the server and tries, for example, to execute a query with a crossjoin […]