Data Tab in the Subset Editor


Related main article: Description of Subset Editor

The PALO.DFILTER() is a compute-intensive function, so the auto-refresh option in the preview is deactivated by default when this data filter is activated. It is very important to note that the performance of DFilter subsets largely depends on the size of the cube slice being calculated. The more dimensions that are left unspecified in the slice settings, the larger this cube slice gets, and complexity of the calculation increases. If possible, at least one element should be specified for all dimensions, and we advise against using the asterisk wildcard character in the PALO.SUBCUBE part of the PALO.SUBSET formula (indicated with arrows below):

For this filter, the criterion, operator, and value for comparison can be defined:

As an example, a simple slice over the months “Jan, Feb, Mar” and the other elements shown above are selected here.

Note: when the criteria is set to “string”, the Subset editor automatically generates a formula with the search criteria in quotes (e.g. {“=”.”textstring”}), as long as the search criteria consists of letters. To search for a numeric value, the number must be entered with quotes in the search field. For example, you have to enter “1” (with quotes) in the search field if you want to look for the string value 1. In that case, the Subset Editor will generate the correct search term to find string values: {“=”.”1″}. If you enter a numeric value without quotation marks (e.g. 1) in the search field, the Subset Editor will generate the following search string: {“=”.1}, which is treated as an empty string. 

In Jedox Web, if you want to use a variable for slice operators, then you see three possibilities above:
If you select the first possibility, then the variable must point to a matrix of either two or four cells, where the odd cells contain the operator and the even ones contain the value. Valid examples for a two-cell matrix are A1:B1 and A1:A2. Valid examples for a four-cell matrix are A1:D1, A1:A4, and A1:B2.

With Excel Add-in Subset Editor you get only this first possibility! Possibilities two and three are only available in the Jedox Web Subset Editor.
If you uncheck the first variable of slice operators shown above, then you can select an operator and you can select a variable for the operand (variable must be defined as a value or as a cell reference). The procedure for the third shown variable possibility is the same.

The following is a screenshot showing the output of the Subset Editor with several settings for criteria and different compare operators and values:In this example, the criterion “All elements > 200” returns elements for which the values of “Jan” AND “Feb” AND “Mar” are all greater than 200.  

Was this post helpful?
NoYes (-10 rating, 14 votes)