Actions are a new feature of Analysis Services that can link more detailed information to an OLAP cube. Here are the names and descriptions of the action types.

Command line: Executes a command line. With it, you could start virtually any program with command-line parameters to initialize the program with the relevant information. For example, a command-line action on a product name could bring up an inventory program that displays current inventory and order status information.

Statement: Executes an OLE DB command that either succeeds or fails, but doesn't return a result. Examples are data-definition commands such as CREATE MEMBER or DROP MEMBER.

HTML: Contains HTML to open in an Internet browser. The client application stores the HTML in a temporary file and launches the user's default browser to display it.

URL: Similar to the HTML action, except that it contains a URL instead of HTML. The URL action is useful for linking cube meta data to intranet or Internet sites.

Dataset: Contains an MDX query that returns a data set. The data set can be on a different cube in the same database as the action. This action type is useful for linking users to different but related cubes.

Rowset: Contains an OLE DB command like the statement and dataset types, but this command returns a rowset. The rowset action might contain a drillthrough command or a standard SQL query.

Proprietary: Can contain anything you want it to. You use it for a custom action that the analysis application can recognize for special behavior that doesn't fit into one of the other categories.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.