Database Reference
In-Depth Information
Defining URL actions
URL actions invoke a link with a parameter set to the current dimension member. This
functionality is helpful in obtaining additional information about a particular attribute.
For example, a URL action in a movie database could look up a particular actor's bio-
graphy; a URL action in a real estate application could allow navigating to the prop-
erty's listing, and so on.
How to do it...
To set up a URL action that gets state information from
maps.google.com
:
1. Right-click on
Action Organizer
and choose
New Action
. Set the
action
type
to
URL
, and name the action
State Information
.
2. Set
target type
to
Level Members
and
target object
to
Geography.Geography.State-Province
.
3. Set the action expression to the following:
"http://maps.google.com/maps/
place?ftid=0x54936e7c9b9f6a55:0x7d4c65db7a0bb876&q="
+
[Geography].[State-Province].CurrentMember.Name
+
"&hl=en&ved=0CBIQ3g0&sa=X&ei=Li5WUZCeLofFtwflo4H4BA"
4. Set the invocation property to interactive, the caption to
State Informa-
tion Link
. The
Caption is MDX
property should be set to
False
.
5. Save the action by clicking on the SSDT
Save
button.
6. To test the action, create a pivot table in Excel with the
Geography
hierarchy
on rows,
Reseller Sales Amount
measure on columns, and the
Geo-
graphy
dimension's country attribute filtered to
United States
.
7. Expand the
Geography
hierarchy so that it shows states, then right-click on
Wyoming
, and navigate to
Additional Actions | State Information Link.
8. Your browser will open the link showing information about Wyoming.
Now let's modify the action slightly to use MDX for deriving the caption:
Search WWH ::
Custom Search