Kyvos now supports a query callback-based mechanism for efficiently applying filters to a large cohort set during query execution. To implement this, Kyvos has introduced a new function in the MDX query named CUSTOMKYVOSFILTER. Inside the CUSTOMKYVOSFILTER function, a GUID (Globally Unique Identifier) is present, which is mapped to the filter values present in the JSON or CSV file. You can also use the Query Playground page to execute an MDX execute the MDX query using REST, any external tools, or by utilizing the Query Playground page.
This mechanism allows you to either directly provide filter values in the MDX query or specify a list of filters in a JSON/CSV file by modifying the code and providing the file path. This file, which must be accessible to the JAR on the BI Server node, contains the necessary filter-related details.
...
CUSTOMKYVOSFILTER (fieldName, firstvalue, secondvalue, operator)
Parameter details of CUSTOMKYVOSFILTER
Parameter | Description |
|---|---|
fieldName | Fully qualified name of Level/Attribute of a Dimension |
firstValue | GUID/ID, which will be used to map the actual list of values in the callback code |
secondvalue | In case needed based on operator |
operator | INLIST/NOTINLIST |
The following is a sample MDX query code using the CUSTOMKYVOSFILTER.
...