Drill To Detail Actions
A very powerful feature of Analysis Services is the "drill through actions". This allows users to perform a "double click" on an Excel cell and then be presented with a new worksheet which shows the fact table detail that sources the cube.
Customizing the drill to detail
The drill to detail functionality is set up automatically so it is very easy to implement. But a lot of people do not realize that you can customize what fields and attributes are displayed to the users. They are also not aware that you can have multiple actions which would return differing fields.
Reporting Services Actions
Also available are actions which can link a cell or dimension member to a SSRS report. The action can be configured so it sends the "context" of the cube to the report for filtering. This can be very powerful.