Semantic Model: kyvos.cube.rawdata.metadataquery.scanlimit

Description:
This property specifies an upper limit when pulling distinct dimensional values from a non-materialized semantic model. The value defined for this property lets you limit the number of rows scanned required for serving the responses of metadata queries.

Values and behavior:
A positive integer indicating the number of rows to scan for generating query response.

Default value:

-1: By default, the system will scan the entire table.

Scope:

• Semantic Model: If the property is applied at a semantic model, then the value set at the semantic model will be respected for that particular semantic model.

Comes into effect:
This property can be applied at any time. For Metadata queries on non-materialized semantic models.

Dependencies and related properties:
NA

Recommendations:
This property can significantly impact the query performance of meta queries. Generally, if the fact table is large, where a full table scan is slow, the value should be adjusted. However, if the value is too low, the cache will miss values on certain columns.

Example:
If you set the value as 1000, the meta cache query would add a LIMIT clause to the query, limiting the record scan to 1000 rows to find the distinct values.