Semantic Model: kyvos.query.metadataread.maxlimit

Description:
This property limits the records to be fetched from metadata for SQL queries.

Values and behavior

Possible values: Any integer

Default value: -1

If set to a negative integer, no limit is set to fetch records from metadata.
If set to a positive integer, the specified number of records from metadata will be displayed in result.

Note

If any BI tool specifies a limit in its input query, the property will not be respected.

Comes into effect:
The property comes into effect in a new browsing session after setting the property on the semantic model. This property does not require a semantic model reprocess.

Even if LIMIT clause is applied but query execution time remains high on the underlying SQL compute engine for ROLAP models, the recorded duration represents the time consumed by the SQL engine.

Recommendation:
Not applicable.