Release June 2022

We are happy to deliver the brandnew June 2022 release with the next level “HR Contracts” showcase which is enabled by many new features! Try it now!

Remember, the Web Client is the user friendly spreadsheet for your Collector Users to deliver their monthly/weekly/daily data. The Web App is the tool for the Power User to setup and control your organization’s collection workflows.

(1) Next Level “HR Contracts” Showcase

We have upgraded our showcase “HR Contracts” massively this month!

You`ll find a new data entry sheet “HR New Hires” with a dimension tree that is filtered to the elementtypes corresponding with that data entry sheet:

The existing data entry sheet “HR Contracts” has got a dimension tree filter as well to show only those bottom elements in the tree which make sense in this data entry context:

Furthermore we have improved the HR List Report (based on the Dynamic Table sheet), you will see that further down.

(2) Web Client: New Treefilter

The filtered tree that you can see in the showcase screenshots above is implemented with this new parameter

• data1_TreeFilter

The syntax for the filter statement is very similar to the WHERE clause of SQL queries. If you filter on element types, then please mind that you have to use the UID number of the element type:

(3) Web Client: New Refresh-Event on Sheet Change

We introduce another

• data1_ReadOnSheetChanged
  0 = nothing happens when selecting the sheet
  1 = Refresh when selecting the sheet

Simply add this new parameter to every page of your multi-sheet application …

… and the sheet will be refreshed when you select a certain sheet of your workbook:

This is important to make sure to see the current data from the database in the sheet.

(4) Web Client: Element Types also on Sum Levels

Last month we introduced the new element types and the new parameter which writes the element type from the selected element into the workbook:

• data1_CELLS01_DIM001_Type

With this release, this parameter delivers now also on all sum levels the element type of the first found bottom element below the selected sum element:

(5) Web Client: Dynamic Tables Sorting

With this release, the sorting of dynamic tables is not randomly anymore:

You can see the sorting in the sheet “(Dynamic Tables)”. By default a dynamic table is sorted now by the field DIM001.SORT the same way as the dimension tree is sorted:

Furthermore you can define a custom sort order in MS Excel (before you upload the file into your data1.io application):

(6) Web Client: Dynamic Tables Performance Improvement

We have improved the READ performance of dynamic tables by a factor of about 50 %. This was possible since in the background the data entry validitiy rules for the table were loaded and this is not necessary for dynamic tables in the spreadsheet.

(7) Web Client: Dynamic Tables in Performance Analyzer

We have added the READ process for dynamic tables to the Performance Analyzer (launch with Ctrl + Alt + P). This way it is easy to evaluate the impact of a dynamic table to the READ performance of your application:

(8) Web Client: Admin Widget on the Application Tile

As a Power User you can use the link Your active collections …

… to get to your active collections. If you are at the same time Collector User for external applications, it is now very clear which applications are your own since the application tiles are marked with an Admin widget:

(9) Web App: New Workbook Preview Experience

We are happy that we have improved the Workbook Preview experience …

… by removing all RLS and Workflow settings from this preview:

This was very tedious until now, since you had to setup a valid workflow definition (validity period and allocation to the workbook) and a valid RLS definition just to be able to preview your workbook. Especially when you setup your own application the first time this is much clearer now and easier to understand than before.

(10) Technical Improvements and Debugging

We removed a bug that multiplied the application number of tiles on the applications landing page and furthermore we removed another bug concerning %-Level aggregations.

---

Hope you like the new features – we are very curious about your feedback! Please let us know what you think and what kind of collection processes you would prefer to automate with data1.io. 

Stay healthy and we #StandWithUkraine