We are happy to deliver the brandnew February 2026 Release with the new Showcase “Baustellenbewertung” and the GA for the Dimension Writeback! 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 Showcase “Baustellen Bewertung”

We are happy to deliver a new showcase in our “Public Showcases” Gallery – it is called “Baustellen Bewertung” and is setup in German language:

After opening this new showcase you`ll see a description of the showcase and a button to enter the data entry sheet:

The content of this showcase is the monthly evaluation of the responsible site managers about the construction progress (in EUR) on their construction sites. The line structure of the data entry form follows the Austrian Standard List of trades on a building construction site based on the Austrian classification system according to ÖNORM B 2061 in conjunction with the service group classification LB-Hochbau / ÖNORM A 2063:

On the bottom level data entry is done on the categories “Eigen” and “Fremd”. Mainly for the current month (= blue column) and additionally a forecast until the end of the year (= yellow columns):

(2) Improved Showcase “Weekly Project Status”

We took the chance and also improved our existing showcase “Weekly Project Status”:

We added a Landing Page with important background information about the showcase and navigation buttons as well as …

… adding a “back” navigation on every single page:

(3) Dimension Writeback

We introduced the Dimension Writeback with the October 2025 release as preview and improved it in the November 2025 release. With the latter release we have also added the dimension writeback in our P&L Public Showcase:

(a) Generally Available (GA)

With this release, the dimension writeback is generally availabe (GA). Just to rememember: with this feature master data from the dimension tables can be edited and added directly within the workbook by the collector users:

Make your changes to the master data and execute the writeback …

… and the master data is changed in the underlying dimension table:

(b) Dimension Audit Table

With this release we deliver the “Dimension Audit Table”. In this table all historical versions of the updated records are stored to make changes transparent:

(4) Huge Technical Update to .NET 10 / ASP.NET Core 10

During the last months we prepared the migration of the whole data-one-service project to .NET 10 / ASP.NET Core 10. The final migration was done last weekend.

• Long-term support (LTS)
• Improved performance
• Platform independence
• Built-in dependency injection
• Modern authentication
• Improved developer tools
• Actively maintained libraries
• Enhanced security

(5) New Subscription Prices 2026

We have changed our prices the last time in January 2024 from 2,50 per user, month and app to 4,50 per user, month and app. With the maturation of the data1.io software, we change our subscription prices now to EUR 6,50 per user and month. Therefore we have increased the subscription fee per user, but we have removed the “per app” condition which makes the solution cheaper for multi-application customers.

As always, this new price is valid for all new customers (= tenants). Existing Enterprise Plan customers of course keep their early adopter conditions for lifetime as promised and of course can opt to the new pricing model if this is more favourable!

(6) Further Improvements

The “Key Wizard” has been moved from the menu item “Create your Dimension(s)” to the menu item “Prepare your data”.

There was an issue with the dates in the “Copy Data” definitions. Under certain circumstances the saved date switched back automatically on the day before. This happened due to UTC conversion and this is solved now.

There was another issue with the Tenant Admin user list. Under certain circumstances you saw only yourself as a tenant admin but not the other tenant admins of your tenant(s). This is solved now.

---

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

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

We are happy to deliver the brandnew September 2025 Release with the new Multiple Tree Selections, the new Audit Table 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: Multiple Tree Selection

a. How it works

Simply define the new named range data1_MultipleSelection and use the following parameters:

• 0 = Single Tree Selection (default behaviour)
• 1 = Multiple Tree Selection

This will activate the new Multiple Selection button in the right top corner of the dimension tree:

Pressing the button will switch the dimension tree into multiple selection mode and will make visible the new Read button in the menu bar (which is not activated until a selection is made):

Select the elements from the tree which should be summed up and press the Read button (which will be activated after a selection is made):

As always in data1.io, of course you can also formulas to dynamically control the parameter and therefore the appearance of the dimension tree.

b. Multiple Selection in List Queries

Multiple selection is automatically applied also to List Queries on the DIM001 dimension table:

c. Multiple Selection in Dynamic Tables

Last but not least, multiple selection is also automatically applied to Dynamic Tables connected on the DIM001 dimension table:

(2) Showcase: Writeback on Sum-level Elements

We have added a writeback on sum-level elements to our Integrated P&L Planning Public Showcase. Writeback on sum-level elements is not a new feature but an interesting combination of already existing features.

a. Fields of applications

There are many plans which are not detailled to profitcenter, costcenter, employees but are entered e.g. on a company level. Until now, it was necessary to have a “receiving element” e.g. for capacities planning on a company level (= 1 element per company):

It is possible to make the “receiving element” invisible in the tree and make your data entry directly on the sum-level element (whereby the values are still written to the “receiving element”):

b. How it works

In order to implement this behaviour, you use the following features:

• Parallel hierarchy
  To make the “receiving element” invisible in the tree (but it continues to exist in the dimension table).
• Parameter “Planning Level”
  To determine your individuel data entry level, since data entry should not be possible on every sum-level node but only the ones which make sense. In our showcase it is the “company level” from the 2-levels tree.
• DIM001_Alternative definition
  To write the entered value to the “receiving element” which is not visible any more but continues to store the entered values. Therefore the key of the “receiving element” for specific sum-level node must be determinable.
• Parameter “data1_Write_AlwaysOn”
  Set it to the value “2” in order to activate the Write button on your relevant sum-level nodes.

In summary, the “receiving element” is not visible any more but the values now entered on the sum-level are still written on the “receiving element” (which must be known).

(3) Backend: New Audit Table

When you write your data to your fact table, the replaced records are not deleted but only set to “IsDeleted = True”. This makes it possible to recover your data if a planning incident happens.

Until now, we have saved all – current and deleted – records in the one Fact Table. With this release this has changed and data1.io uses two separate tables for the current and another one – the “Audit Table” – for the deleted records. The historical data in your fact table was moved to the new Audit Table.

Therefore, from today on you`ll find in your Fact Table only the currently active records with the flag “IsDeleted = false” …

