Advanced Cube Design - Professional SQL Server Analysis Services 2005 with MDX - page 428

Method Description

On Open The action runs when a user opens the cube.

7. In the Caption text box, type the following MDX expression:

[Geography].[City].CurrentMember.Member_Caption +
" City Map ..."

The specified caption is displayed to end users to indicate an action
is available. The user clicks the caption to initiate the action. The
"Caption Is MDX" property controls how the server evaluates the
contents of the caption. If you leave this property value as false, the
server treats the caption as a static string.

8. Change the Caption Is MDX value to True. The server evaluates the
MDX expression in the Caption text box to construct the caption,
which in this case will result in different city names included in the
caption as different cities are selected in the browser.

Now that you've created a My City Map action, deploy the project to save the
action to the server. Just as with KPI definition, an action definition is
metadata stored on the server with the cube. Adding or changing the action
won't impact the cube data and doesn't require a reprocess. When the project
deploys, you can verify the newly created action right away.

Browse URL Action in the Cube Browser

Many standard OLAP client applications such as pivot tables in Office Web
Components and the BIDS Cube Browser support actions out of the box. In
this section, you learn to invoke the action My City Map from Cube Browser.
1. In the cube designer, click the Browser tab to open the cube browser
for the Adventure Works cube.

2. In the metadata pane on the left, open the Geography dimension.
Then, open the Geography hierarchy and drag the City level from
metadata window to Rows in the data window on the right side, as
shown in Figure 9-37 .