Release July 2023 (before the summer break)

We are happy to deliver the brandnew July 2023 release with the new calculation wizard and many other 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) Web Client: New calculation wizard (Add-On)

With the new calculation wizard your users can enter values with the calculation operators +, -, * or /:

How does this work? The definition is very simple:

  • Definition of the named range “data1_CELLS01_Calculation
  • Simply type the column letter of the source column for the calculation in this range (only into the desired columns)

Please note that this new feature is licensed as Add-On since it was financed by a single data1.io customer. Please find the current pricing here.

(2) Web Client: New parameter “Application Key”

The ListQuery feature was introduced in the February 2023 release and was improved in the March 2023 release, in the April 2023 release and the May 2023 release.

If you want to connect your ListQuery filter with the Fact table – e.g. to show only elements with current values – then the application key is needed for this SQL filter criteria. Until now this application key had to be hard-coded within the workbook.

With this release you can use a new parameter to retrieve dynamically the application key:

  • Named range “data1_ApplicationKey

Simply connect your application key with the ListQuery Filter using a formula to generate an SQL filter statement like this:

  • [DIM005.KEY] IN (SELECT [DIM005.Key] FROM appG5K9KA5DVD.T_FACT01 WHERE [SYSTEM.IsDeleted] = 0 AND MEASURE01 IS NOT NULL AND [Dim003.Key] = ‘MARKET’)

(3) Web Client: New parameter “Read after Write”

From now on you can defined a refresh of your sheet after the WRITE process – e.g. in order to refresh the ListQuery with the customers which have already data:

Simply define

  • Named Range “data1_ReadAfterWrite
  • 1 = execute a Read process immediately after the Write process
  • 0 = do nothing after the Write process (= default)

(4) Web Client: Debugging for % queries

There were several issues with aggregated “%” queries:

  1. Combination of “%” query in 1 dimension and “%” query in another dimension
  2. Combination of “%” query in 1 dimension and “-1” query in another dimension
  3. Combination of “%” query with the definition of a “DIM001_Alternative” parameter

Those issues are solved now.

(5) Web App: New behaviour of table filters

We have changed the behaviour of table filters in 2 manners:

  1. Deactivating the filter button removes now all current filters from the table
  2. Deleting records does not remove current filters from the table any more

Think of the fact table with 2 current filters:

First, deactivating the filter button removes now not only the filter symbols from the table header but removes now also all current filters from the table:

Second, deleting records …

… does not change the current filters anymore:

This will help you a lot, if you have to delete records in portions with the variation of only 1 filter criteria and keeping the other filters unchanged. And if you want to remove all the current filters simply press the filter button to do this. 🙂

(6) Technical Improvements and Debugging

We have solved an issue with the error message “Cannot read properties of null (reading ‘findIndex’)” with Sheets that have no READ activated cells.

We have solved another issue with the error message “Sequence contains no elements” with sheets that have no valid date in the named range “data1_CELLS01_DATExx”.

Furthermore there was an issue with the title of workflows using the new type “recurring”.


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. 

