![]() ![]() In the Select Users or Groups dialog box, enter the users or groups from your organization you want to include in the role. Optional: Click the Members tab, and then click Add. With this formula, you are specifying that only rows with the Country Region Code value of "US" are visible to the user. In the Select Users or Groups dialog box, enter the Windows users or groups from your organization you want to include in the role.Ĭlick the Row Filters tab, and then for the DimGeography table only, in the DAX Filter column, type the following formula: =DimGeography = "US"Ī Row Filter formula must resolve to a Boolean (TRUE/FALSE) value. In the Permissions column, click the dropdown list, and then select the Read permission. In Tabular Model Explorer, right-click Roles > Roles.Ĭlick the new role, and then in the Name column, rename the role to Sales Manager. Create roles To create a Sales Manager user role Before performing the tasks in this lesson, you should have completed the previous lesson: Lesson 10: Create partitions. This article is part of a tabular modeling tutorial, which should be completed in order. You test the effect of each role later in Lesson 12: Analyze in Excel.Įstimated time to complete this lesson: 15 minutes Prerequisites However, for this tutorial, you can also leave the members blank. Choose 'Installation' from the list on the left side to go to the next screen. This step will also look the same here whether installing SQL Server with or adding Analysis Services and / or Integration Services. For this role, you use a DAX formula to define a Row Filter, which restricts members to browse data only for the United States.Īdministrator - This role can include users for which you want to have Administrator permission, which allows unlimited access and permissions to perform administrative tasks on the model database.īecause Windows user and group accounts in your organization are unique, you can add accounts from your particular organization to members. Double click on setup.exe on your installation media and the first screen will open. Sales Analyst US - This role can include users in your organization for which you want only to be able to browse data related to sales in the United States. Sales Manager - This role can include users in your organization for which you want to have Read permission to all model objects and data. However, for other users in your organization to browse by using a reporting client, you must create at least one role with Read permissions and add those users as members. By default, the account you are currently logged in with has Administrator privileges on the model. Creating roles is not necessary to complete this tutorial.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |