Hi I have a report it needs to be executed with different username .Parameter is set up in such a way that based on user who logs in the values should change .How can i execute a report in BIDs with different user credentails.Data source is Cube Thanks

If you go to your data source properties, there is a "Credentials" section. There you can specify a particular username and password to use for connecting to the cubeCraig Bryden - Please mark correct answers

Hi Danns, You can implement it in either reporting services or analysis services. On the reporting services, create a table to store a userid and username, utilize the reporting services built-in function: =User!UserID to obtain the current user ID, then pass the userID to the table to get the username, the username can be passed as parameter into the cube MDX query. on the analysis services, refer to http://social.technet.microsoft.com/Forums/en-US/sqlanalysisservices/thread/5156c23b-f984-4453-af8f-605ff3f17fe1 using dynamic security to achieve this. thanks, Jerry