We`ll be back after the summer break with the September Release!

we #StandWithUkraine

Release June 2023

We are happy to deliver the brandnew June 2023 release with the new recurring workflows and many other 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) Web App: New workflow type “Recurring Workflow”

In the May 2023 Release we launched the new workflow type “Continuous Workflow”, in this release we proudly present the new “Recurring Workflows”!

Simply select in the workflow definition the option “Recurring Workflow” …

… and define the frequency either weekly, monthly or quarterly:

You can see the specific workflows resulting from the definition in the timeline visualisation, e.g. for a weekly workflow:

The specific workflows are defined with 4 parameters – similar to the definition of “single workflows” – for the start and end day:

(2) Web Client: New workflow parameters

We have created 4 new parameters to connect your workbook with the Valid-From and Valid-Until information from the current workflow:

  • data1_COLLECT_Read_FromUTC
  • data1_COLLECT_Read_UntilUTC
  • data1_COLLECT_Write_FromUTC
  • data1_COLLECT_Write_UntilUTC

You can use these new parameters to fully automate your workbooks especially in recurring workflows (but of course these parameters are also available for single workflows):

(3) Web Client: Write button has moved to the menu bar

Until now, the Write button was placed at the top of the dimension tree, the reason for this was the former Excel client (which is not developed further). Therefore it was time to move the Write button …

… to the new menu bar in the header pane (which we introduced in the April 2023 release):

Another reason for this step is the further improvement of the mobile layout (which we started in the April 2023 release):

(4) Web Client: New onboarding messages

Every month we launch many new features – for you as a user it can be difficult to find out all the news. We are very happy to launch now the new onboarding messages which makes it easy for you to see the changes and new features in the user interface (both the Web Client and the Web App):

(5) Web Client: New “Analyze read process” dialog

We have created a new Power User feature which helps you to understand how the shown value in a workbook cell is driven by the records in the fact table. E.g. you want to know, from which fact records the value “550” in cell “AC31” comes from. Simply right click the element in the dimension tree with held CTRL key and select the command Analyze read process:

The dialog consists of 3 list sections:

  • In the first list scroll to the line for the cell “AC31” and click on this record.
  • In the second list you can see now the underlying records from the fact table
  • In the second list you can see all records from the fact table

(6) Web App: Menu bar also in the workbook preview

Triggered by the move of the Write button to the menu bar we have activated the menu bar now also in the Preview function for the workbook (in the Web App):

(7) Web App: Redesigned section “5. Run your Workflows”

We have redesigned the section “5. Invite your Users” which is named now “5. Run your Workflow(s)“:

Until now, this section was focussed on the “Invitation e-Mails“:

Now, we have moved the “Workflow Status” (from “6. Use your collected Data”) and the “Copy Data Journal” (from “1. Create your Dimension(s)” into this section. Furthermore we have created a superordinate “Info” page which gives you an overview for this section:


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. 

we #StandWithUkraine

Release May 2023

We are happy to deliver the brandnew May 2023 release with important new workflow options in the Web App! 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) Web App: New workflow type “Continuous Workflow”

We are very happy to present a new workflow type: Continuous Workflows! The workflow type that we had to date is now called “Single Workflow”.

You can change now the workflow type …

… to “Continuous Workflow” then this workflow has no start and no end date any more. That means this workflow will be valid for an indefinate period of time.

The workflow box in the web client does not show any validity date for the collector users and there is no “Finish” button:

(2) Web App: Configure the Finish button in “Single Workflows”

In the “Single Workflow” we had until now the mandatory “Finish” button:

From now on, you can activate or deactivate the Finish button and furthermore you can also configure the message that is shown to your collector user in the workflow box:

Please be aware that the user-specific “Collection Status” becomes irrelevant, if the Finish button is deactivated (the same is true if the workflow type is “Continuous Workflow”):

(3) Web App: Improvements for E-Mail Notifcations

We happy to present the new “E-Mail Send Weekday” option:

Furthermore we have moved the activation / deactivation button for the E-Mail Notifications from the “Invite your users” section directly into the workflow settings (since this is much more intuitive):

(4) Web Client: Definition of mandatory entries

Another important new feature is the definition of mandatory entries like this:

It is very easy to use. Just define the following 2 parameters (= named ranges) in your workbook:

  • data1_Write_Validation
    0 = default = Writeback is open
    1 = Writeback is blocked
  • data1_Write_ValidationMessage
    Use this parameter to define the message for the user, which is displayed if the first parameter has value “1” and the Write button is pressed.

You can simply control the write validation by generating a “1” on the first parameter via a formula which is referenced to the validation rules in your individual workbook:

Furthermore you can define as many write validation “couples” in your workbook as you like:

data1_Write_Validation_1
data1_Write_ValidationMessage_1

data1_Write_Validation_2
data1_Write_ValidationMessage_2

(5) Web Client: Group By for ListQueries

The ListQuery feature was introduced in the February 2023 release and was improved in the March 2023 release and in the April 2023 release.

Until now, it was only possible to define a ListQuery on the bottom level of a dimension table like this:

With the new Group By Feature it is possible to define a ListQuery also on an aggregated attribute in the dimension table like this:

The feature is activated with the new parameter (= named range) “data1_CELLS01_DimensionValues_T_DIM00x_GroupBy”:

  • 0 = default = bottom öevel (no group by)
  • 1 = aggregated level (group by)

This GroupBy parameter causes all “output parameters” (here on Attribute 15) to deliver grouped lists:

Compare the grouped list above with the dimension table itself:

(6) Web Client: Show workflow box also after validation date

Until now, the organizer of a workflow and its deputy …

… did not see the workflow box in the Web Client after the validation date of a workflow (type “single”) – all other collector users did seet it. This is fixed now, so that also the organizer and the deputy can see the workflow box:

(7) Technical Improvements and debugging

We have solved a bunch of issues:

  • Troubles with E-Mail Notifications since SendGrid changed the verification rules for senders on May 1st 2023
  • New Write Button: performance issue with the check of writeable values in large sheets
  • New Write Button: activation/deactivation also in real time (on formula result changes)

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

Release April 2023

We are happy to deliver the brandnew April 2023 release with important layout improvements in the Web Client! 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) Web Client: New Menu Layout

We have integrated the buttons from the former menu bar into the header pane in order to get more space for the spreadsheet:

Remember, the former menu bar was placed below the header pane, therefore we had a lot of empty space above the spreadsheet:

(2) Web Client: New Workflow Layout

We have placed the workflow box now in the lower bottom corner which contains now also the Finish button:

Remember, until now the workflow box and the Finish button were splitted up above and below the dimension tree:

(3) Web Client: Improved Mobile Layout

Both layout changes result also in an improved mobile layout! The new header pane is now lower than the former one since we have shrinked also the data1.io logo on the left and the personal preferences menu on the right hand side of the header pane:

This is a first major step to make data entries possible also on the mobile phone. We know that the user experience is not yet perfect, improvements are also necessary for the dimension tree and the sheet selection.

(4) Web Client: Feedback and Help Buttons moveable

Die Feedback and Help Buttons at the bottom of the screen are now moveable along the bottom of the screen:

(5) Web Client: Improvement for ListQueries

The ListQuery feature was introduced in the February 2023 release and was improved in the March 2023 release. Now we deliver another important improvement: the initial READ process when the sheet is loaded resp. entered is now coordinated with the ListQuery. Therefore you can use the ListQuery feature now also to automatically generate a dynamic view for data entry and report sheet on the first view.

(6) Web Client: Improvements for Details Rows/Columns

We have also improved the “Details function” which was introduced in the September 2022 release, the November 2022 release and the March 2023 release.

From now on you can use the visibility setting for rows/colunns also in sheets which have no READ process (e.g. landing / navigation pages). Furthermore we have made the visibility process after the READ process fully reliable.

(7) Web Client: Performance Improvements for the READ process

We have – again – improved the performance of the READ process with those actions

  • Recalculate formulas during the READ process only once in the end (instead of automatically recalculate all formulas during the READ process)
  • Ignore cell types “3” and “4” within the READ process

(8) Web Client: Empty Dimension Tree

We have improved the display of an empty dimension tree, which can happen during maintenance of if the Row-Level-Security settings of a user has no matches.

(9) Web Client: Data Entry Formats

We have solved some important data entry format topics.

First, decimal places for % entries were truncated.

Second, we have implemented an automatical conversion for the language specific format of date and numbers. That means, if your browser language is set to English then you can enter a date or a number also in the german language format (“dd.mm.yyyy”) and it works. This automatic conversion is also done for pasted dates and numbers.

Third, we have improved the validation message for date and numeric values:

(10) Technical Improvements and debugging

We have solved a bunch of issues:

  • Upload of very large CSV files caused error “Error writing MIME multipart body part to output stream.”
  • Issue with the CSV download (“slipped columns”)
  • Excel download of “Collector Users” table was not active
  • Dim_Types table was not availabe in ODATA feed
  • The icon selection for element types was buggy
  • The Fact Table was not available in the “Field Properties” settings
  • We have made security improvements and solved some resulting bugs
  • We have made improvements in multi-tenant environments

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

Release March 2023

We are happy to deliver the brandnew March 2023 release with many new up- and download functions in the Web App! 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) Web App: New Update Mode for table uploads

Until now, you had to delete e.g. the dimension table before you uploaded a new version of this table. From now on, you can choose if you want to append the records from the upload file or if you want to update the existing records in the target table:

The new upload mode dialog shows you, which field in the table will be used as key field for the update process:

The new update mode is blocked with the fact table since we see no fields of application for the update mode, even more it would be risk if you choose the wrong mode:

(2) Web App: New Download for large tables

We started the development of the download feature for large tables about 6 months ago and invested a lot of energy in this feature. Now we are happy that the feature is mature and generally available!

Every download is now – the same way as the uploads – executed in a background task which provides the download file after it was finished successfully. This background task is now stable also for downloads of large tables.

(3) Web App: New Upload of CSV files

Since large tables have often more than 1 mio rows, we support now also CSV files as upload files:

(4) Web App: New Upload of Files > 300 MB

Until now we had an restriction of 300 MB for every upload file. We have removed this restriction now, therefore xlsx or csv files of any size can be uploaded.

(5) Web App: Further Improvements for table uploads

Until now, the first sheet in the upload file was uploaded – independantly if this sheet was visible or hidden. From now on, the first visible sheet is upload, hidden sheets are not relevant any more for the upload.

Furthermore, the empty string (“”) in date fields causes no longer an error when uploading such files.

(6) Web Client: Improvements for the ListQuery feature

The ListQuery feature was introduced in the February 2023 release. We have improved the sorting of the dynamic list and you can now also display the content of the SORT column of the queried dimension table.

(7) Web Client: Improvements for the Visibility settings

We have also improved the “Details function” which was introduced in the September 2022 release and November 2022 release. There was an issue with the “1” parameter and also some other tricky situations when the rows/columns were shown initially the wrong way round. This is solved now so that there are no open issues in this feature.

(8) Technical Improvements and debugging

We have solved many technical issues and also some bugs. For instance, the download of the collector users table was not active any more. Then we have solved a bug with the new RLS definition (which was released in February 2023 release) and the WRITE button. There was another issue with the Always Encrypted feature.

Finally, the display of the “Admin” role on the planning widgets in the “Your active collection” landingpage was not shown for Tenant Admins:


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

Release February 2023

We are happy to deliver the brandnew February 2023 release with the new ListQuery function, the extended RLS definition and many other 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) Web Client: New ListQuery feature – how it works

The new ListQuery feature can be used to generate dynamically necessary rows and/or columns! By selecting an element in the dimension tree, the list feature generates a list with the relevant elements depending on the selected element:

Please be aware that this new list feature replaces the previous solution using dynamic tables as a helper for dynamic reports. The new feature is better performing and does not need complicated formula constructions with the INDEX() function and others.

(2) Web Client: New ListQuery feature – how it is defined

The ListQuery feature only needs 2 defined named ranges to define the (SQL) query for the drilled list of elements:

  • data1_CELLS01_DimensionValues_T_DIM001_Filter
    The first parameter is the where-clause, which is applied on the referenced dimension table (here: DIM001). In the showcase below, we use the result of another parameter – namely data1_CELLS01_DIM001_Key_Path – in order to filter the dimension tree table on the elements below the selected tree node.
  • data1_CELLS01_DimensionValues_T_DIM001_Sort
    The second parameter is the sort-condition, which is applied on the resultset of the list query.

With these 2 parameters you can generate as many resultsets for the KEY, the NAME and any Attribute that is needed in the worksheet:

  • data1_CELLS01_DimensionValues_T_DIM001_DIM001_KEY
    This is the list with the element KEYs from the DIM001 Table. This resultset is used to query the values in a dynamic list report.
  • data1_CELLS01_DimensionValues_T_DIM001_DIM001_NAME
    This is the list with the element NAMEs from the DIM001 Table. This resultset is used to fill the row headers in a dynamic list report.

All together:

(3) Web Client: Read first element

The following new parameter replaces the previous parameters “data1_ReadFirstTopElement” and “data1_ReadFirstBottomElement”.

  • data1_ReadFirstElement

This parameter rules the behaviour when entering a sheet the first time after loading the workbook.

  • 0 = do not read
  • 1 = default = the first top element (from the tree) will be read on entering the sheet. Used to read directly the current aggregated sums in order to get an overview of the status of the data collection.
  • 2 = the first bottom element (from the tree) will be read on entering the sheet. Used to jump directly to the first bottom element in order to start immediately with data entry.
  • 3 = read the predefined element from the named range “data1_CELLS01_DIM001” (from the workbook) -> if this element is not found / not valid, then no READ is executed.

(4) Web Client: Elements with same name

Until now, elements with the same name within the same node have not been displayed properly. From now on, this is no issue any more, every element (based on its unique KEY from the dimension table) is shown in the dimension tree:

(5) Web App: Row-Level-Security (RLS) extended level definitions

We are really happy to present the new extended RLS definition. Until now, it was difficult to define RLS in dimension tree structures with same name nodes. E.g. authorizing a user only for “Sales Team 1” in our HR showcase shown above was quite difficult until now.

From now on, every RLS record can – but must not – be concretised with additional information in the higher levels of the dimension tree. This way it is quite easy now e.g. to authorise a user only for “Team 1” in the “Team Maintenance” branch and for “Team 2” only in the “Team Sales” branch of the tree:

This is the result in the Web Client:

Existing definitions in your application(s) based on the previous technique were transformed automatically to the new definition structure.

(6) Web App: Blank row filter for upload files

Until now it was a problem, if an Excel upload file contains e.g. a formatted cell below the actual data, since this leads to 3 additional imported blank rows which caused an error when uploading this file (due to a primary key violation):

From now on, the upload of such an Excel file is no problem any more:

(7) Technical Improvements and debugging

We have solved issues with the search function in the dimension tree and with the long-running opening of the edit dialog in the dimension tree. Furthermore we have solved an issue with the (undesireable) writeback of % aggregation elements and an issue with the +/* fact attribute definition. And there was an issue with the query of the data1_CELLS01_DIM001_Attribute parameter.


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

Release January 2023

We are happy to deliver the brandnew January 2023 release with the new Iterator function and many other 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) Web Client: New iterator function (Add-on)

The new iterator function “switches” the workbook through all bottom-level elements below the element the process is started – i.e. a bottom element is selected, the READ process is executed and then the WRITE process for this element is executed. This is useful in all applications, whenever dependant calculations within the workbook exist. Here in this case the percentage for the Employer Fees can be adopted and then all elements have to be re-calculated.

The iteration can be started on any top level element from the context menu …

… and after the confirmation …

… the iteration process is started:

The new iteration function is an Add-On function, that means it can be activated for an extra fee.

Within the application, the iterator function is activated / deactivated on the workbook level:

(2) Web Client: Query logic improvement for the READ process

This feature improves the SQL statement that is used to fill your worksheets with data. More precisely, the SQL query on the fact table is customized depending on the dimension key fields that are actually used in the worksheet where the READ process is executed.

Until now, the value in a cell within the workbook was determined …

… by grouping the fact table over ALL dimension key fields …

… and then showing the value or text of the first record (if several records exist for a cell) that is found. If in the sheet not all of the filled dimension keys were queried, the result was strange (too small) values because of the group by also on the not queried columns in the background.

From now on, the fact table (in the background) is selected and grouped only by those dimension, that are actually used in the sheet for the READ process. This makes the SQL statement not only much shorter but also much more effective. You can now use now in a planning or report sheet all or only some of the filled dimensions. You will now always get the correct full sums for the cell.

(3) Web Client: Performance improvement in READ process

This feature improves the WHERE clause of the SQL statement that is used in the background to fill the cells of a sheet during a READ process:

  • The “Tree” dimension (= DIM001) has always been filtering the virtual fact table by the selected element(s)
  • The “Date” dimensions (e.g. DATE01) filter now on the time range from the lowest to the highest date (“BETWEEN”) that was found in the named range definition
  • The “String” dimensions (e.g. DIM002) filter now on the list of the elements found (“IN”) in the named range definitions

Due to a SQL restriction, the first filter 2000 parameters are taken into account for this query performance optimization.

The effect of this query optimisation is all the greater the more (historical) records are in the fact table, that are not relevant for the current READ process.

(4) Web App: Row-Level-Security (RLS) also exclusive now

Until now it was only possible to define RLS inclusive.

From now on it is also possible to define RLS rules also exclusive.

This makes it much easier to define security rules like “user has access to the whole company except one node“. Since RLS rules in data1.io are executed in an additive way, simply combine inclusive rules with additional exclusive rules:

So, the new exclusive definition is realized with the new Deny Access user right, the other 3 user rights are all inclusive:

(5) Web App: Direct access to true/false fields

We are happy, that from now on it is possible to change true/false definitions in the Web App (“data1.io Backend”) directly in the table view:

This is implemeted until now in 4 tables, after a testing period further tables could follow.

(6) Web App: New Add-On Licenses

The new Iterator function is a so-called Add-On license. This is a new subscription type which optionally can be booked for your application (at this time this is not opened for self service, please contact us if you are interested).

(7) Web App: Improved message on sorting Always Encrypted columns

We have improved the message when you try to sort an Always Encrypted column in the Web App (= Backend):

Remember: as an tenant admin you will find the Always Encrypted column(s) in your Application Settings (at this time, this function is not opened for self service, please contact us if you want to activate/deactivate this function).

(8) Technical improvements and debugging

We have solved issues whith the “add element” function the dimension tree, with the drag & drop in Lists (e.g. for the “Edit Tree” attributes) in the Firefox browser, with multiple filters on tables in the Web App and with the calendar dropdown in the Web App.

Furthermore, we have renamed the parameter data1_CELLS01_SyncSheets_Read to data1_SyncSheets_Read and data1_CELLS01_SyncSheets_Write to data1_SyncSheets_Write. due to logical reaons (the previous names are still supported).


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

Release December 2022

We are happy to deliver the brandnew December 2022 release with the new “Aggregate only visible elements” function and many other 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) Web Client: New option for “Aggregate only visible elements”

Until now, on a sum level all values from all elements below were aggregated. This can lead to unexpected and even incomprehensible aggregated values, if there are “dormant” values on records from hidden elements or values that were written to the wrong element type (for whatever reason).

The new option “Aggregate only visible elements” sums up values from subordinate elements with 2 conditions:

  1. The Treefilter (from the named range “data1_TreeFilter” on the sheet)
  2. The element attribute “Is Visible = True” (from the dimension table / tree)

The option is activated via a new setting on the workbook:

With the option activated you can be sure that the values on an aggregated level are by guarantee the sum of the visible elements below that node:

(2) Web Client: New option for “Allow Comments”

The “Add Comment” function in the workbook is not in all cases a useful or desired feature:

For this reason we introduce a new setting – also on the workbook level – to activate or deactivate the comments function in the workbook:

(3) Web Client: Sheet changes now with “You have unsaved data” message

A small but important new feature for all multi-sheet applications is the “You have unsaved data” message which is triggered now not only by changing the active element in the dimension tree but also on changing the sheet if you have unsaved data:

This new behaviour makes it more realistic NOT to sync especially the READ process over several sheets of the workbook. That in turn can save a lot of performance in such multi-sheet applications.

(4) Web Client: Display of long tree element names

Until now, long element names in the dimension tree were wrapped over several rows. This looked a little bit messy, now we changed that behaviour that way that each element is shown in one row independently from the text length:

(5) Web App: New table filter “Is Empty”

We have added the new “Is Empty” option in all table filters which makes it much easier now to e.g. delete such records from a table in the backend of your application:

(6) Web App: Table filter with several conditions

There was an issue when you combined several filters on the same table with the “Match Any” option. This is solved now so that you can combine any filters on the same table:

(7) Web App: New retry logic

In the cloud service, we have implemented a new “retry logic”. This helps to handle connection errors, timeouts etc. and makes the Web Client as well as the Web App more stable.

(8) Install data1.io as Browser App

It is possible now to install the data1.io service as a Browser App. Browser apps are supportd in Chrome and Edge but not in Firefox at this time.

Simply click the “Installation” option in the menu of the browser …

… and then install it:

Now you can use the data1.io service like an app on your desktop: you can simply pin it to your Windows Taskbar and start the Web Client or the Web App this way.

(9) Technical Improvements and debugging

There was an issue with the dropdown list for the definition of the element type in the dimension table.

Another issue was solved with cell comments which were not shown correctly in multi-sheet applications.

Then an issue with the READ process in a vertical “data1_CELLS01_ByColumnMapping” scenario had to solved as well as an issue with the ExceptionType2.


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

Release November 2022

We are happy to deliver the brandnew November 2022 release with the new Details Button and Tree Attributes functions and many other 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) Web Client: Extension for the details function

In the September 2022 Release we have introduced the new Details function. Now we have extended the function with the new parameter “2“:

  • 0 = always hide the column or row
  • 1 = hide/unhide the column or row with the details button
  • 2 = always show the column or row
  • any other = do nothing

Furthermore we have added a “change trigger“: whenever a value changes in the visibility named ranges, then the details function is executed and the rows and columns are hidden or shown immediately (depending on their current definition).

You can use this for many fields of applications, get inspired by the following two.

Fields of application #1: showing detail rows controlled by dropdown selections

You can control now the visibility of rows and columns simply with dropdowns – and of course you can combine this also with the Details button:

In the background this is simply done by connecting the visibility settings with the dropdowns via normal Excel formulas:

Fields of application #2: showing/hiding details rows/columns controlled by the element selected

You can show/hide now very easily rows and columns that are only relevant on the bottom level of the dimension tree:

In the background this is simply done by connecting the visibility settings with the value of the data1_CELLS01_IsSumLevel parameter:

Please be aware that this feature causes a performance overhead – therefore test your workbook carefully with this great feature before you publish it to all your collector users.

(2) Web Client: Force update popup

This is a very important new feature!

Since many (collector) users keep their browser tabs open for several days (or sometimes weeks), this can be a big problem since they would not work with the current version of the data1.io Web Client / Web App. This is solved now since every user gets an update message box when the version is not the newest one:

(3) Web Client: Column selection for dynamic tables

The column selection for dynamic tables can now be configured: simply define (or leave) only those column of the table that are relevant for your usecase.

(4) Web Client: Show/hide the named ranges dropdown and the formula bar

The named ranges dropdown can be a security risk since your collector users could enter settings that maybe are not protected and could then be edited.

With this release you`ll find two new parameters:

  • data1_Visible_FormulaBar
    0 = hide
    1 = show
    no definiton = default = show
  • data1_Visible_NamedRanges
    0 = hide
    1 = show
    no definiton = default = hide

