1. Administering Planning
  2. Accessing More Administrative Tasks
  3. Administering Forms
  4. Creating Forms
  5. Defining the Layout
  6. Enabling Drilling on Shared Members

Enabling Drilling on Shared Members

Form designers often use shared members to create alternate rollup structures within an application. To increase usability for these alternative hierarchies, the application provides the ability to drill on a shared member for a given dimension. The option to drill is a dimension property which provides the flexibility to focus the drill behavior to a particular dimension. The drilling option is only available for dimensions placed on the row or column axis during form design. Page or POV dimensions don't have drill capability.

For example, using the following hierarchy representing the Entity dimension:

Example Entity dimension hierarchy

A form with iDescendants(Southwest) defined on the row would return the following members:

  • TX

  • FL

  • NM

  • South

  • CA

  • AZ

  • CO

  • West

  • Southwest

To enable drilling on shared members in a form:

  1. Open the form, and then click Layout.
  2. Click in a row or column dimension to expand Dimension Properties.
  3. Under Dimension Properties, select Drill on shared members.
  4. Click Save.