Lesson 8: Defining Actions
Applies To: SQL Server 2016
In this lesson, you will learn to define actions in your Analysis Services project. An action is just a Multidimensional Expressions (MDX) statement that is stored in Analysis Services and which can be incorporated into client applications and started by a user.
Analysis Services supports the types of actions that are described in the following table.
|CommandLine||Executes a command at the command prompt|
|Dataset||Returns a dataset to a client application.|
|Drillthrough||Returns a drillthrough statement as an expression, which the client executes to return a rowset|
|Html||Executes an HTML script in an Internet browser|
|Proprietary||Performs an operation by using an interface other than those listed in this table.|
|Report||Submits a parameterized URL-based request to a report server and returns a report to a client application.|
|Rowset||Returns a rowset to a client application.|
|Statement||Runs an OLE DB command.|
|URL||Displays a dynamic Web page in an Internet browser.|
Actions let users start an application or perform other steps within the context of a selected item. For more information, see Actions (Analysis Services - Multidimensional Data), Actions in Multidimensional Models
This lesson includes the following task:
Defining and Using a Drillthrough Action
In this task, you define, use, and then modify a drillthrough action through the fact dimension relationship that you defined earlier in this tutorial.