Release July 2024 (before the summer break)

We are happy to deliver the brandnew July 2024 release with the new Always Encrypted mode generally available, new CELLS02 features and many more! 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: Always Encrypted on Dimension Keys now GA

We introduced the new Always Encrypted (AE) mode on Dimension Keys last month in the June 2024 release and we worked hard to make this new option generally available (GA) this month!

Why should you change the AE mode in your application?

  • In large applications this can improve the READ performance of your workbooks by about 100 up to 200 % and therefore also save the hardware capacities of your application.
  • In smaller applications the performance gain is smaller with about 20 to 30 %.
  • Of course – as always with software – the performance gain depends on several variables and it must be tested in every specific application.

Remember, until now the Always Encrypted feature could only be applied to the numeric fields like Measure01 and Num01:

From now on Always Encrypted can also be applied to the dimension keys:

Alway Encrypted – both on the Measures as well as the Dimension Keys – brings some restrictions:

(1) In the Web App (“Backend”) the filter options on these fields are reduced and the sorting is not possible.

(2) In List Queries, encrypted columns cannot be used in the SORT parameter:

If you are interested in changing the encryption mode of your application and test the new possibilities, please contact us.

(2) Showcase: HR Contracts with new CELLS02 area

We introduced the new multiple layouts with CELLS02 in the May 2024 release and we are happy to present this month a practical appliation in one of our public showcases.

In the “HR Contracts” showcase you’ll find in the “Existing Projects” sheet the new area “Last Forecast (Comparison)” which is implemented as a separate CELLS02 area. It is used to show the last forecast which consists of only 3 months Actuals and 9 months FC I:

(3) Web Client: “Performance Analyzer” structured by CELLS01, CELLS02, etc.

We also improved the way the Performance Analyzer (CTRL + P) presents the performance values for both CELLS areas:

(4) Web Client: “Analyze Read Process” structured by CELLS01, CELLS02, etc.

Furthermore we added the CELLS information also to the “Analyze Read Process” dialog:

Remember, this dialog is started with pressed CTRL key and right mouse click on a dimension tree element:

(5) Web Client: New Parameter “data1_CELLSx_ReadOnly”

We introduced also the new parameter data1_CELLS01_ReadOnly, data1_CELLS02_ReadOnly and so on:

  • 1 = CELLS area is Read Only
  • 0 = CELLS area is Read and Write activated

This parameter should be used if you have only READ activated cells in your CELLS area to make sure that the writeback process does not cause any recordset deletions when trying to replace values.

(6) Web Client: Parameter “data1_ChangedCellFormat” valid for CELLS01, CELLS02, etc.

We changed the existing parameter data1_CELLS01_ChangedCellFormat to the new syntax data1_ChangedCellFormat which is valid now for all CELLS areas:

The previous syntax of course is also supported.

(7) Web Client: Action Buttons now GA

We introduced the Action Buttons in March 2024 release and improved this feature in the following releases. This month the Action Buttons are Generally Available (GA) which means that you can use this feature in all your applications.

(8) Web Client: New Action Parameter for Drillthrough Buttons

With this release the new “Action Parameter 2” can be added with a Drillthrough Button definition:

{ “Cell Address”: “C22”, “Title”: “Drillthrough nach Wizard Workbook EMP10”, “Action”: “Drillthrough”, “Action Parameter”: “Wizard Workbook”, “Action Parameter 2”: “EMP10”, “Status”: “Automatic”, “Rounded Corners”: false, “Background Color Enabled”: “magenta”, “Text Color Enabled”: “white”, “Border Color Enabled”: “blue”, “Background Color Disabled”: “gray”, “Text Color Disabled”: “black”, “Border Color Disabled”: “indigo” }

You can use it both with bottom level and top level elements:

  • Bottom level element = use the DIM001.KEY, e.g. “EMP10
  • Top level element = use the path separated with comma, e.g. “Sigma Ltd,Sales Area ENGLAND

(9) Improvements and Debugging

As every month we have done a lot of smaller improvements and debugging.


We hope you like the new features – we are very curious about your feedback!

Please let us know what you think about data1.io and what kind of planning and data collection processes you evaluate to automate.

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

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 *