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 SSRS are 2008.