Database reference - Adventure Works DW

Action - City Map

Action properties

namevalue
nameCity Map 
descriptionThis action will display the map for a given city. 
idAction 
caption"View Map for " + [Geography].[City].CurrentMember.Member_Caption + "..." 
caption is mdxtrue 
target typeAttributeMembers 
target[Geography].[City] 
typeUrl 
maximum rows 

Expression

// URL for linking to MSN Maps
"http://maps.msn.com/home.aspx?plce1=" +

// 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 
"&regn1=" +

// 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



Documentation generated by SqlSpec