{"id":2563,"date":"2024-01-08T16:03:50","date_gmt":"2024-01-08T14:03:50","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=2563"},"modified":"2025-01-13T15:37:58","modified_gmt":"2025-01-13T13:37:58","slug":"rozdacha-prav-dostupu-na-vymiry","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/rozdacha-prav-dostupu-do-chleniv-vymiru-velykij-kilkosti-korystuvachiv\/rozdacha-prav-dostupu-na-vymiry\/","title":{"rendered":"Setting of the Access Rights on Dimension Members"},"content":{"rendered":"<p>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 \u201cCubes\u201d tab. Select the item \u201cEdit Permissions on Dimensions\u201d in the context menu for the cube \u201cAdventure Works\u201d:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_14.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2564\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_14.png\" alt=\"\" width=\"936\" height=\"623\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_14.png 936w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_14-450x300.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_14-300x200.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_14-768x511.png 768w\" sizes=\"auto, (max-width: 936px) 100vw, 936px\" \/><\/a><\/p>\n<p>The wizard will be opened. This wizard asks you to select the dimension and attribute hierarchy. Select everything as shown in the picture and move to the next step:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_15.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2565\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_15.png\" alt=\"\" width=\"516\" height=\"412\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_15.png 516w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_15-450x359.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_15-300x240.png 300w\" sizes=\"auto, (max-width: 516px) 100vw, 516px\" \/><\/a><\/p>\n<p>On the step 2 select the \u201cCountry Managers\u201d role from the drop-down:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_16.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2566\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_16.png\" alt=\"\" width=\"516\" height=\"412\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_16.png 516w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_16-450x359.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_16-300x240.png 300w\" sizes=\"auto, (max-width: 516px) 100vw, 516px\" \/><\/a><\/p>\n<p>In the list below you will see the users assigned to that role. The access rights will be set for every user selected in the list.<\/p>\n<p>Press \u00abNext\u00bb.<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_17.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2567\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_17.png\" alt=\"\" width=\"516\" height=\"412\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_17.png 516w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_17-450x359.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_17-300x240.png 300w\" sizes=\"auto, (max-width: 516px) 100vw, 516px\" \/><\/a><\/p>\n<p>On the step 3 select the parameter \u201cCountry\u201d from the drop-down and from the drop-down at the bottom select the level \u201cCountry\u201d (the level for which you are setting up the access rights).<\/p>\n<p>Move on to the step 4:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_18.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2568\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_18.png\" alt=\"\" width=\"516\" height=\"412\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_18.png 516w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_18-450x359.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_18-300x240.png 300w\" sizes=\"auto, (max-width: 516px) 100vw, 516px\" \/><\/a><\/p>\n<p>On this step you can review the rights for every user. These rights will be set on the dimension data in the cube \u201cAdventure Works\u201d. If necessary, you can still modify them.<\/p>\n<p>After pressing \u00abNext\u00bb button you will receive the message about the successful operation execution:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_19.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2569\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_19.png\" alt=\"\" width=\"516\" height=\"412\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_19.png 516w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_19-450x359.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_19-300x240.png 300w\" sizes=\"auto, (max-width: 516px) 100vw, 516px\" \/><\/a><\/p>\n<p>You can verify that the access rights for users on dimensions are set up, using Management Studio:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_20.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2570\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_20.png\" alt=\"\" width=\"695\" height=\"629\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_20.png 695w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_20-450x407.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_20-300x272.png 300w\" sizes=\"auto, (max-width: 695px) 100vw, 695px\" \/><\/a><\/p>\n<p>If you open the report in the report module under the user \u201cjohn\u201d, create a separate page, place on the rows the level \u201cCountry\u201d from \u201cGeography\u201d hierarchy, you will see the following:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_21.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2571\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_21.png\" alt=\"\" width=\"982\" height=\"749\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_21.png 982w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_21-450x343.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_21-300x229.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/16_21-768x586.png 768w\" sizes=\"auto, (max-width: 982px) 100vw, 982px\" \/><\/a><\/p>\n<p>The user can see only two countries: Australia and Canada.<\/p>","protected":false},"featured_media":0,"parent":2543,"menu_order":54,"template":"","manuals":[16],"class_list":["post-2563","manual","type-manual","status-publish","hentry","manuals-bat-admin"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/2563","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"}],"up":[{"embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/2543"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=2563"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=2563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}