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

<ACTION_TYPE>1</ACTION_TYPE>
<COORDINATE>
[Store].[Stores].[Store City].[Victoria]
</COORDINATE>
<COORDINATE_TYPE>4</COORDINATE_TYPE>
<ACTION_CAPTION>View Map for Victoria</ACTION_CAPTION>
<DESCRIPTION>This action displays a map with the location
of a store pinned on it</DESCRIPTION>
<CONTENT>
http://maps.msn.com/home.aspx?plce1=Victoria,BC,Canada
</CONTENT>
<APPLICATION>”Internet Explorer”</APPLICATION>
<INVOCATION>1</INVOCATION>
</row>
</root>
</return>
</DiscoverResponse>
</soap:Body>
</soap:Envelope>
Now the client application can use the string returned to it in the CONTENT column of the
rowset
http://maps.msn.com/home.aspx?plce1=Augusta,Georgia,United States&amp;regn1=0
and pass it to Internet Explorer or another Internet browser.
If you don't want to mess with writing XML to test the actions that you create, you can
use the cube browser in BI Dev Studio, as follows:
1. Open the FoodMart 2008 project.
2. In the Solution Explorer, double-click the Warehouse and Sales cube.
3. In the cube editor, select the Browse tab and drag the Store City hierarchy onto the
browsing control.
4. Click a city (for example, Seattle), and then right-click.
5. On the resulting menu, choose View Map for Seattle (see Figure 15.6), and you can
now browse the action's results in Internet Explorer.
Drillthrough
When they browse analytical data stored in Analysis Services, users usually work with
aggregated values. They usually start to analyze the data from the top, and drill down