IncludeEmptyRows
This connection property can be set only when using the V4 API. If set to false, the provider does not include rows if all the retrieved metrics are equal to zero. The default is true which will include these rows.
Syntax
property IncludeEmptyRows: Boolean;
Possible Values
True, FalseData Type
Boolean
Default Value
true
Remarks
Allowed Values:
TRUE | The provider includes the rows where all the retrieved metrics are equal to zero. |
FALSE | The provider does not include the rows where all the retrieved metrics are equal to zero. |
Note that it is still possible for no rows to be returned with this set to TRUE depending on the dimensions included in the query. This property will only work when the cardinality of the dimension is known over the date range (such as with the Date dimension). If the cardinality is unknown or not defined, such as with the ProductName dimension on the Ecommerce table, no results would be returned.