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

TABLE 15.5

Additional Properties That Define an Action

Name Description

Defines the name of the application that the client application uses to
invoke the action (for example, Internet Explorer).

Application

Defines the string to be displayed by the client application during the
enumeration of actions. The content of this property can be either an
MDX expression that evaluates to a string (in this case, the
CaptionIsMDX property should be set to TRUE ) or a string. Use the
Translations property of the Action object to provide a translation of
the Caption to another language.

Caption

CaptionIsMDX

Set this property to TRUE if the content of the Caption property is an
MDX expression.

Used by a client application to help determine when an action should be
invoked. Actions are usually invoked when a user performs some interac-
tion with a client application. Specify INTERACTIVE as the value of the
Invocation property.

Invocation

for generating DRILLTHROUGH statements and a URL in a format that Reporting Services
understands. When you define a Drillthrough action, you must specify the additional
properties described in the “Drillthrough” section later in this chapter. Properties of
Report action objects are described in Table 15.6.

Now you'll create a sample Action object that displays a map with the location of a store
pinned on it using the MSN Map service available on the Internet. The FoodMart 2008

TABLE 15.6 Properties of Report Action Objects

Name Description

A virtual directory in Internet Information Services (IIS) where
Reporting Services is referenced.

Path

A list of additional parameters required by the report to
customize the formatting of the report. The difference
between ReportParameters and ReportFormatParameters
is minimal: The Value property of ReportFormatParameters
is a scalar string, not an MDX expression. For more informa-
tion about report parameters, see Books Online articles for
SQL Server Reporting Services.

ReportFormatParameters