Release November 2025 (before christmas break)

We are happy to deliver the brandnew November 2025 Release with the new Writeback for Dimensions and many other Features! Try it now!

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

(1) Frontend: Improved Writeback for Dimensions (Preview)

We have introduced the new Writeback last month in the October 2025 Release. This month we deliver a new field of application in our public P&L showcase and a new action button.

(a) New P&L Showcase

In our P&L Public Showcase have added a new sheet for editing the customer dimension table (which is used as basis for the customer dropdown in the Revenues Planning).

In this sheet all the columns and records of the “Dimension 005” are shown with a dynamic list query:

You can edit the data of this table and execute the writeback:

After refreshing the list query you can see that the table was updated by the writeback process:

(b) New Action Button for new records

Action Buttons are very important feature in data1.io and are established very well. This month we have added the new action type “AddNewRowToListQuery” which makes it possible to create a button that inserts a blank row – either at the start or the end – of a list query:

{ "Title": "Add new customer", "Action": "AddNewRowToListQuery", "Action Parameter": "data1_LISTQUERY01", "Action Parameter 2": "start", "Status": "Enabled" }

Pressing the button …

… inserts an empty row at the top of the list query, pressing the button double will insert two blank rows. In those new blank rows new records can be added and written back withe Write button:

Refreshing the list query proves that the writeback of the new records was succesful:

(2) Admin Center: New Validation Views

We are very happy that we can deliver the brand new section “Validation Center” with the new validation views. Those views will help you to and identify inconsistencies and keep the data in your datamodel clean. You will find in the dropdown validation views for those dimensions that are activated in your datamodel:

The validation view for DIM005 in this application shows, that 85 fact records use a DIM005 Key which is not defined in the corresponding dimension table and 2 fact records don`t have a DIM005 Key at all.

Those views basically shows the same information as the long-established “Key Wizard” with two key advantages:

1. Validation views also shows the records with blank keys
2. Validation views show the records and can be filtered down to the currently most relevant data

(3) Admin Center: New Popup Screens

We have streamlined the menu structure and have moved two section to new popup screens.

The first one is the Copy Data Journal which can be accessed by the new button within the Copy Data section …

… and is shown now as popup screen:

The second one is the Event Log which can be accessed by the new button within the Sent E-Mals section …

… and is also shown as a space-saving popup screen:

(4) Frontend: Changes for Attributes on Sum Levels

Attributes from the dimension table already have been shown on a sum level, if all the elements below have the same entry for the attribute:

We have changed two things:

• The attribute is also shown if some of the elements have blank values
• The attribute is also shown if the elements below are not visible in the dimension tree

This is important for “sum-level” applications and applicatons with large dimension structure.

(5) Discontinued “By Cell Mode”

We are in a process of cleaning up our software to focus on the important features. Last month we have started with the discontinuation of two of the older showcases. This month we remove the so-called “By Cell Mode”, which never got practical relevance and makes data1 more complex than necessary.

We removed the “Definition Mode” selection from the Workbook Wizard. With the “By Cell Mode” the data from the workbook (= yellow cells) are all written on the one same record.

The “By Cell Mode” can be recognized in a workbook by multiple “MEASURExx” and maybe also multiple “TEXTxx” definitions:

The idea was to be compatible with alternative frontends like Power Apps, but this never got practical relevance. The removal of this mode reduces complexity and creates room for new functions.

(6) Technical Updates

We have updated our Angular Framework to the current version 20. Furthermore we have solved “vulnerabilities” in our Angular Web Client Projects and we have automatized the replacement of Refresh-Tokens for security reasons.

---

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 christmas break with the January Release!

we #StandWithUkraine