Configuring cascading for dimension refinement

When users refine by dimension values on a component, you can configure the dimension to use cascading.

Cascading means that when the data is refined to a single value for the dimension value, the component is updated to use a different dimension.

When there are no more dimensions to cascade to, the component remains on the last dimension in the cascade.

For example, a component includes a Country dimension. The Country dimension is configured to cascade to State and then to Supplier. With this configuration:
  1. When users refine the data to only show records for the United States, the component uses the State dimension (for states within the United States).
  2. If users then refine the data to only show records for California, the component uses the Supplier dimension (for suppliers within California).
  3. If users then refine the data by a specific supplier, the component displays the data for the selected supplier, and the cascade stops.

Note that for multi-or or multi-and dimensions, where users can refine by more than one value, then if the data is refined by any one of the dimension values, the cascade continues to the next dimension, even if there are still available values to refine by.

When configuring a dimension, to configure cascading for refinement:

  1. In the Dimension Cascade section, select the Enable dimension cascade check box.

    The cascade configuration displays. The current dimension is automatically at the top of the cascade.


    Initial display when dimension cascading is enabled

    You can select the next dimension in the cascade from the list.

  2. To add a new layer to the cascade, select the dimension for that layer from the list, then click Add Layer.

    The new layer is added to the end of the cascade.


    Dimension cascade with a layer added
  3. To remove a layer from the cascade, click the delete icon next to that layer.
  4. To clear the entire cascade, click Clear Cascade.