Extending the cube with custom actions
A common requirement when building BI solutions is that you should be able to invoke an external command from within the analysis program. This is something that you can do by using actions. You define the action as part of your cube; as an example, you can invoke a web page or report from your action.
The most common action is a drillthrough action that allows the users to go from an aggregated level in the cube directly down to the lowest level of the cube. To create an action in your cube, perform the following steps:
Double-click on the Adventure Works DW2012.cube cube in the Solution Explorer.
Click on the Actions tab in the designer and then click on the New Drillthrough Action button.
Name the action as
My Custom Drillthrough Action.Set the value of Action Target as
Fact Internet Sales.Then add the following drillthrough columns:
Dimension
Return Columns
Measures
Sales Amount
Order Date
Date
Product
Product, Product Subcategory, Product Category...
