Description:
This property specifies an upper limit when pulling distinct dimensional values from a non-materialized cube. 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.