Setting the value to “1” will show both the named range dropdown as well as the formula bar:

Setting the value to “0” will hide both:

No definiton will show the defaults – formula bar on and named ranges dropdown off:

(5) Web Client: New parameter to trigger the row filter

There is a new parameter

  • data1_Trigger_RecalculateAndApplyFilterOnChange

With this named range you can define one or more cells of the sheet as trigger cells to execute a RECALCULATE of the formulas on the sheet and a refresh of the ROW FILTER (“auto filter”). The second feature is similar to the automatic “change trigger” for the new visibility settings presented further above in item #1.

(6) Web Client: Improvements on the reload of the dimension tree

We have solved an issue with the reload of the dimension tree after editing e.g. the element type of an element.

(7) Web Client: Improvements on sheet changes

We have solved issues with the parameter data1_ReadOnSheetChanged, which was introduced in the June 2022 Release. This worked already well with the parameter “1” (= READ when re-entering the sheet) but not with the parameter “0” (= no READ when re-entering the sheet). In this case, the dimension tree was not shown correctly when coming back to the sheet. With this release we have solved this and it works now well with both configurations.

We have solved also an issue with the parameter data1_CELLS01_SyncSheets_Read, which triggers the READ process over several sheets. It happened that the Write button was not activated when re-entering the sheet although it should have been. This is solved now.

