Specifies whether the provider uses a breadth-first strategy to retrieve rows for all combinations of dimensions in a multi-level report.

Data Type

bool

Default Value

false

Remarks

This property determines how the driver retrieves dimension combinations in reports that involve multiple breakdown levels.

If this property is set to true, the driver uses a breadth-first approach to include more dimension records per request. Each breakdown level is queried in a wide, flat structure, which is useful when analyzing reports across multiple dimensions. When this property is enabled, the driver does not support returning summary data rows. This mode may also result in additional empty rows. To suppress them, enable the SkipEmptyRows property.

If this property is set to false, the driver uses a depth-first breakdown strategy. Each record in the root breakdown is queried separately, which is more efficient for single-dimension analysis.

This property only applies to reports created using the CreateReport stored procedure.