Using Actions

An action is an activity that an end user can perform by right-clicking either cube metadata (a row or column label) or cube data (a measure value). Actions are added to SSAS cubes and targeted at a particular section, that is, an entire dimension, a particular hierarchy, a particular measure group, and so on. The ability to use cube actions is completely dependent on the type of client application your BI solution uses. For example, Excel 2007/2010 supports several actions, including URL, reporting, and drillthrough actions.

Creating Actions in SSAS

Actions are created in BIDS using the cube designer work area (Actions tab) by completing the property values and writing MDX scripts. As with many other advanced cube-design techniques, ...

Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition 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.