We have solved a third issue with same name sum-level elements in the dimension tree. It happened that the wrong sum level element with the same name as the selected element was READ when re-entering the sheet.

(8) Web Client: Improvements on the “Download every tree node” function

We have solved a bug with the “Download every tree element separately” and same name elements:

The download files of the sum-levels are now named with the full path of the node – there same name elements do not overwrite each other any more:

(9) Web App: Improvements on deleting records from (large) tables

We made the process of truncating a table (= deleting all records of a table) now also to background task although this would be not necessary from a technical point of view. But this guarantees the same user interface for all types of deleting records from a table.

(10) Technical improvements and debugging

We have solved two bugs with the conditional formatting feature in the Web Client`s spreadsheet. One confused the “. and ,” due to language settings and another one overruled the “cell locked” property and opened locked cells for data entry. Both issues are solved now.

Another issue happened in the “Weekly Projects Showcase” (which uses the so-called “BY-CELL” mode): the writeback of only empty cells was not executed. Now it is exectued.


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

Release October 2022

We are happy to deliver the brandnew October 2022 release with the new dimension tree setting in multi-sheet workbooks and many other 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) Web Client: Remember the tree in multi-sheet workbooks

Until now, in multi-sheet workbooks the dimension tree was always reset to its initial configuration when the sheet was changed.

With this release, every sheet stores now its individual tree configuration when the sheet is left:

In this sheet the tree configuration is different and also stored individually with this sheet when it is left:

See the new default behaviour in action:

(2) Web Client: Performance improvements for new Details function

In the last Release (September 2022) we launched the new Details function to hide / show rows and colunns by pressing the new Details button. We have learned that this feature is slow if there are a lot of rows and columns and if the steering parameter is calculated with formulas.

Therefore we have improved the feature by stopping the formula calculation during the show / hide process and then trigger a recalculate() after the process. This improves performance e.g. from 10 sec to 3 sec.

(3) Web Client: Performance improvements with Always Encrypted

Always Encrypted means that the content of some or all columns in a database table of a data1.io datamodel is encrypted. That means that the content of this column is not readable for an unauthorized person even if this person should get access to the database. In the data1.io Enterprise Plan datamodels we usally encrypt the measure columns.

There was a big performance issue with this Always Encrypted feature (= Enterprise Plan). The issue was that a top level aggregation with e.g. 300,000 fact records takes 4 sec, with Always Encrypted enabled the same aggregation took 100 sec. We managed to improve this READ performance to about 10-15 sec which is a big step forward. Of course we will work to further improve that performance.

(4) Web Client: Changes on READ with the empty string “”

From now on, empty strings (“”) are not taken into account in the READ process. This is e.g. important if comments for Actuals should be collected with data1.io and the Actuals that were imported have empty strings in the relevant text attribute of the imported records. In this case it happened that not the entered comment (from the comment record) but the empty string (from the imported record) was shown on the READ process.

(5) Web Client: Changes on WRITE with the 0 and the empty string “”

From now on, 0 in measure cells are written back to the fact table as a record. This is important especially for the new forward projection feature which we introduced in the July 2022 Release. The writeback of 0 enables now the reduction of an existing projection down to 0 (until now you had to enter something like 0,001 to bring the value down to nearly 0).

On the other hand, empty strings (“”) in measure cells are not written back since this would cause a data type error on the numeric fields of the fact table.

This can be an important change for your application: if you don`t want that a result is written back you have no to output an empty string instead of a 0.

(6) Web Client: New multi-level query

Until now, a mix of different levels in a level query did not work – only the values for the keys were delivered:

With this release you can mix the levels as you like:

Please note that this is only a technical demo (the values and sums do not make sense).

(7) Web App: Delete as background task

We have introduced the background tasks for uploads last month in the September 2022 release. This month we roll out the background task also to the deletion of records:

The deletion is executed as background task on the server, the status bar is shown during the process is running and after it is finished:

This new background task guarentees that the deletion works reliable also with a large amount of data.

(8) Technical Improvements and debugging

We have solved an important issue with the new parameter data1_ReadOnSheetChanged on writeback. Another 2 issues with comments were solved, the comments were not shown properly under certain circumstances. Issues in the workbook wizard and a wrong interpretation of percentage figures in the sheet are solved now as well. Furthermore we solved an issue in multi-workbook / multi-workflow environments.


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