Release May 2025
We are happy to deliver the brandnew May 2025 Release with the new Parallel Hierarchies and the new Sum-Level Trees! 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) New Parallel Hierarchies
We are very happy to provide this new feature which enables a lot of new applications.
a. Field of application
Basically, with parallel hierarchies the elements of the dimension tree can be grouped in alternative structures:

b. New Hierarchy Definition
At first, you decide which attributes from the dimension table will be used for a parallel hierarchy. Then you can rename those fields in the “Datamodel” and upload the new dimension table:

Next, you create the parallel hierarchy in your datamodel and name it properly:

Then you define, which attributes from the dimension table belong to the new hierarchy:

That`s all!
c. Extended Row Level Security (RLS)
We have extended also the dialog for the Row Level Security (RLS) for parallel hierarchies.

Please be aware that the RLS from one hierarchy is NOT applicable to a parallel hierarchy (although the same bottom elements are involved) – if RLS is relevant also for the parallel hierarchy, then it has to be defined separately.
Please be also aware that at the moment, only the first 10 attributes from the dimension table can be used for RLS definitions (and the default names are shown in the dialog).
d. New Workbook Parameter
Finally we have created a new workbook parameter in order to define which hierarchy from the dimension tree should be used in certain sheet of the workbook:
- data1_TreeHierarchy
Of course, this parameter is optionally. If not defined, the “Default Hierarchy” from the hierarchy definition will be applied.

(2) New Aggregated Hierarchies
You can use the new parallel hierarchies also for another field of application. Instead of showing a fully detailled dimension tree e.g. in reports and landing pages …

… which is based on a definition like this (including the “Tree NAME” on the bottom level) …

… you can define a separate hierarchy …

… which uses the same attributes but leaves the “Tree NAME” on the bottom level:

This leads to an aggregated “sum-level” tree which can be more effective especially in reports:

(3) New User Profile Image
From now on, the user profile image will be shown in all tables from the Admin Center …

… this makes it easier for you to recognize your collector users on the first view. 🙂

(4) Table Improvements
a. Editable Fact Table
We have removed the read-only restriction for the fact table. So from now on the records from the fact table can be edited – this makes it easier to correct individual errors:

b. Improved Element Type Display
We have improved the display of the element type in the dimension table (column width) and also the content of the dropdown filter (symbols instead of html code and no “default” element anymore):

(5) Copy Data Improvements (Add-on)
Also this month we have improved the Copy Data feature. From now on you can define not only “is equal to” but also “is not equal to” filter conditions:

Copy Data works now also with applications with “Always Encrypted” on – this was a quite big issue to solve.
Last but not least, the execution of a Copy Data job in the Admin Center is not shown any more also in the Frontend.
(6) Further Improvements
Now it is possible to wrap the names of the columns in an upload file in square brackets [], those brackets will be ignored and the files are uploaded the same as without square brackets.
Furthermore we have solved an issue with the creation of new applications.
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 #StandWithUkraine