This is one of those things that you can easily get wrong from time to time, (I have ), so thought I would share it on my blog and hopefully it will save some of you from facing the same issue.
When you have Reporting Services running in SharePoint integrated mode and you want to enable an action on a Analysis Services cube to a report on this reporting services server, you need to ensure you configure the Report Server properties correctly for it to work.
Essentially the format for this dialog box in BIDS for the Cube Action settings are:
Server name: <name of reporting services server>/reportserver (default directory)
Report Path: <name of reporting services server>/reportserver?http://<sharepoint server name>/reports/<reportname>.rdl
Below is an example and screen shot:
Report Server : http://mgsir37-02/ReportServer_WI
Report Path : http://mgsir37-02:2/Reports/Company Dashboard.rdl
Cube Action settings