There are 3 types of actions that you can configure:
– General action
– Drillthrough action
– Reporting action
Good examples of the above are provided in the Adventure Works DW 2008 sample cube.
An example of a general action is City Map. When you browse a list of cities in the cube and you want to know the city map, you right click on to the cell member then select "View map for … ". It will then pop up a URL link that you specified to view the map on the Internet.
Action expression:
// Retreive the name of the current city
[Geography].[City].CurrentMember.Name + "," +
// Append state-province name
[Geography].[State-Province].CurrentMember.Name + "," +
// Append country name
[Geography].[Country].CurrentMember.Name +
// Append region paramter
"®n1=" +
// Determine correct region paramter value
Case
When [Geography].[Country].CurrentMember Is
[Geography].[Country].&[Australia]
Then "3"
When [Geography].[Country].CurrentMember Is
[Geography].[Country].&[Canada]
Or
[Geography].[Country].CurrentMember Is
[Geography].[Country].&[United States]
Then "0"
Else "1"
End
// The "plce1" parameter represents a named location.
// The "regn1" parameter indicates the region in which
// the named location is located.
// 0 = North America
// 1 = Europe
// 2 = World Atlas
// 3 = Australia
// 4 = Brazil
Drillthrough action is straightforward. You specify which measure group member and columns you want users to drillthrough.
Reporting action is an action which takes you to view the Reporting Services report. This action requires both Reporting Services and the Reporting Services sample reports be installed on the local machine or server.
Server name: localhost
Report path: ReportServer?/AdventureWorks 2008R2/Reseller Sales
Report format: HTML5
Parameters (optional):
Parameter Name: ResellerReseller. The parameter name must match the parameter name in the Reporting Services report.
Parameter Value: UrlEscapeFragment([Reseller].[Reseller].CurrentMember.UniqueName). It won’t work if you don’t use the UrlEscapeFragment function.
Caption is MDX: true
Caption: "Store Contacts for " + [Reseller].[Reseller].CurrentMember.Member_Caption + "…"