Customizing Double-Click Drilldown

Customizing Double-Click Drilldown

By default, when you double-click a row in a pivot table, the system drills down to the next lowest level in the hierarchy, if any (see Drilldown via Double-Click). You can customize this behavior. To do so:

1. Click the Advanced Options button in the header of the Rows box.

2. Expand the Drilldown Options group if that is collapsed.

3. For Drilldown Expression, specify one or more MDX set expressions, one per line. For example:

   colord.h1.[favorite color].members
   gend.h1.gender.members
   

   

   To specify MDX set expressions, you can do either of the following:

   • Type the expression directly into Drilldown Expression. Use a line return to establish required line breaks between items.

   • Use the Expression Builder. To access this tool, click the plus sign next to Drilldown Expression. The left area lists the contents of the cube, including all measures and levels. The right area displays the expression that you are creating. To add an item to the expression, drag and drop it from the left area to the expression. The item is added to the end of the expression, and you might need to move it to a different part of the expression.

     Click the plus sign each time you add an item to the expression. Using the plus sign (rather than a line return) causes the Expression Builder to establish and preserve the required line breaks between items.

   Typically you use set expressions of the form [dimension].[hierarchy].[level].MEMBERS, where dimension is the logical name of a dimension, hierarchy is the logical name of a hierarchy, and level is the logical name of a level. This expression represents the members of the given level.

   If these identifiers do not include spaces, you can omit the square brackets. Also, the expression is not case-sensitive.

   The first set expression controls what happens when the user double-clicks the first time. Specifically, when the user double-clicks the first time, the system creates a new query that uses this set expression for rows and that is filtered to the given context.

   Similarly, the second expression controls what happens when the user double-clicks the second time, and so on.

   The Drilldown Expression option overrides any other drilldown behavior in this pivot table. That is, if a level is in a hierarchy, the hierarchy drilldown behavior does not occur for this pivot table.

4. Click OK.

Disable drilldown: If you wish at any time to disable (but preserve) this drilldown expression, select the Disable drilldown check box. Click OK. This prevents use of the drilldown expression when you double-click a row in this pivot table. It also prevents modification of the drilldown expression. To re-activate the drilldown expression, clear the Disable drilldown check box.

For a Drilldown Expression example, see Custom Double-Click Drilldown.