Semantic Model: kyvos.query.calculated.member.filter.enabled
- Sarabjeet Kaur
Description:
This property is used to apply filters on calculated members.
Note
From Kyvos 2025.2.2 onwards, you can now enable/disable the filtering of calculated members at the semantic model level for Spark-based deployments.
This feature will be certified for semantic models processed when the kyvos.process.compute.type value is set to Kyvos Compute.
Values and behavior:
true: Enables calculated members to be filtered when selected in filters.
false: Only base data members will be filtered when selected in filters.
Default value:
false
Comes into effect:
The value of the property can be changed at any time (not recommended) and comes into effect in the next build.
Environment:
Applicable in all environments.
Points to know
Ensure the following when filtering calculated members for Spark-based deployments:
Hiding calculated members is supported only in Kyvos Visualization when executed using MDX. For SQL, calculated members will not be listed anywhere.
Filters on calculated members will be respected only for attributes, not hierarchical levels.
For hierarchical levels, calculated members in filters will be treated like invalid members. If this is the only valid member based on the filter, then the ‘no data available’ message is displayed.
If only calculated members are selected as valid members, the ‘no data available’ message is displayed.
Advanced filters such as TopN/BottomN, cohort filters, or measure filters will not be respected. They will get ignored.
Related content
Copyright Kyvos, Inc. All rights reserved.