… and in the new Fact Table Audit you will find all the new and also historically replaced records with the flag “IsDeleted = true”

This is a major change in the data architecture of data1.io since this will solve the issue that the fact table continously grows due to replaced records during the planning process.

(4) Backend: Workbook Filename

With this release, the filename of the uploaded workbook is saved which makes it easier to find out later, which file you are currently using as workbook. Furthermore we have added a comments field, which can be used e.g. to save also the Path where the file came from.

(5) Backend: New Boolean Fact Dimensions

In our standardized data model we have 10 alpha-numeric dimension keys and 10 date keys in order to clearly identify your records in the fact table. Now we have extended our data model by additional 10 boolean dimension keys which can ber used for small, binary dimensions with only two possible states.

a. Fields of application

• booked / non-booked records
• proved / unproved records
• Version 1 / Version 2 records
• and many more

Please be aware that the boolean dimension keys are keys and not fact attributes (like TEXT01, NUM01, etc.) and help you save the 10 alpha-numeric dimensions for more larger “real” dimensions.

b. How it works

Use the new named ranges for the boolean dimension keys:

• data1_CELLS01_BOOL001
• data1_CELLS01_BOOL002
• data1_CELLS01_BOOL003
• data1_CELLS01_BOOL004
• data1_CELLS01_BOOL005
• data1_CELLS01_BOOL006
• data1_CELLS01_BOOL007
• data1_CELLS01_BOOL008
• data1_CELLS01_BOOL009
• data1_CELLS01_BOOL010

Use those values:

• TRUE or 1
• FALSE or 0

You will find the boolean key(s) in your Fact Table:

If you cannot see them, please activate the boolean key(s) in your data model (and define a proper name):

(6) EU Data Act

The EU Data Act (Regulation (EU) 2023/2854) is a central part of the EU’s data strategy, aiming to make access to and use of data fairer, more transparent, and more innovation-friendly.

The EU Data Act entered into force on 11 January 2024, with this date, the regulation formally became part of EU law, but most obligations were not yet applicable. On 12 September 2025 the Data Act became applicable in practice. From this date, the majority of rights and obligations take effect — including user rights to access and share data generated by connected devices, rules on fair contractual terms for SMEs, and obligations for cloud and SaaS providers to enable data portability and switching.

We are proud to be a European SaaS provider and we are very happy to announce that data1.io has long met the requirements of the EU Data Act:

