Release June 2025

We are happy to deliver the brandnew June 2025 Release with the new Admin Center UI and new Copy Data 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) Admin Center: New User Interface

We are very happy, to deliver a major update for the user interface of our Admin Center!

a. New Menu Format

We renewed the menu format by

  • adding symbols to the menu items
  • removing the enumeration of the major menu items
  • removing the vertical line on the second level of the menu
  • removing the hamburger icon on the top
  • moving the tenant information into the header

Compare the new menu format and page layout …

… with the old format and layout:

A major goal of these changes was also to replace the previous folded slim menu (which was titled “Navigation Pane” and was only a placeholder) …

… by a fully functionable slim scale menu based on the images (which is of course already a standard for many SaaS solutions):

b. New Landing Page

Since we removed the enumerations from the major menu items on the left, we thought it would be a good idea to replace also our old landing page which carried only very little information (i.e. a list of the available applications) …

… with a new info page, which is hopefully helpful to get a good orientation about the content of the menu structure on the left:

c. New Loading Behaviour

Another major change is a new loading behaviour for the sub-content of the selected menu item.

Until now, the whole content from the horicontal sub-navigation was loaded initially when selecting a menu item – which could take a quite long time.

From now on, only the content of the first menu item – which is currently the “Info” page – is loaded when selecting a menu item and is therefore very fast. When selecting another item from the horicontal sub-navigation, it will be loaded and you have to wait only for the selected content. This will save most of you a lot of time since usually we do not enter all the items from the horicontal sub-navigation.

d. New Mobile Layout

We are very happy, that with the new menu format we could reach a major improvement for the mobile view of the Admin Center! In portrait view, the slim navigation on the left makes it quite realistic to use also the mobile to change some settings within the Admin Center …

… while in landscape view the navigation can be expanded:

(2) Admin Center: New Copy Data Features

With the April 2025 Release we have delivered a major update for the Copy Data Feature, with the May 2025 Release we delivered another important improvement and with this release we deliver 2 more major features!

Please be aware that this feature is an Add-On which needs to be licensed seperately.

a. New Groups

The more features we deliver, the more Copy Data jobs will be defined. This made it necessary to add a new group level in order to bundle jobs which belong to the same logical process and usually should be executed in one batch.

If you enter the Copy Data definition you will see now a new group level called “Non-grouped copy data definitions”:

Sure, you can define now a new group …

… and move your existing jobs to the new group:

With the new “Execute all” button on the group level you can start all jobs in one batch:

The preview for the replacement of the existing records is now expanded to all included jobs:

The jobs are executed sequentially in the order of appearance:

b. New @ Parameter

Another big feature is the possibility to use now @ parameters for your target rules in order to define the result of a copy data job with a formula!

Think on the SYSTEM.Delta field:

In many cases you`ll need to fill this field dynamically in order to create a new forecast / planning version which can be edited after creating the base values with copy data jobs.

If you use an @ parameter, the Validate target value formula button will appear and deliver da preview of your formula:

Here is the compact information about the usage @ parameters:

Usable with every field in the target rules area

You can reference on all fields from the fact table and on all related attribute fields from the 10 dimension tables. Use the SQL name of the field as @ parameter, you’ll find them in the “Develop your Datamodel” section:

(3) Admin Center: Leading Zeros during Download

Until now, leading zeros from dimension keys where removed in the Excel download file. With this release, the download of data1.io tables into Excel files is executed on the basis of the field definition in the data1.io database. Therefore, leading zeros from dimension keys …

… will not be removed anymore, since dimension key fields are defined as alphanumeric fields in the database:

(4) Admin Center: Improvements for Parallel Hierarchies

We have released parallel Periods in our last May 2025 Release, this month we have two improvements.

First, you can change now the name of the Hierarchy Key, which is not a key anymore but only a display name (until now this was not a good idea since the relationship to the hierarchy levels was last after renaming the key):

Second, only one hierarchy can be the default hierarchy:

(5) Admin Center: Billing Infos

We have worked on automatization of our billing, visibly there are 2 new fields int he Capacity Changelog which shows you, which rows were already billed and which ones are open:

Please be aware that at this time there are no financial information from the bill are shown here.

(6) Further Improvements

The definition of the named range data1_CELLS0x_DIM001_Alternative did not work, if it contained only of 1 cell – this works now.

We have improved the message, if a Dim001 Key is not found on writeback in conjunction with active Row Level Security (RLS).

There was an issue with the browser message “Page does not respond” due to repeated attribute queries – this could be solved.

We have solved an issue with copy & paste on protected cells, another issue with the writeback of empty data entry sheets and an issue with “Drillthrough Documents” which are not allocated to any workflow.

Finally we could solve an issue with truncated dropdown lists.


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

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 *