Version 2021

OLAP Function Support

The OLAP function support VLDB property defines whether OLAP functions support backwards compatibility or reflect enhancements to OLAP function logic. This VLDB property has the following options:

  • Preserve backwards compatibility with 8.1.x and earlier (default): OLAP functions reflect the functionality of pre-9.0 releases to support backwards compatibility.

    This behavior does not correctly use multiple passes for nested or sibling metrics that use OLAP functions. It also does not correctly apply attributes in the SortBy and BreakBy parameters.

  • Recommended with 9.0 and later: OLAP functions reflect the enhancements included in 9.0 and later releases.

    This recommended behavior uses multiple passes for nested or sibling metrics that use OLAP functions. The functions also ignore attributes in SortBy or BreakBy parameters when the attributes are children of or are unrelated to the component metric's level.

Levels at Which You Can Set This

Database instance, report, and template