Release March 2022

We are happy to deliver the brandnew March 2022 release with new showcases and new features for filter tables. 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) New showcase “S&OP Demand Planning”

We are happy that we can present now our showcase #8, the new “S&OP Demand Planning”:

This showcase uses a dynamic definition table with the individual combination “customers – products”:

Selecting another customer of course changes the list of products for this customer:

Please be aware that at this stage this showcase has only a few demo data, we will upgrade this showcase with the next month releases.

(2) Improved showcase “HR Contract”

The “HR Contracts” showcase one our first showcases …

… so we decided to add a new dynamic list report with all the employees and their annual planning values:

Remember, the dynamic list reports feature was introduced with the July 2021 release. Of course the list report is dynamically requeried when selecting another item from the dimension tree:

(3) Filter Tables: new filter path parameter

For this new showcase we developed a new filter path parameter which is essential in application with “same name elements” in the dimension tree. If you retrieved a dynamic filter table until now …

… with focus on an ambiguous element in the dimension tree the table delivered all the bottom level elements from all subnodes with the same name:

To solve this we introduce a new parameter:

  • data1_CELLS01_DIM001_Key_Path

This field is filled with every click in the dimension with the full “SQL Where” path which can be used directly as filter criteria for the dynamic filter table:

(4) Filter Tables: new RLS option

Another important issue is the application of Row-Level-Security to dynamic filter tables. Until now, this was not possible and therefore filter tables delivered always the full list of elements independently of the RLS rules:

With this release we introduce the new parameter

  • data1_CELLS01_InsertTable_ForceRLS

which can be set to “0” (= default, no RLS) or to “1” (= RLS is applied to the filter table):

We intend to make the “Force RLS” feature to the new default with a later release.

(5) Web App: new “Is Visible” field

In some cases you need to keep an element in the dimension tree (e.g. for historical data) but you do not want to show the element in the dimension tree anymore. For this reason we added the new “Is Visible” definition field to all dimension tables. Setting an element to “false” …

… will remove this item from the dimension tree:

(6) Web App: new subscription form

With the September 2021 release we introduced the new UI forms for workflows and for the company data. With this release we deliver now also the Subscriptions with the new UI element. Since a company can have several subscriptions you`ll see at first the overview list with all active subscriptions …

… and clicking on one element of the list will open the form:

Please be aware that at this time the subscriptions cannot be edited by yourself (i.e. all the fields are read-only).


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

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *