Support for OLAP data sources in interactive brushing

As of release 12.1.2, you can use OLAP data sources with the interactive brushing feature.

You can now specify two OLAP properties for brushing operations: Property To Pass and Property To Match. Property To Pass determines the OLAP value that is passed to parameters when you make a selection. Property To Match determines the OLAP property, which the system uses to decide whether to highlight a container. By default, both properties use the Member Caption (MC) value. However, when you apply new parameters, the drop-down list automatically selects the Member Unique Name (MUN) value.

This feature delivers precise OLAP filtering, reliable highlighting, a consistent user experience, and supports complex hierarchical data structures. It remains fully compatible with earlier versions and gives you flexible control over which OLAP property to use, without affecting relational data sources. By following the same behavior with prompts and drill‑through, it integrates into existing workflows.

This enhancement supports the following OLAP properties:

OLAP property Description
memberUniqueName (MUN)

A unique identifier for a member.

hierarchyUniqueName (HUN)

A unique identifier for the hierarchy.

dimensionUniqueName (DUN)

A unique identifier for the dimension.

levelUniqueName (LUN)

A unique identifier for the level.

memberCaption

Specifies a member’s display text. It remains a default value to preserve compatibility with an earlier version

Important: Due to lack of OLAP metadata at run time, the feature does not support the following client controls:
  • VIDA visualizations
  • Data tables
  • Client-side controls
The Property To Pass and Property To Match drop-down lists do not appear for these controls, and interactive brushing operates using a caption-only behavior.