Release March 2025

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