Key Performance Indicators, Actions, and the DRILLTHROUGH Statement - Microsoft SQL Server 2008 Analysis Services - page 274

LISTING 15.8

Expression for the Store Locations Action

”http://maps.msn.com/home.aspx?plce1=” +
// The name of the current city
[Store].[Store City].CurrentMember.Name + “,” +
// Append state-province name
[Store].[Store State].CurrentMember.Name + “,” +
// Append country name
[Store].[Store Country].CurrentMember.Name

Set the following properties: Invocation as Interactive , Application as Internet
Explorer , Description as “This action displays a map with the location of a store pinned
on it,” Caption Is MDX as True, and Caption as the following MDX expression:

”View Map for “ + [Store].[Store City].CurrentMember.Member_Caption

Figure 15.5 shows the Actions tab with the information already entered.

After you save your work in BI Dev Studio and deploy the project, the DDL is sent to the
server, where it alters the cube and saves the created Action object. Listing 15.9 shows a
portion of the DDL that creates the Action object.

LISTING 15.9

DDL That Creates an Action Object

<Actions>
<Action xsi:type=”StandardAction”>
<ID>Action</ID>
<Name>Store Locations</Name>
<Description>This action displays a map with the location of a store
pinned on it</Description>
<Application>”Internet Explorer”</Application>
<Caption>”View Map for “ +
[Store].[Store City].CurrentMember.Member_Caption</Caption>
<CaptionIsMdx>true</CaptionIsMdx>
<Condition>NOT([Store].[Store Country].Currentmember IS
[Store].[Store Country].[Mexico])</Condition>
<Expression>”http://maps.msn.com/home.aspx?plce1=” +
// The name of the current city
[Store].[Store City].CurrentMember.Name + “,” +
// Append state-province name
[Store].[Store State].CurrentMember.Name + “,” +
// Append country name
[Store].[Store Country].CurrentMember.Name</Expression>
<Target>[Store].[Store City]</Target>
<TargetType>AttributeMembers</TargetType>