[number2, …]) – Returns the k-th percentile of the values in a list, where k-th percentile is in the range 0..1, inclusive.
ES(k-th percentile, number1, [number2, …]) – Returns the average of the values exceed k-th percentile of values in a list, where k-th percentile is in the range 0..1, inclusive.
Ability to detach Views
Pasted Views can now be detached in Jedox Web, similar to Jedox Excel Add-in. In detached views, the user is free to customize the layout and position of View components, remove parts of the View, and further customize the report.
Detached Views can also be rebuilt at a later point in time. When rebuilding a View, all contents that are located in the View area of the spreadsheet will be overwritten.
Macro function for closing the current workbook
A new macro function __close() has been added which allows to close the current workbook for example when a button in spreadsheet is clicked.
The function has to be called as part of a “return” statement in the macro code. It can only be used in macro functions that will be triggered from a form element such as a button, not from macros used as spreadsheet functions in cells.
Ability to exclude form elements in XLSX Snapshot exports
Since version 6.0, form elements (Checkboxes, Comboboxes etc.) can be exported in XLSX workbooks. A new configuration option in 6.0 SR3 allows to disable the inclusion of form elements when exporting XLSX files.
The filter is defined in the ooxml_config.xml configuration file of Jedox Web Spreadsheet Server (core).
New UI Layout for Integrator Modules
For the Jedox Integrator modules Connections, Extracts, Transforms, Loads and Jobs are implemented new icons to start the creation of a new corresponding module:
Connector to Tableau
The New Integrator Load type “Tde” allows to load data into files of the .tde file format used by Tableau. Additionally, you can publish data loaded into such a file to a Tableau Server from the same load.
For Groovy functions and Groovy jobs can be defined restrictions
It is possible to define restrictions to the capabilities of a script inside of a Groovy function or a Groovy job with the usage of the Java Security Manager. By default, the Java Security Manager is disabled, the authorizations inside of the script are those of the OS user of the “JedoxSuiteTomcatService” Service.
Jedox Excel Add-in
Keep Elements in View
You can now restrict the rows or columns of a View to only one or a few of the shown elements directly from the spreadsheet. Select the cell(s) showing the elements in the row, or column, which you want to keep; then right-click, and from the context menu select “Cross Drilldown” => “Keep…”. The View will then only show the selected elements.
New check boxes on Subset Editor Tabs
On Subset Editor Tab Hierarchy of Excel Add-in are now implemented the check box “Siblings” in the area “Filter elements hierarchically” and the check box “Relative level” in the area “Filter elements by level”. If last one is checked, filter uses end level relative to start level instead of using the absolute enumeration. “Siblings” displays all elements that have the same parent(s) as the reference element(s).
On Subset Editor Tab “Text” of Jedox Excel Add-in the checkboxes “Don’t use alias” and “Ignore case” have been added, for the whole definition of recently changed parameters of PALO.TFILTER().
On Subset Editor Tab Attribute of Excel Add-in are now implemented the check boxes “PERL regular expressions are used” and “Ignore case” for the whole definition of the recently changed parameter “Type” of PALO.AFILTER().
Note: In Jedox Web these checkboxes are not yet implemented.
Ability to define Report Group used for Jedox Mobile
To control the list of reports shown in the Jedox Mobile app, you can now define a specific Report Group from Jedox Web Report Manager. To define this group, create a new setting called “mobile.report.default_group” in Jedox Web Settings Manager (type string), and, as value, set the name of an existing Report Group, the contents of which you want to be shown in Jedox Mobile app.
Optionally, you can also define a specific Reports hierarchy from this group to be shown. Create a new key called “mobile.report.default_hierarchy” for this purpose. If this key doesn’t exist, the app will show the contents from the first hierarchy in the group.
Ability to disable UI elements in Mobile Reports
The scrollbar, sheet selector UI elements, as well as “pinch” zooming, can now be disabled for specific reports in the Jedox Mobile app. To disable these features, define one or more of the following tags on the report file in Jedox Web File Manager: disable_sheet_selector, disable_scrolling, and disable_mobile_zoom.
Ability to customize appearance of Jedox Mobile apps
Various Interface elements of the Jedox Mobile apps (iOS and Android) can now be customized. For this, user can add specific new settings keys in Jedox Web Settings Manager. The value for each setting then controls the appearance of a specific interface element in the app (for example background colors), when the app user logs in to the Jedox Server where the setting was defined.