Vision Binary

Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want to pass in some parameters to the report so it shows the relevant data. If the parameter name matches the item in excel then this is a breeze. The problem comes when you need to pass something different to the report. If the report has a date range on it you need to pass the report a start date and end date. If a user clicks on a reporting action in excel at the year, quarter, or month level, you will need to get the start date and end date dynamically. Let’s see how to do that.

Here you can see three reporting actions in a cube in SSAS. Each one handles a different date level. The user will see only one action when clicking in excel.

To ensure the user only sees the proper action at the proper date level you need a conditional statement in the optional condition box. So for the month level the code is:

[Due Date].[Date].CurrentMember.Level is [Due Date].[Date].[Month Name]

want to read more?

http://www.sqlservercentral.com/blogs/mikedavissql/2014/01/20/ssas-reporting-action-with-date-parameters/