I have an SSAS cube with limited users. I don't want to grant any sort of access to the cube outside of those users.
I have some SSRS reports that use the above SSAS cube as a data source. I want to give access to the reports to some users who don't have access to the cube.
What credentials should I use for the cube data source? Since SSAS only supports Windows Authentication, do I have to create a dummy Windows ID?
Edit: Both SSAS and S开发者_如何学编程SRS are 2008.
Usually I use a windows account that is reserved solely as a SSRS service account to control connecting SSRS to SSAS. Then I control access to the cube through permissions in SSRS. I once saw someone use a local machine account since the server doubled as the SSRS and SSAS server, but I personally prefer to secure solely through domain accounts.
 
                                         
                                         
                                         
                                        ![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif) 
                                         
                                         
                                         
                                         加载中,请稍侯......
 加载中,请稍侯......
      
精彩评论