AdvancedQuerySettings

Advanced querying options

API Section: Objects

Type: Object

Properties

Name

Description

Required

Type

Format

diamondShapeBridgingTables

Should use heuristics to find the relevant bridging tables in diamond shaped models

 -

boolean

joinDimensionsViaMeasureGroups

Should dimensions be joined only via common measure groups

 -

boolean

nonNumericQueryWithDistinct

Should queries that have no measures in them be queried using DISTINCT instead of GROUP BY

 -

boolean

subQueryCardinalityLimit

Over what column cardinality size should an attribute be filtered using subqueries when possible

 -

integer

int32

subQueryMaxDepth

The maximum depth to nesting subqueries when filtering attributes

 -

integer

int32