Release May 2025

/by

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

    Release April 2025

    /by

    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

    Release March 2025

    /by

    We are happy to deliver the brandnew March 2025 Release with the new Writeback in List Queries 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) Showcase: New List Query Planning

    Until now, planning and data entry was only possible on bottom level elements in the dimension tree (see sheet “Weekly Status” in GIF). From now on, you can enter data also in List Queries which are executed on a sum level element and list one ore more bottom level elements within the workbook. (see sheet “Project List” in GIF):

    This is enabled by the new writeback functionality in list queries and by a major optimization of alternative level queries. Try it yourself in our Public Showcase “Weekly Project Status”.

    Please be aware that at this stage it is not yet possible to enter data on the top level element itself and to splash the entered value to the underlying bottom elements.

    (2) Frontend: New Writeback Functionality in List Queries

    With this release, it is possible to select a sum level element and directly enter data e.g. in a list query on the underlying bottom level elements.

    a. New Option for the “data1_Write_AlwaysOn” parameter

    By default, the Write button is disabled on sum level elements:

    In November 2024 Release we have introduced the new parameter “data1_Write_AlwaysOn“, with this release we added the new status “2”:

    • 0 = normal behaviour
    • 1 = write button will be enabled – only on bottom level elements
    • 2 = write button will be enabled – also on sum level elements

    With the new status “2” …

    … the Write button is enabled also on sum level elements:

    b. Changes for sum level messages, analyze write process and RLS

    Of course we have removed the previous message that data entries are not possible on sum level elements.

    Furthermore we have adopted the “Analyze write process” dialog (Ctrl + right click on dimension tree element) for the writeback of a bundle of elements:

    Last but not least we have also extended the RLS (Row Level Security) functionality in order to validate the RLS rules not only on bottom level elements but also on sum level elements.

    c. Take care of your “SYSTEM Delta” definition!

    The SYSTEM Delta parameter determines which records in the fact table will be replaced when the writeback of new data is executed. With the April 2024 Release we have introduced the new multi-cell “SYSTEM Delta” parameter, the understanding of this feature is essential for the successful usage of the new writeback for list queries.

    The SYSTEM Delta parameter must be defined as a multi-cell parameter – 1 string for every bottom element that is affected by the writeback:

    Please be aware that all existing records in the fact table with one of those 4 SYSTEM Delta strings will be deleted when the Writeback is executed:

    Therefore you have to make sure that the SYSTEM Delta structure in your fact table fits to your data entry sheet!

    (3) Frontend: Major Optimizations for “DIM001 Alternative” Queries

    We have introduced the “DIM001 Alternative” parameter in October 2023 Release and have improved them in the January 2025 Release. With this release we deliver several major optimizations which makes it finally convenient to use list queries planning and data entry sheets.

    • Major performance increase by factor 2x to 4x for the READ process
      This was achieved by a major optimization of the number of the generated SQL queries in the backend.
    • Optimization of Always Encrypted
      There were also issues with the AE feature on the SQL database which could be solved.
    • Shorten the parameter name
      “data1_CELLS0x_DIM001_Alternative_Read_Attribute” to
      “data1_CELLS0x_DIM001_Alternative_Attribute”.

    Remember, the “DIM001 Alternative” ist defined with 2 parameters:

    • data1_CELLS0x_DIM001_Alternative
    • data1_CELLS0x_DIM001_Alternative_Attribute

    The “data1_CELLS0x_DIM001_Alternative” parameter (= blue) replaces the selected element from the dimension tree (= green) with an alternative list of DIM001 elements (which are queried dynamically by a list query):

    The companion parameter “data1_CELLS0x_DIM001_Alternative_Attribute” defines, which Attributes from the dimension tree have to be used for the query of the value:

    (4) Admin Center: Manage Capacities

    We are happy that you can adjust the database capacities of your application / your tenant now with a new self-service screen. With this new tool you can increase your capacities e.g. for a few days if necessary and you can reduce your capacities if your workflow is finished.

    Simply navigate to the new “Manage Capacities” menu item …

    … and change your database capacities with the capacities sliders and press the “Apply” button:

    This change takes a few minutes to be processed. In the “Azure database utilization” chart you can check, if your adjustment really works:

    (5) Frontend: Dimension Tree Reload

    Until now, switching between sheets triggered always a dimension tree reload even if the selected sheet uses the same tree.

    Furthermore, switching to sheets that are not connected to the data1.io application triggered a reload of the dimension tree. Since this is not necessary, we have changed that:

    Furthermore, an empty dimension table led to an endless initial loading process. This will not happen any more, you as a user get a proper message and the loading process will stop.

    (6) Further Improvements

    In the Frontend we have added a feature to execute the visibility settings for rows and columns also on synced sheets. Furthermore we have solved an issue with ListQueries on the “DimType_UID” Attribute (with the parameter data1_LISTQUERY01_T_DIM001_DIMTYPE_UID). And we restored the search box for the dimension tree which was lost for a short time.

    In the Admin Center there were two issues with the refresh of the current page content either after selecting another application in the dropdown or after choosing another entry from the dimension table dropdown. We removed a little bug with the color and icon settings for element types in the dimension tree and another bug when deleting a whole table. Last but not least we solved a resolution bug for the filter box dropdown within the table object.

    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

    Release February 2025

    /by

    We are happy to deliver the brandnew February 2025 Release with the new Workflow Landing Page and many more! 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: New Workflow Landing Page

    Last month we have started to improve the workflow landing page for the collector users with the new workflow grouping. This month we have completed this mission and have streamlined the whole landing page:

    • Application(s) = grey box(es)
    • Workflow(s) = white tile(s)
    • Workbook(s) = orange button(s)

    Remember, until now this landing page was less logically structured and every workbook created a tile which took a lot of space and became confusing with a rising number of workflows and/or workbooks:

    (2) Frontend: New Workflow Info

    We have also added an “i” symbol on the yellow workflow box in the right bottom corner of the frontend and we have redesigned the workflow info dialog with more information than before:

    (3) Frontend: New Read Validation

    We have added a new “Read Validation” to the workbook, additionally to the existing “Write Validation”. The read validation is executed immediately after the READ process while the write validation is executed immediately before the WRITE process.

    The new read validation is useful e.g. for the check of the sum of a list with the overall check value. This will save you from manually checking all single proofs in your report. This is how the new read validation looks like if the condition is not fulfilled:

    The new read validation is defined with the following parameters:

    • data1_Read_Validation
      0 = default = read values ok
      1 = Validation Message will be shown
    • data1_Read_ValidationMessage
      define the text which is shown in the message box
    • Multi Messages with the exension of _1, _2 etc.

    (4) Frontend: New Action Buttons for XLSX Download

    Last month we improved the XLSX download and added the new “Download all tree nodes on bottom level” option:

    With this release, it is now possible to

    • new action
      “Download”
    • new action parameters
      “0” = Download current node
      “1” = Download all tree nodes on all levels
      “2” = Download all tree nodes on bottom level

    (5) Frontend: New Named Ranges for Listqueries

    We have streamlined the named ranges for the definition of Listqueries:

    • old -> data1_CELLS01_DimensionValues_xxx
    • new -> data1_LISTQUERY01_xxx

    Remember, listqueries generate dynamic lists of elements and/or nodes from the dimension tree within the workbook:

    See here the definition of a list query as a set of several parameters:

    (6) Frontend: New Named Ranges for Dynamic Tables

    We have streamlined the named ranges for the definition of dynamic tables:

    • old -> data1_CELLS01_InsertTable_xxx
    • new -> data1_TABLE01_xxx

    Remember, dynamic tables generate a table with the data from one of the dimension tables from your data model:

    See here the definition of a dynamic table as a set of several parameters:

    (7) Frontend: Improved Loading Bar & New Entry in Performance Analyzer

    We have improved the display of the 2 loading bars in the frontend which are now fully synchronized with the real loading processes in the Frontend:

    • Loading bar for the dimension tree
      Executed on the initial loading and when switching between sheets
    • Loading bar for the workbook
      Executed on the initial loading and with every element selection in the dimension tree

    With this improvements, it is easier for you as a power user to observe the 2 influencing factors for the loading performance:

    Furthermore, we have added a new entry type “Load and build the dimension tree …” in the Performance Analyzer which is a very important amendment in order to analyze the real loading performance:

    (8) Further Improvements

    There was an issue with the data1_CELLS01_IsSumLevel parameter which was set automatically to “1” during the initial loading and led to a bumpy display of hidden/visible rows and columns.

    There was another issue with the Action buttons which disappeared under some circumstances.

    We have changed the loading behaviour for listqueries when the parameter data1_LISTQUERY01_T_DIM001_CmdFilter is set to “”. Until now this led to an output list with all elements, from now on this will led to an empty list.

    Furthermore we have improved the READ process with recomposed indizes on the fact table.

    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

    Release January 2025

    /by

    We are happy to be back after the christmas break with the brandnew January 2025 Release with the new XLSX download 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: Improvements for XLSX download

    Firstly, we have added a new option for the XLSX Download – the “Download of all tree nodes on bottom level“:

    This means, that the workbook sheet will be iterated through all (visible) bottom elements of the dimension tree and each node will be exported to a separate XLSX download file:

    Compared with the existing download option “Download all tree nodes on all levels“:

    Secondly, we have streamlined the names of the download files:

    • Application name
    • Element Path name

    (2) Web Client: Improvements for Action Buttons

    We have introduced the Action Buttons last year in March 2024 release and improved this feature in many subsequent releases.

    With this release, firstly we have added two new formatting options for the size and the alignment of the buttons`s title text:

    This is done with two new parameters for the JSON definition of the button:

    • “Font Size In px”: “12px”
    • “Text Alignment”: “Left” / “Center” / “Right”

    Secondly, action buttons also work now with frozen headers which was not supported until now:

    (3) Web Client: Group tiles by workflow

    We have learned that some of our customers use many workbooks which are organized in workflows. Until now, every workbook / workflow combination generated a tile in the “Your active Collection Workflows” landing page for the collector users.

    With this release we are happy to introduce the new grouping for the tiles by workflow… now it is easy to see, which workbooks belong to the same workflow:

    Furthermore we have optimized the vertical padding between the tiles not dependant any more on the screen resolution.

    (4) Web Client: Improvements for Alternative Level Queries

    Alternative Level Queries are a very important feature in order to implement advanced planning solutions in data1.io. Briefly summarised, with Alternative Level Queries you can query values from tree elements different other than the currently selected one.

    We have implemented tht following improvements:

    • Alternative Level Queries are executed now after Listqueries (this had the consequence that the tree element had to be clicked twice in order to get the full values)
    • Alternative Level Queries do not take into account the tree hierarchy any more (this had the consequence that queries e.g. on the top level element did deliver different values of the hierarchy nodes instead of always the same value)
    • Alternative Level Queries interact now also with ExceptionType definitions

    (5) Web App: Improvements for the new Table Object

    In the November 2024 release we have introduced the new Table Object in the data1.io backend.

    With this release we have improved the following features:

    • Empty cells in a column can be selected with the new “(Blanks)” entry
    • Tables with a column name ending with “SORT” are sorted by this column (we had this feature already in former times but it was lost …)
    • Columns width is optimized

    (6) Further Improvements

    We have solved an issue with DATA RANGE queries in combination with ALL Level queries (“%”) … the dates from the data range were converted to a datatime in your timezone which could lead to different results.

    We have improved the Workflow Pause mode (which was introduced in October 2024 Release) with a info dialog when activating and better visible info boxes in the web client for your collector users.

    Tables with a filter dropdown showed the total number of records of this table (without the filter of the dropdown) … this was confusing and we changed that:

    In the Table Object, the column “Is From Upload” was not set to “True” when data was uploaded.

    When uploading data from Excel into a table in the Backend and an error occured, then the mentioned row number in the Excel file was not correct. And there was also an issue with the progress bar which did not disappear after the upload was finished.

    There was an issue with the ODATA API and the new Always Encrypted feature on dimension keys.

    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

    Release November 2024 (before christmas break)

    /by

    We are happy to deliver the brandnew November 2024 release with major improvements on the table webpart 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 App: Improvements for the table webpart

    With this release, our focus is on improving the table webpart of the data1.io backend (“Web App”). This webpart is used in most of the menu items in the backend.

    a) New Table Layout

    The table webpart has been improved in the following areas:

    • New light grey header
    • Grid layout using light grey horicontal and vertical lines
    • Reduction of line height by about 50 %
    • 20 records as default setting

    Compare the new layout …

    … with the previous layout:

    b) New Column Filter Experience

    We have replaced the previous column filter with a modern filter experience:

    • Select the elements from a list of distinct values of this column
    • Sort ascending / descending
    • Clear Filter function
    • Customized Filter … function

    Compare the new filter experience …

    … with the previous filter dialog:

    Of course it is also possible to define customized filters …

    … with this popup dialog:

    c) Single Record View vs. Table View

    We removed the “single record view” from most menu items …

    … and simply show single records in the normal table layout:

    (2) Web Client: New parameter “data1_Write_AlwaysOn”

    You can use this parameter to force the availability of the write button although otherwise the button would be deactivated. E.g. due to the presence of exclusively read-only cells, the presence of exclusively level queries, and so on. This parameter can have two values:

    0 = normal behaviour

    1 = write button will be forced

    Please be aware that the write button is forced only on bottom level elements and within the valid period of the current workflow.

    (3) API: New “Swagger” based REST-API

    Additionally to our existing ODATA API, we deliver now the new Swagger based REST-API: https://data1-service.azurewebsites.net/swagger/ui/index

    This Swagger based REST-API is easier to use than the more technical ODATA API and is relevant for the creation of “Azure Logic Apps”.

    (4) API: New Blogpost “Automatize data1.io with Azure Logic Apps” (in german language)

    Toni Kerschbaummayr, the core developer of data1.io, has written a fantastic blog post on how to use the “Azure Logic Apps” technology to automatize the data loading process in data1.io.

    Get an impression of the solution that automatically loads an Excel based dimension table after every change into your data1.io application:

    If you need help in setting up your own automation with Azure Logic Apps then do not hesitate to contact us!

    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

    Release October 2024

    /by

    We are happy to deliver the brandnew October 2024 release with the new Workflow Maintenance Mode 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: New Workflow Pause Mode

    With the new “Pause Mode” you can pause a running workflow and this way stop a data collection process immediately. Your End Users (“Collector Users”) will not be able to write back new data any more.Use the pause mode if an emergancy case happens during a running data collection workflow.

    a) Pause Mode for End Users (“Collector Users”)

    Your Collector Users can enter a running workflow (status “Open”), entering data and write it back.

    As soon as the workflow will be paused by the Organizer, it is not possible to write back data any more:

    Collector users who enter the workflow after the pause was activated by the Organizer, will see this status “Paused” already on the workflow tile:

    The workbook can be entered, but not read or write process can be executed in pause mode:

    b) Pause Mode for the Power User (“Organizer”)

    The organizer of the workflow can pause a running workflow by simply activating the slider for the pause mode. Furthermore the organizer can define the message that is shown to the collector users:

    A paused workflow is title with the status “Paused” in the workflow overview:

    (2) Web Client: New Realtime Workflow Validation

    Until now, during a running data collection session of a collector users the status of the underlying workflow was not refreshed (the status at the beginning of the session was used during the whole session.

    With the new Pause function we have changed that. At every Write and Read process the status of the workflow is validated before the process itself is executed. As soon as the status of the workflow has changed, no Write or Read process can be executed anymore.

    The same is true if the Organizer of the workflow changes the deadline for the workflow. If the deadline is moved back by the Organizer, the collector users cannot write data any more:

    (3) Web Client: New E-Mail Confirmation for new users

    Until now, the e-mail adress of newly registered users had not to be confirmed. With this release, this has changed.

    If a new user is registered with data1.io …

    … the e-mail adress must be confirmed:

    It is not possible for a newly registered user to login with data1.io as long the e-mail adress is not confirmed:

    The registered user must open the confirmation e-mail and click the link in the e-mail:

    You are directed to the e-mail confirmation page, where you can find also the link to the data1.io login page:

    (4) Web Client: New Performance Analyzer Export / Import

    We have created a new function in the Performance Analyzer (invoked with “Ctrl + Alt + P”) …

    … which exports the content of the performance log into a file (*.data1iopa):

    This file can be submitted the our support (support@data1.io) and our Global Admins can import this file within their own environment in order to analyze the submitted performance log:

    (5) Web Client: Improved Copy & Paste Behaviour

    There was an issue with Copy & Paste of cell ranges on protected cells. Until now it was possible to paste a range of cells (e.g. values from Excel) into the workbook and paste it also over protected cells:

    This has changed now. It is not possible any more to paste a range of cells on protected cells:

    (6) Web Client: Improvements for Copy Data and Action Buttons

    We have done some improvements on the Copy Data feature. First, we have streamlined the Copy Data dialog. Second there was an issue with the calculation of the number of the copied records in applications with encrypted measure columns.

    Furthermore we have also improved the the action buttons. First, sometimes the buttons disappeared after scrolling and leaving / come back to the sheet. Second, there was an issue with the SetCellValue parameter which can be used to control the visibility settings for rows and columns.

    (7) Debugging

    As every month we have done also some 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 #StandWithUkraine

    Release September 2024

    /by

    We are happy to deliver the brandnew September 2024 release with the new Mobile Views 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: Improved Mobile Views

    In April 2023 we delivered the first step of an improved mobile view and with this release we deliver the second step!

    a. Improved Mobile Portrait View

    In portrait view we have

    • added the button titles in the menu bar
    • added the on/off button for the dimension tree
    • replaced the Excel like sheet selection and the horicontal scroll bar by the new sheet selector
    • removed the Feedback/Help buttons at the bottom of the screen

    Tipping the on/off button for the dimension tree turns the dimension tree on or off:

    Tipping on the new sheet selector gives you a “drop up” list of the visible sheets within the workbook:

    b. Improved Mobile Landscape View

    In Landscape View we have

    • lowered the menue bar
    • added the on/off button for the dimension tree
    • focussed the content of the dimension tree – we have removed the application information at the top of the tree and we also have removed the workkflow block at the bottom of the tree
    • replaced the Excel like sheet selection and the horicontal scroll bar by the new sheet selector within the menue bar

    Tipping on the new sheet selector gives you a “drop down” list of the visible sheets within the workbook:

    c. New Unfreeze Function

    Furthermore we have added an unfreeze button which appears if there are frozen rows and/or columns within the selected sheeet. Unfreezing will help your collector users using the sheet also on the mobile phone and on the tablet:

    (2) Web Client: New Copy Data functions (Add-On)

    The Copy Data function duplicates the existing records in the fact table of the selected element and alters e.g. the scenario. It can be used for the following tasks:

    • Freeze the current data status as „Forecast x“ or as a backup (Collector Users)
    • Create a new scenario from the current data status (Power Eser)
    • Create the default values for the upcoming Forecast out of the Budget or the last Forecast (Power User)

    This function is basically designed to be used by the Collector Users (= End Users), but it can also be configured to be used only by Power Users.

    The Copy Data feature was released in January 2024 and improved in February 2024 and June 2024. With this release another major update is delivered for this feature.

    a. New Definition Structure

    Until now, a target rule could only be defined together with one filter condition. This was a major restriction that we have removed now with this release. From now on, the target rules are defined independently from the filter conditions:

    b. New Target Rules

    Furthermore we have added two new major types of target rules: Date rules and Measure rules.

    With a Date rule the values of a date column in the duplicated fact records can be altered to another period of time. E.g. you can move the period of time by + 1 month:

    With a Measure rule the values of a measure column in the duplicated fact records can be altered to another value. E.g. you can increase all values by + 4,00 %:

    (3) Web Client: New Aggregated % Queries on Date Keys

    Until now, aggregated queries within the date dimensions could only be executed with the YEAR, QUARTER and MONTH keywords:

    With this release you can use also the % asterisk for the date dimension in order to query the total of the whole period:

    (4) Web Client: Performance Improvement for Always Encrypted

    In July 2024 release we delivered the Always Encrypted feature for the dimension keys as the new standard. We are happy that we also could improve the performance of the “old” encryption of the measure fields by using a group by index which enables buffering and batch processing of the requested data.

    The performance gain is the largest in reports which aggregate (“group by”) the data in one or more dimensions and can be up to 400 %.

    (5) Showcase: Comments on aggregated account levels

    In May 2024 release we have introduced the new multiple layouts with the new CELLS01/CELLS02 definitions. With this release we deliver a demo for the collection of comments on an aggregated account level.

    Look at the EBIT Planning in our public showcase Integrated P&L Planning. The collection of comments was implemented on the bottom accont level (which can be done very easily in data1.io):

    With a separate CELLS02 definition the comments can be collected also on an aggregated account level (e.g. subtotal lines):

    (6) 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 #StandWithUkraine

    Release July 2024 (before the summer break)

    /by

    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

    Release June 2024

    /by

    We are happy to deliver the brandnew June 2024 release with the new spreadsheet options and a new always encrypted mode 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: New Spreadsheet Options (only for Power Users)

    We have a new feature for Power Users! If you are either in the role of an “Tenant admin” or an “Application owner” then you’ll see the new Spreadsheet Options command in the context menue of the spreadsheet if you have pressed also “Ctrl”:

    … which enables you to configure the new Spreadsheet Options:

    • Unhide all rows and columns
    • Page Layout Settings (Gridlines)
    • Formula calculation and Error Checking
    • Unprotect Sheet or Workbook
    • View Settings (Formula Bar, Named Ranges, Frozen Panes, Headers)

    Using e.g. the Unhide function will shou you – as a power user – all hidden rows and columns:

    (2) Web Client: Always Encrypted on Dimension Keys (Preview)

    Until now, it was only possible to apply the Always Encrypted function only on numeric fields like “Measure01”.

    Unfortunately this costs a lot of performance in the Web Client and makes any READ process much slower. Therefore we make it possible now, the encrypt the Dimension Keys and not the numeric fields. This encryption is applied to the fact table …

    … as well as on the key fields in the dimension tables:

    This brings also some restriction like reduced filter options on these fields and the sorting is not possible. But we are optimistic that this change can bring huge performance gains. If you are interested in (temporarely) change the encryption on your application and test the new possibilities, please contact us.

    (3) Web Client: Calculated Columns for Dynamic Tables

    With this release, it is also possible to use calculated columns on your dynamic tables – they are kept and calculated after the refresh of the dynamic table:

    (4) Web Client: Simplified Definition for By Column Mapping

    We have simplified the definition for the data1_CELLS01_ByColumnMapping parameter: until now you had to write “data1_CELLS01_MEASURE_0” and so on …

    … from now on you can leave the “data1_CELLS01_” prefix and simply write “MEASURE01_0” (which is the target column and the relative record number):

    Please note that the previous syntax is also continued, so you do not need to update your existing workbooks.

    (5) Web Client: New Parameter “data1_IsWriting”

    We have created a new parameter “data1_IsWriting” which has 2 parameters:

    • 0 = no Write process is executed
    • 1 = Write process is executed

    You can use this parameter e.g. to set alternative dimension keys for the write process other than for the read process. This parameter is derived from all CELLS0x areas.

    (6) Web Client: Date Ranges for Copy Data Processes (Add-On)

    We have created the possibility to define data ranges as filters for Copy Data processes:

    (7) Debugging and Improvements

    We have improved the CELLS02 feature, which was introduced with the May 2024 release. There was an issue with the WRITE process if the CELLS02 area didn`t have any write activated cells, another issue with Date-Ranges during the READ process and an issue with DATE01_Level definitions.

    There was an issue with the record set structure in combination with CELLS02 and SysDelta definitions.

    We have also improved the initial refresh for dynamic tables, which was also introduced with the May 2024 release. Before the initial refresh is executed the top element from the dimension tree is loaded into the sheet with the dynamic table since this is often used as filter criteria for the dynamic table.

    There were two issues with the Iterate Sheet function which are solved now.

    Furthermore we solved an issue with DIM001_Alternative Keys which resulted in a very poor READ performance. Another issue could be solved with poor performance for emptying cells during the READ process under certain conditions.

    There was also an issue with the check for the activation/deactivation of the WRITE button which led to poor performance during data entry in the workbook and/or when scrolling the workbook.

    In combination with the new Action Buttons the dialog for unsaved data was not shown, 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