O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required