tag:blogger.com,1999:blog-3060356085800419741.post5692230027353446319..comments2024-03-19T05:29:18.669-07:00Comments on SQL Server: Dynamic Security in SSAS in DetailBharath R Shttp://www.blogger.com/profile/06708546714328201388noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-3060356085800419741.post-72002354618162565602021-03-19T05:20:45.998-07:002021-03-19T05:20:45.998-07:00Nice article regarding the security products for m...Nice article regarding the <a href="https://www.malcotechnology.com/" rel="nofollow">security products</a> for more visit the given resource which provides the information of it infrastructure.<br /><a href="https://www.malcotechnology.com/products-solutions/infrastructure-solution/" rel="nofollow">it infrastructure services in dubai</a><br /><a href="https://www.malcotechnology.com/products-solutions/smart-infrastructure/" rel="nofollow">smart infrastructure</a><br /><a href="https://www.malcotechnology.com/products-solutions/security-solutions/" rel="nofollow">cctv camera</a><br /><a href="https://www.malcotechnology.com/products-solutions/data-center-solutions/" rel="nofollow">data center solutions</a><br /><a href="https://www.malcotechnology.com/products-solutions/cabling-solutions/" rel="nofollow">networking cabling company</a><br /><a href="https://www.malcotechnology.com/products-solutions/server-racks/" rel="nofollow">server rack suppliers</a><br /><a href="https://www.malcotechnology.com/products-solutions/energy-power/" rel="nofollow">power backup solution</a><br /><a href="https://www.malcotechnology.com/products-solutions/audio-video/" rel="nofollow">AV Solution</a>Trendy Lifestyle350https://www.blogger.com/profile/02262305632633701611noreply@blogger.comtag:blogger.com,1999:blog-3060356085800419741.post-16949025854784504862020-11-25T10:46:51.474-08:002020-11-25T10:46:51.474-08:00in the current example how would you recomment to ...in the current example how would you recomment to enforce the access at MST_DATE dimension? my experiments show, that if i dont select product and only select data the mdx will show me all product sales for that dateAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3060356085800419741.post-45832345736705764982020-11-25T10:43:11.714-08:002020-11-25T10:43:11.714-08:00This comment has been removed by the author.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3060356085800419741.post-77753168918627448642020-11-25T06:39:30.445-08:002020-11-25T06:39:30.445-08:00This will work, you need to apply the logic to all...This will work, you need to apply the logic to all the dimensions where you want the filtering mechanism. It will be lot of effort but that is how it was designed.Bharath R Shttps://www.blogger.com/profile/06708546714328201388noreply@blogger.comtag:blogger.com,1999:blog-3060356085800419741.post-9219993042970988452020-11-25T06:33:37.711-08:002020-11-25T06:33:37.711-08:00This comment has been removed by the author.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3060356085800419741.post-31688499604962815852020-10-21T06:50:33.270-07:002020-10-21T06:50:33.270-07:00Quote: "An error occurred in the MDX script f...Quote: "An error occurred in the MDX script for the dimension attribute permission's allowed member set: The dimension '[User]' was not found in the cube when the string, [User].[UserName].[UserName].&[], was parsed."<br /><br />Because i had so many dimensions i didn't see the cube dimensions, at first. So i implemented the security at databasedimension level and not at cube dimensionlevel. The combobox "dimension" stores both database dimensions and cube dimensions. This is very confusing. "<br /><br />Source: http://bifuture.blogspot.com/2011/09/ssas-setup-dynamic-security-in-analysis.htmlJuan Carlos Leguizamónhttps://www.blogger.com/profile/11761620938065251686noreply@blogger.comtag:blogger.com,1999:blog-3060356085800419741.post-57530539523400255102020-05-19T07:59:53.311-07:002020-05-19T07:59:53.311-07:00If your domain controller has both the domains lin...If your domain controller has both the domains linked inside it then it should not be a problem. It can check the domains inside it and allow access to the cubes. Bharath R Shttps://www.blogger.com/profile/06708546714328201388noreply@blogger.comtag:blogger.com,1999:blog-3060356085800419741.post-79783053329731973632020-05-19T07:58:26.764-07:002020-05-19T07:58:26.764-07:00Hi,
sorry for the delayed response. The mdx should...Hi,<br />sorry for the delayed response. The mdx should work if it worked on the management studio. There is nothing different you have to do except remove the from clause in the MDx and whatever is on axis 1 needs to be placed in the advanced tab as shown in the blog.Bharath R Shttps://www.blogger.com/profile/06708546714328201388noreply@blogger.comtag:blogger.com,1999:blog-3060356085800419741.post-90273502781733015752020-05-13T12:20:34.979-07:002020-05-13T12:20:34.979-07:00I have implemented the design above and can succes...I have implemented the design above and can successfully run the MDX, but it gets and error when added to the Advanced tab for the Dimension security.<br /><br />NonEmpty (<br />[SALES ORG DIM].[Sales Rep Number].Members,<br />(<br />StrToMember ("[User Dim].[User Account].[" + UserName () + "]"),<br />[Measures].[BRIDGE SALES ORG Count]<br />)<br />)<br /><br />An error occurred in the MDX script for dimension attributes permission's allowed member set. Query (5,1) The '[BRIDGE SALES ORG Count]' was not found in the cube when the string, '[Measures].[BRIDGE SALES ORG Count]' was parsed.JeanneKhttps://www.blogger.com/profile/05312626924500206947noreply@blogger.comtag:blogger.com,1999:blog-3060356085800419741.post-24919136308173435742020-02-17T07:49:21.588-08:002020-02-17T07:49:21.588-08:00Great blog!
What if we have 2 domains? that means ...Great blog!<br />What if we have 2 domains? that means we need 2 attributes for each domain? or is there a function that can take just the UserName regardless of the domain? <br />the current solution always expect: domainName\UserName<br />thanks! Anonymoushttps://www.blogger.com/profile/18417126746507914862noreply@blogger.comtag:blogger.com,1999:blog-3060356085800419741.post-7825039552552333812018-01-09T03:03:54.351-08:002018-01-09T03:03:54.351-08:00Hi Abid, Sorry for the late reply, I do not have t...Hi Abid, Sorry for the late reply, I do not have the project code with me. let me know how which part is failing.Bharath R Shttps://www.blogger.com/profile/06708546714328201388noreply@blogger.comtag:blogger.com,1999:blog-3060356085800419741.post-49486018118583410822017-10-24T03:32:44.707-07:002017-10-24T03:32:44.707-07:00Dear Bharath R S,
thanks for reply, i am still fai...Dear Bharath R S,<br />thanks for reply, i am still fail to implement dynamic security.<br />can you share your project code?<br /><br />Regards,<br />mianabid1978@gmail.com<br />Abid AliAbid Alihttps://www.blogger.com/profile/07620845005141069422noreply@blogger.comtag:blogger.com,1999:blog-3060356085800419741.post-67137322843310012652017-10-24T03:31:56.106-07:002017-10-24T03:31:56.106-07:00This comment has been removed by the author.Abid Alihttps://www.blogger.com/profile/07620845005141069422noreply@blogger.comtag:blogger.com,1999:blog-3060356085800419741.post-23740008644242859962017-09-15T08:41:35.688-07:002017-09-15T08:41:35.688-07:00Hi Abid, As you see the MDX is the only code you n...Hi Abid, As you see the MDX is the only code you need to write, rest is design and configurationAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3060356085800419741.post-64191130440234384982017-09-15T03:44:23.486-07:002017-09-15T03:44:23.486-07:00Good code can you share code/ script?Good code can you share code/ script?Abid Alihttps://www.blogger.com/profile/07620845005141069422noreply@blogger.com