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 biography; a URL action in a real estate application could allow navigating to the property's listing, and so on.
How to do it...
To set up a URL action that gets state information from maps.google.com:
- Right-click on Action Organizer and choose New Action. Set the action type to URL, and name the action
State Information
. - Set target type to
Level Members
and target object toGeography.Geography.State-Province
. - Set the action expression to the following:
"http://maps.google.com/maps/place?ftid=0x54936e7c9b9f6a55:0x7d4c65db7a0bb876&q=" ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.