Page Comparison

...

Kyvos now supports a query callback-based mechanism for efficiently applying filters to a large cohort set list of filters 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 execute the MDX query using REST, any external tools, or by utilizing the Query Playground page.

...

A JAR is created in which you can either hardcode filter values or upload filters in a JSON or CSV file by providing its path in the code.

Functions Signature

CUSTOMKYVOSFILTER (fieldName, firstvalue, secondvalue, operator)

Parameter details of CUSTOMKYVOSFILTER

...

SELECT {{[Measures].[MeasureName]}} ON COLUMNS, NON EMPTY HEAD(NONEMPTY(HIERARCHIZE({{ADDCALCULATEDMEMBERS({[Dimension].[Hierarchy].[Level]})}}),{[Measures].[MeasureName]}),10000) ON ROWS FROM (SELECT CUSTOMKYVOSFILTER([Dimension].[Hierarchy].[level],"GUID"," ","AND","INLIST") ON COLUMNS FROM [SModelName]) 

Steps to implement and setup callback code in Kyvos

1. Create a JAVA class that should implement in the JAVA callback interface as a part of the callback code.

2. QueryFilters parameter holds all the filters applied in the query. The callback code iterates over all the filters to identify those that need resolution via an appropriate flag in the filter object. Subsequently, every callback filter is resolved against the received GUID/ID, replacing it with the actual list of values within the same filter object before returning it.

3. The JAVA class created in Step 1 needs to be packaged in a JAR file. This JAR file needs to be uploaded in Kyvos via Kyvos Manager. Along with jar, you must configure the name of the class (full qualified name including package name) created in step 1 in Kyvos Manager.

...

package cohortfilters;
 
import com.kyvos.commons.callback.query.IFilterCallback;
import com.kyvos.commons.entity.olap.viewer.Filter;
import com.kyvos.commons.entity.olap.viewer.Filters;
import com.kyvos.commons.queryanalyze.QueryInfoBean;
import java.io.FileReader;
import java.util.Arrays;
import java.util.Iterator;
import java.util.logging.SimpleFormatter;
import org.json.simple.JSONArray;
import org.json.simple.JSONObject;
import org.json.simple.parser.JSONParser;
 
public class CallBack implements IFilterCallback {

 
   public Filters getResolvedFilters(Filters queryFilters, QueryInfoBean queryInfoBean) {
      Filter filter = (Filter)queryFilters.getFilters().get(0);
      String guid = filter.getFirstValue();
      String userName = queryInfoBean.getUserName();
      String values = getValueByUsernameAndGUID(userName, guid);
      filter.setFirstValue(values);
      return queryFilters;
   }
 
   public static String getValueByUsernameAndGUID(String userName, String guid) {
         String location = "pathToFiltersJson";
         FileReader reader = new FileReader(location);
         JSONParser parser = new JSONParser();
         JSONObject jsonObject = (JSONObject)parser.parse(reader);
         JSONArray adminArray = (JSONArray)jsonObject.get(userName);
         if (adminArray != null) {
            Iterator var8 = adminArray.iterator();
            while(var8.hasNext()) {
               Object adminObj = var8.next();
               JSONObject admin = (JSONObject)adminObj;
               JSONArray guidArray = (JSONArray)admin.get(guid);
               if (guidArray != null && guidArray.size() > 0) {
                  JSONObject valueObj = (JSONObject)guidArray.get(0);
                  return (String)valueObj.get("VALUE");
               }
            }
         }
      return null;
   }
 
}
 
 
 
 
filters json ::
 

Sample Filter File

 {
   "userName":[
      {
         "GUID1":[
            {
               "VALUE":"'',''"
            }
         ]
      }
,
      {
         "GUID2":[
            {
               "VALUE":"'',''"
            }
         ]
      }
   ]
}

...

To upload the JAR file you have created via Kyvos Manager, perform the following steps. 

...

Log into Kyvos Manager.

...

Click Toolbox, navigate to Security > Data Security.

...

On the Data Security page, select the Enable Custom Filter checkbox to enable CUSTOMKYVOSFILTER filter in Kyvos to handle large cohort value.

...

Upload the Custom Filter Callback JAR file. 

...

Specify the Callback JAVA Class name, providing the fully qualified class name, including the package name. 

...

Click Save.

...