{"id":2543,"date":"2024-01-08T13:52:55","date_gmt":"2024-01-08T11:52:55","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=2543"},"modified":"2025-01-13T15:35:38","modified_gmt":"2025-01-13T13:35:38","slug":"rozdacha-prav-dostupu-do-chleniv-vymiru-velykij-kilkosti-korystuvachiv","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/rozdacha-prav-dostupu-do-chleniv-vymiru-velykij-kilkosti-korystuvachiv\/","title":{"rendered":"Setting the Rights on Dimensions to Many Users"},"content":{"rendered":"<p>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.<\/p>\n<p>In Analysis Services 2008 and above the rights are set on the attributes of the dimension.<\/p>\n<p>The paragraph \u00a0<a title=\"Cube Access Rights\" href=\"https:\/\/bitimpulse.com\/en\/manual\/stvorennya-korystuvachiv-zvitiv\/prava-dostupu-do-kubiv\/\" target=\"_blank\" rel=\"noopener\">Cube Access Rights <\/a>\u00a0 ran about how to set unlimited rights to the users on a set of cubes with the help of a wizard, and also showed how the user can set the rights to a cube with the help of this dialog:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_1-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9051\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_1-1.png\" alt=\"\" width=\"1042\" height=\"788\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_1-1.png 1042w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_1-1-450x340.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_1-1-300x227.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_1-1-768x581.png 768w\" sizes=\"auto, (max-width: 1042px) 100vw, 1042px\" \/><\/a><\/p>\n<p>For every attribute of dimension we can select both a set of allowed and a set of denied members:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2546\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_2.png\" alt=\"\" width=\"490\" height=\"652\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_2.png 490w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_2-338x450.png 338w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_2-225x300.png 225w\" sizes=\"auto, (max-width: 490px) 100vw, 490px\" \/><\/a><\/p>\n<p>As a result, John will see data only for Australia and Canada.<\/p>\n<p>The same action can be done for a role:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2547\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_3.png\" alt=\"\" width=\"1048\" height=\"768\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_3.png 1048w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_3-450x330.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_3-300x220.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_3-768x563.png 768w\" sizes=\"auto, (max-width: 1048px) 100vw, 1048px\" \/><\/a><\/p>\n<p>All users who belong to this role will have access rights to both countries.<\/p>\n<p>If there are many users and you need to quickly set rights on dimensions, you will have to use other wizards for this purpose. Let\u2019s show it on example.<\/p>\n<p>Let&#8217;s consider the cube \u201cAdventure Works\u201d in the database \u201cAdventure Works DW\u201d. This cube uses the dimension \u201cGeography\u201d with an attribute \u201cCountry\u201d.<\/p>\n<p>Suppose we have managers, and we want to quickly set access rights for seeing sails in different countries to them. For this purpose it is necessary to do some actions.<\/p>","protected":false},"featured_media":0,"parent":0,"menu_order":51,"template":"","manuals":[16],"class_list":["post-2543","manual","type-manual","status-publish","hentry","manuals-bat-admin"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/2543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual"}],"about":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/types\/manual"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=2543"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=2543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}