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:

  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=" ...

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.

Start your free trial