• No risk of blocking
  No hidden costs, no exit fees or no exit conditions
  Export all your data everytime
• Cloud hosting in the EU
• Encrypted storage
• Data protection agreements

Our DNA is complete transparency regarding data export and technical interfaces and no risk of blocking at all. data1.io guarantees full interchangeability, easy switching and full control over your data.

---

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

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

We are happy to deliver the brandnew April 2025 Release with the new Workflow Status functions and the new Capacity Management! 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 Workflow Status functions

a. New Workflow Status change

We are very happy that with this release the Workflow Status of some ore all users that are allocated to a collection workflow can be changed with only 2 clicks:

• Select the relevant users
• Change the workflow status by selecting the status from the new dropdown

Simply acknowledge the dialog …

… and the status of all selected users will be changed at once:

b. New streamlined Workflow Status symbols

Furthermore, we have streamlined the Workflow Status symbols all over the application. Beginning in the Admin Center (see screenshot above) over the Workflow Landing Page …

… and also in the Collector Users frontend, the symbols for the Workflow Status are now everywhere the same:

Just for your information, at this time 4 Workflow Status exist:

• Open (blue)
• Finished (green)
• Paused (orange)
• Waiting (grey)

(2) Admin Center: New Copy Data functions

We have done a lot on the “Copy Data” feature with this release. Please be aware that this feature is an Add-On which needs to be licensed seperately.

a. Copy Data – New “Execute” button in the Admin Center

Due to historical reasons, the Copy Data feature was only accessable via the Frontend but not from the backend. With this release we have changed that and we have added the new “Execute” button directly to the Copy Data job definitions:

Pressing this button will directly open the Copy Data Job definition (where editable parameters cann be edited) and where the Copy Data process can be started with the “Start” button:

b. Copy Data – Clean execution as “long running task”

We are happy, that Copy Data jobs are executed now as so-called “long running tasks”. This prevents you and us from timeout problems with larger jobs. You can see the “in progress” symbol on the Copy Data definition bar as long as the job is running …

… and you will see the “finished” symbol when it is finished. Furthermore you get now the information how many records were created at which time directly on the task bar within the Copy Data definition dialog:

c. Copy Data – Improved user interface

We have improved the user interface for the Copy Data definition.

First, the order of the Copy Data jobs can be changed now by drag and drop. This is very important for larger “Copy Data” processes since jobs often have to executed in a certain order.

Second, the “is Editable” attribute has now the consequence that the “Filter value default” field is only visible as long as this option is activated:

d. Copy Data – Extended definitions

Filters can be defined now also on the Element Type (from the connected Dim001 Table):

Furthermore, you can define now Target Rules also on the TEXTxx Attributes in your fact table and you can define now also the value “(empty)” (which is “null” in SQL) in order to remove e.g. the comments from your source records when you copy them:

e. Copy Data – Increase in price for the Add-On

Due to those major investments we have increased the price from € 20 per month and application to € 30 per month and application. Like always in data1.io, price increases are not applied to customers who already have this license but only to new licenses.

(3) Frontend: Two Add-Ons are core functions now

a. “Iterate Sheet” is a core function now

We have introduced the “Iterate Sheet” function back in January 2023 release and have improved this feature in many of the following releases. Until now this feature could only be used with an extra “Add-On” License. We are happy that with this release the “Iterate Sheet” function is a core function and can be used with every Free Plan or Enterprise Plan.

b. “Calculation Wizard” is a core function now

We have introduced the “Calculation Wizard” back in July 2023 release. Until now this feature could only be used with an extra “Add-On” License. We are happy that with this release the “Calculation Wizard” is a core function and can be used with every Free Plan or Enterprise Plan.

(4) Admin Center: Enterprise Plan menu items

Until now, menu items related with an Enterprise Plan and/or an Add-On license were only visible for Tenant Admins but not for Application Owners. With this release we have changed that and now also Application Owners can use all the advanced menu items in the Admin Center:

(5) Further Improvements

(will be described soon)

We have updated the “Create Account” screen and we have improved the “Onboarding” messages. Furthermore we have solved some bugs with the Copy Data feature, with the conditional formatting in the workbook, with the format of the widget on the collection workflows landing page and with the List Queries.

---

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