Release June 2022

We are happy to deliver the brandnew June 2022 release with the next level “HR Contracts” showcase which is enabled by many new features! 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.Web App.

(1) Next Level “HR Contracts” Showcase

We have upgraded our showcase “HR Contracts” massively this month!

You`ll find a new data entry sheet “HR New Hires” with a dimension tree that is filtered to the elementtypes corresponding with that data entry sheet:

The existing data entry sheet “HR Contracts” has got a dimension tree filter as well to show only those bottom elements in the tree which make sense in this data entry context:

Furthermore we have improved the HR List Report (based on the Dynamic Table sheet), you will see that further down.

(2) Web Client: New Treefilter

The filtered tree that you can see in the showcase screenshots above is implemented with this new parameter

  • data1_TreeFilter

The syntax for the filter statement is very similar to the WHERE clause of SQL queries. If you filter on element types, then please mind that you have to use the UID number of the element type:

(3) Web Client: New Refresh-Event on Sheet Change

We introduce another

  • data1_ReadOnSheetChanged
    0 = nothing happens when selecting the sheet
    1 = Refresh when selecting the sheet

Simply add this new parameter to every page of your multi-sheet application …

… and the sheet will be refreshed when you select a certain sheet of your workbook:

This is important to make sure to see the current data from the database in the sheet.

(4) Web Client: Element Types also on Sum Levels

Last month we introduced the new element types and the new parameter which writes the element type from the selected element into the workbook:

  • data1_CELLS01_DIM001_Type

With this release, this parameter delivers now also on all sum levels the element type of the first found bottom element below the selected sum element:

(5) Web Client: Dynamic Tables Sorting

With this release, the sorting of dynamic tables is not randomly anymore:

You can see the sorting in the sheet “(Dynamic Tables)”. By default a dynamic table is sorted now by the field DIM001.SORT the same way as the dimension tree is sorted:

Furthermore you can define a custom sort order in MS Excel (before you upload the file into your data1.io application):

(6) Web Client: Dynamic Tables Performance Improvement

We have improved the READ performance of dynamic tables by a factor of about 50 %. This was possible since in the background the data entry validitiy rules for the table were loaded and this is not necessary for dynamic tables in the spreadsheet.

(7) Web Client: Dynamic Tables in Performance Analyzer

We have added the READ process for dynamic tables to the Performance Analyzer (launch with Ctrl + Alt + P). This way it is easy to evaluate the impact of a dynamic table to the READ performance of your application:

(8) Web Client: Admin Widget on the Application Tile

As a Power User you can use the link Your active collections

… to get to your active collections. If you are at the same time Collector User for external applications, it is now very clear which applications are your own since the application tiles are marked with an Admin widget:

(9) Web App: New Workbook Preview Experience

We are happy that we have improved the Workbook Preview experience …

… by removing all RLS and Workflow settings from this preview:

This was very tedious until now, since you had to setup a valid workflow definition (validity period and allocation to the workbook) and a valid RLS definition just to be able to preview your workbook. Especially when you setup your own application the first time this is much clearer now and easier to understand than before.

(10) Technical Improvements and Debugging

We removed a bug that multiplied the application number of tiles on the applications landing page and furthermore we removed another bug concerning %-Level aggregations.


Hope you like the new features – we are very curious about your feedback! Please let us know what you think and what kind of collection processes you would prefer to automate with data1.io. 

Stay healthy and we #StandWithUkraine

Release May 2022

We are happy to deliver the brandnew May 2022 release with the new element types for a more powerful user experience! 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.Web App.

(1) Web Client: New Element Types

At first sight, element types help you to structure the bottom level of your dimension tree with symbols:

As a Power user you can easily define as many element types as you like just by clicking the Add new button in the new Element Types section …

… and just defining a type name, an icon and an icon color:

Now you can allocate your dimenson tree elements to one of the defined element types:

If you decide not to use element types then you will see a “(default)” entry on every element not allocated to an element type:

(2) Web Client: New Parameter for Element Types

More important than the symbol in the tree is the possibility to define specific data entry workflows to each element type. For this reason we introduce the new parameter

  • data1_CELLS01_DIM001_Type

With this parameter you can control e.g. the visibility settings of the sheets:

Please be aware that this parameter delivers at this time a null / blank when selecting a sum-level element in the dimension tree.

(3) Web Client: New Attributes for the Fact Table

We have massively extended our data model with new attributes for the Fact Table:

  • 20 instead of 10 text attributes
  • 20 new date attributes
  • 20 new numeric attributes

Look at the Cost & Invest Public Showcase. Until now the date and the numeric information …

… had to be stored on one of the 10 text attribute fields:

Now it is possible to allocate this kind of information to the DATE or NUM attributes of the fact table:

This means that the data from the spreadsheet is stored in a proper format in the fact table:

This is important because it is now possible to do proper calculations with those information in the spreadsheet.

(4) Web Client: Changes in Multi-Sheet Workbooks

We have observed that the multi-sheet behaviour was not fully clean.

Until now, when you selected an element in the dimension tree, then ALL sheets where switched to this element and only those were READ which were defined in the SyncSheets_Read Parameter. Now we have changed that so that only those sheets are switched to the selected element which are defined in the SyncSheets_Read Parameter of the activated sheet. This means that in all sheets which are not part of the SyncSheets_Read definition NOTHING happens when selecting a new element in the dimension tree.

If you use this feature please check the behaviour of your workbooks when selecting elements and when changing the data entry sheet.

(5) Showcase: Update for HR Contracts

We have extended the showcase for HR Contracts …

… with a new display area for master data for the selected employee:

This feature is realized with a Dynamic Table in the background – for demonstration reasons we let the sheet with the Dynamic Table visible.

(6) Showcase: Update for Cost & Invest

We have extended the showcase for Cost and Invest …

… mainly by translating the whole showcase from German into English language:

Furthermore we have added dropdowns for the Invest- and Real Estate Planning sheets and the date and numeric master data is now allocated to the new date and numeric attributes in the fact table (this way calculations with this information will be possible in a future update).

(7) Help Center: New Content

We really happy that we have (mostly) solved an issue of the past: we have massively extended your Help Center with a lot of new content. You can find now nearly everything about defining your own application …

… and setting up your individual workbooks as data1.io Web Client:

(8) Technical Improvements and Debugging

We had some issues with the entry of dates on the new date attributes in the fact table. The language settings were sometimes confused and dates had to entered in US format although shown in a GERMAN format in the spreadsheet itself (and vice versa).

Furthermore we solved an issue when the query for a dynamic table failed under specific circumstances.

Last but not least there was an issue with the landing page in the Web App for users after they create their first own application.


Hope you like the new features – we are very curious about your feedback! Please let us know what you think and what kind of collection processes you would prefer to automate with data1.io. 

Stay healthy and we #StandWithUkraine

Release April 2022

We are happy to deliver the brandnew April 2022 release with the new User Interface for Excel workbooks. 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.Web App:

(1) Web App: New “Manage Workbooks” UI

We are happy to relaunch the Workbooks section in the Web App! You will find a new compact User Interface (UI) which is mainly represented by the new workbook list in the “Manage Workbooks” tab which directly lets you start either the Preview of the workbook …

… or lets you edit, add or delete the workbooks master data and lets you upload your local Excel Files as workbook for the Web Client:

For comparison check here the old user interface:

(2) Web App: New Workbook Preview UI

The preview for the workbook is now integrated into the “Manage Workbooks” tab. By clicking the new Preview button you get directly into the preview mode – this is much faster than in our user interface to date:

For comparison check here the old user interface:

(3) Web App: New Workbook Wizard UI

The Workbook Wizard is now also integrated into the “Manage Workbooks” tab. In the new UI it is only possible to enter the Wizard for workbooks which do not have an uploaded Excel file – this is more intuitive and logical:

For comparison check here the old user interface:

(4) Showcase “Weekly Project Status”: new dynamic list report

In the June 2021 Release we presented the new dynamic list reports based on the new list form for the “data1_CELLS01_DIM001” parameter. At that time this was demonstrated in a private showcase, now we added the feature to the Public Showcase “Weekly Project Status”:

(5) Dynamic List Reports: activation for any record granularity

This upgrade for the public showcase was possible now since the inital feature for the list form of the “data1_CELLS01_DIM001” parameter did not work with every form of record granularity. This public showcase uses a special record structure since it has to be compatible with a Power Apps application which is also used to add and edit the same data. With this release the list form of the “data1_CELLS01_DIM001” parameter is compatible with every recordset structure:

(6) Technical improvements and debugging

We have debugged an issue with the edit function for the dimension tree, the menu was shown on the wrong level in special cases. Furthermore we have improved the behaviour for highlighting changed cells, the initial functionality was not fully matured.

(7) Discontinued Feature: Excel Client (Javascript Add-In)

Until the beginning of 2020 the Excel Client – based on an innovative Javascript Add-In – was the only user interface for the collector users. Due to continuing heavy technical restrictions with the Excel Client (esp. in conjunction with Excel Online) we decided then to develop a new fully browser based client. In the meantime this “Web Client” has fully replaced the older “Excel Client”. So we have decided to officially discontinue this feature since it would bind to many ressource to keep it on the same level as the Web Client.

Therefore we removed the navigation item “Excel Client” from the user interface of the Web App:


Hope you like the new features – we are very curious about your feedback! Please let us know what you think and what kind of collection processes you would prefer to automate with data1.io. 

Stay healthy and we #StandWithUkraine

Release March 2022

We are happy to deliver the brandnew March 2022 release with new showcases and new features for filter tables. 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) New showcase “S&OP Demand Planning”

We are happy that we can present now our showcase #8, the new “S&OP Demand Planning”:

This showcase uses a dynamic definition table with the individual combination “customers – products”:

Selecting another customer of course changes the list of products for this customer:

Please be aware that at this stage this showcase has only a few demo data, we will upgrade this showcase with the next month releases.

(2) Improved showcase “HR Contract”

The “HR Contracts” showcase one our first showcases …

… so we decided to add a new dynamic list report with all the employees and their annual planning values:

Remember, the dynamic list reports feature was introduced with the July 2021 release. Of course the list report is dynamically requeried when selecting another item from the dimension tree:

(3) Filter Tables: new filter path parameter

For this new showcase we developed a new filter path parameter which is essential in application with “same name elements” in the dimension tree. If you retrieved a dynamic filter table until now …

… with focus on an ambiguous element in the dimension tree the table delivered all the bottom level elements from all subnodes with the same name:

To solve this we introduce a new parameter:

  • data1_CELLS01_DIM001_Key_Path

This field is filled with every click in the dimension with the full “SQL Where” path which can be used directly as filter criteria for the dynamic filter table:

(4) Filter Tables: new RLS option

Another important issue is the application of Row-Level-Security to dynamic filter tables. Until now, this was not possible and therefore filter tables delivered always the full list of elements independently of the RLS rules:

With this release we introduce the new parameter

  • data1_CELLS01_InsertTable_ForceRLS

which can be set to “0” (= default, no RLS) or to “1” (= RLS is applied to the filter table):

We intend to make the “Force RLS” feature to the new default with a later release.

(5) Web App: new “Is Visible” field

In some cases you need to keep an element in the dimension tree (e.g. for historical data) but you do not want to show the element in the dimension tree anymore. For this reason we added the new “Is Visible” definition field to all dimension tables. Setting an element to “false” …

… will remove this item from the dimension tree:

(6) Web App: new subscription form

With the September 2021 release we introduced the new UI forms for workflows and for the company data. With this release we deliver now also the Subscriptions with the new UI element. Since a company can have several subscriptions you`ll see at first the overview list with all active subscriptions …

… and clicking on one element of the list will open the form:

Please be aware that at this time the subscriptions cannot be edited by yourself (i.e. all the fields are read-only).


Hope you like the new features – we are very curious about your feedback! Please let us know what you think and what kind of collection processes you would prefer to automate with data1.io. 

Stay healthy and we #StandWithUkraine

Release February 2022

We are happy to deliver the brandnew Februar 2022 release with the new Performance Analyzer 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 Performance Analyzer

We learned that a weak performance in the Web Client can have different causes. One reason is a poor SQL performance, another one is a poor performance of the client device itself. For this reason we have developed the new Performance Analyzer to give our users a tool to analyze by themselves directly on the point of interest.

Just execute a READ or a WRITE process …

… and press

  • CTRL + ALT + P

and you will geht a popup with the Performance Analyzer:

Just expand the symbol on the left to get a pie chart with the SQL share on total performance:

Expand further to get the details about the single steps of the process:

(2) Web Client: New highlighting for updated cells

We are happy about this new feature to highlight cells that were updated and not saved yet:

To activate it define a named range for a single cell:

  • data1_CELLS01_ChangedCellFormat

Now format the cell to your taste – that`s all!

Please keep in mind that all data1.io named ranges in the workbook have to be defined on sheet level and not on workbook level.

(3) Web Client: New easy setup for new record definition mode

We introduced the new “record definition mode (by column)” in November 2021 and updated it in January 2022.

Now we are happy to be able to deliver an “easy setup” since the definition was a little bit complicated …

… from now on you can use the following wildcards instead of the recordset numbers:

  • Definition *
    The content of the column will be added to all records of the respective row in the spreadsheet (horicontal definition).
    The content of the row will be added to all records of the respective column in the spreadsheet (vertical definition).
  • Definition + or –
    The content of the column / row will generate a recordset on its own

Just remember: the new record definiton mode enables to append base data (blue frame) to the records with the figures …

… as can be seen here in the fact table:

(4) Web App: New merge fields for multi-workbook applications

We have introduced the Multi-Workbook feature back in April 2021 and the Multi-Workflow feature back in June 2021. We introduced the merge field {WEBAPP.WORKFLOW.URL} in November 2021 to make a multi-workflow accessable via a link.

Now it is time to deliver 4 new merge fields to adress a specific workbook in a multi-workbook environment:

  • {WEBAPP.WORKBOOK.SORT.01.URL}
  • {WEBAPP.WORKBOOK.SORT.01.NAME}
  • {WEBAPP.WORKBOOK.UID.01.URL}
  • {WEBAPP.WORKBOOK.UID.01.NAME}

They differ the following:

  • URL generates the name of the workbook as a clickable link
  • NAME generates the name of the workbook only as a text

The SORT.01 means that you want to adress the first workbook in the relative order of workbooks within your application. UID.01 means that you want to adress the workbook with this absolute UID.

Look at this demonstration in the above shown multi-workbook environment …

… all 4 merge fields deliver the Workbook name “Workbook Actuals”, 2 of them as a clickable link:

(5) Web App: New Streaming for XLSX-/CSV-downloads

There was an issue when downloading a larger amount of data from a (fact) table in the Web App, since the download could stopped with an error message.

With the new streaming implementation, the download of the records into an .xlsx or .csv es executed piece by piece. This also saves memory usage (e.g. 0,5 GB instead of 1,5 GB for downloading 65.000 records).

(6) Public Showcases: Dynamic table demo

We have introduced the dynamic table feature in the July 2021 Release, now we have added the demo to the “Weekly Project Status” Public Showcase:

You` ll find the demo in the second sheet called Dynamic Table. Please note that the two sheets are not synced, therefore the read processes are triggered independantely from each other.


Hope you like the new features – we are very curious about your feedback! Please let us know what you think and what kind of collection processes you would prefer to automate with data1.io. 

And: stay healthy!

Release January 2022

We are happy to deliver the brandnew January 2022 release with the Extended Showcase “Cost & Invest” 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) Showcase Cost & Invest: new “Invest Planning” sheet

We have created a new sheet called “Investitionen” which is intended for invest planning. So it`s new in this showcase that you as a user can plan 2 different contents (with the 2 sheets) on the some costcenter elements. The new sheet provides a – in data1.io Showcases totally new – structure of data entry: additonally to the numbers several master data can / have to be entered per row.

The main isssue in this showcase is to create the records in the fact table this way that the master data is stored on every record with the numbers (and not as seperate master data records). This is enabled by the “New Record Definitions” which was introduced in November 2021 Release:

Just to rembember: the cost planning did in the first sheet did not change.

(2) Showcase Cost & Invest: old/new “Object Planning” sheet

For those of you who are asking what happened to the “old” invest planning: we repurposed it to an “Object Planning”. The data entry sheet was streamlined and the elements in the dimension tree are named now “Objekt xx”. Please remember that this showcase demonstrates how to activate a specific data entry sheet for defined element (types).

(3) Web Client: New “vertical” record definition mode

The interesting thing of this “Object Planning” sheet is that with this release the “New Record Definitions” (from the November 2021 Release) are now also available in a vertical format:

The consequence of this definition is – again – that the master data is merged on every recordset with a measure:

Please note that at this stage the master data is only merged on the measure recordsets from the first column in the workbook (see above).

(4) Web Client: New progress screen

When opening a workbook as a collector user, you`ll see now a nice progress screen while loading the workbook and reading the values of the first element from the dimension tree:

(5) Web Client: Single click

You can not see it on the screenshot but you will notice immediately if you use the web client: from now on a single click in the dimension tree is sufficient to trigger the “switch” to another element. Therefore, the previous double click is not necessary any more.

(6) Web App: Download tables as XLSX as new default

Until now when downloading a table a CSV was generated. From now on XLSX will be generated by default:

The CSV download has moved to the small dropdown right to the download button:

(7) Web App: Upload Workbooks as XLSM

From now on you can also upload XLSM Files. Please note that Macros and VBA Code can NOT be executed in the Web Client. But: you can use macros and VBA in your Excel file to prepare the workbook offline and then directly upload the XLSM without having to execute an additional “save as”:

Here is the full list of supported files formats:

  • .xls
  • .xlt
  • .xlsx
  • .xlsm
  • .xltm
  • .xltx

Hope you like the new features – we are very curious about your feedback! Please let us know what you think and what kind of collection processes you would prefer to automate with data1.io. 

And: stay healthy!

Release November 2021 (before the winter break)

We are happy to deliver the brandnew November 2021 release with the new Record Definition Mode and many more new features . 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 record definitions (for the “by Column Mode”)

Until now, these 4 entries in the Cost & Invest Public Showcase

… were saved into the fact table as 4 records:

The new record definition (in the “by column mode”) consists of 2 components:

  • The existing definition “data1_CELLS01_ByColumnMapping” (here row 6) is upgraded with a record definition -> these are the digits after the last underscore of the text in the definition fields. For instance “_10” means that the October values are saved on the 10th record that is created when writing back a row.
  • The new definition “data1_CELLS01_ByColumnMapping_Records” (here row 7) defines on which records the value from that column should be written. “1,2,3,4,5,6,7,8,9,10,11,12,13,14,15” means that the comment should be written on all records of this row.

These definitions force the system to save the comment on the 3 records with the values (without an additional 4th record only for the comment):

On the one hand, this makes analysis – e.g. in Power BI – much easier and on the other hand this makes possible to save master data directly on the measure records. We will show further fields of applications in the next releases.

(2) Web Client: Clear all fields

Until now, it was not possible to remove all the data from an element because the write process was not started when the data entry area was empty. From now on Collector Users can …

… remove all the data from the spreadsheet and press the Write button, this will remove the data also from the database:

(3) Web Client: Another Performance improvement

We are happy that we have solved another performance bottleneck for the READ process (after we have solve already one in the September 2021 Release). data1.io creates now an additonal index consisting of all dimension keys which can improve the READ performance by the factor 2.5!

(4) Web App: New Merge Field

We have introduced the new Multi-Workflow Feature back in June. Now it is time to extend also the set of merge fields for the workflow e-mails with a new one:

  • {WEBAPP.WORKFLOW.URL}

This new merge field …

… creates a hyperlink in the workflow e-mail which …

… directly leads to a filtered version of the Collection Workflows landing page:

The landing page is filtered to the relevant application (here “Weekly Project Status”) and the workflow from the e-mail is highlighted (here “PM Weekly Actuals”). This way, your collector users get the overview of all running workflows and see which workflow is the most relevant one.

(5) New Blogpost “Power BI Custom Visual” (in German)

In the October 2021 release we have introduced the new “Gen2” Custom Visual for Power BI, now we have written also a blog post with many details about the custom visual. See the custom visual in action here:

Please be clear that the Power BI custom visual can be used as an alternative client to the Web Client – this gives you more options for your planning and data collection workflows:

To the blog post:

https://linearis.at/blog/2021/11/26/datenerfassung-in-power-bi-teil-3-custom-visual/

(7) New Blogpost “Power Apps Demo” (in German)

We have introduced Power Apps as another alternative client already in the March 2021 release. Now we show how to make the user interface more attractive and use the Power Apps application via the Power Apps visual directly in a Power BI Report:

To the blog post:

https://linearis.at/blog/2021/11/17/datenerfassung-in-power-bi-teil-2-power-apps-visual/

(8) Technical improvements and debugging

We have solved an issue with the “comment marker” in the corner of the cells, this was placed on the wrong position if the zoom factor was <> 100 %.

Further, we have improved the technical execution of the SQL Transaction for the writeback: the processes for setting the existing records on “deleted” and the process for inserting the new records are now always executed either together or none of the two is executed.

Finally we have removed a bug leading to a wrong aggregated “Level” calculation (using the “%” placeholder) in combination withc “comment” records.


Hope you like the new features – we are very curious about your feedback! Please let us know what you think and what kind of collection processes you would prefer to automate with data1.io. 

We`ll be back after the christmas break with the January Release!

And: stay healthy!

Release October 2021

We are happy to deliver the brandnew October 2021 release with the next version of the Power BI Custom Visual . 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) Power BI: New Custom Visual (Gen2)

In the May 2021 release we introduced the first version of our Power BI Custom Visual (which was a prototype):

Now, we invested for the next generation of this visual to make it not only more beautiful but also more powerful:

  • Measure and text as columns
  • Multi-Project editing at once
  • Filter not only for projects but also for dates
  • Free configuration of the data1.io ODATA parameters in the settings of the visual

Just edit the values and texts in the custom visual and immediately see the aggregation in the Power BI charts and tables (by using a Direct Query datamodel with automatic Change Detection):

Sure, you can use the Power BI Custom Visual and the data1.io Web Client in parallel, both clients show the same values from the data1.io application (of course):

Please be aware that also this Gen2 visual is a proof-of-concept and not part of the data1.io production environment. If you are interested in usimg this technology for your company please feel free to contact us!

(2) Web App: New Design for the Public Showcases Page

We are happy to present our new Public Showcases landing page which is more compact and up-to-date:

Just for comparison, this was our old page:

(3) Web App: New Hide/Unhide for the Navigation Pane

Analyzing or editing wide tables needs more space – therefore we have implemented the new hide/unhide function in order to expand or collapse the navigation pane:

Here we go:

(4) Web Client: Improvements for the Showcase “Weekly Project Status”

Due to the the Power BI Custom Visual as well as due to our tests with Power Apps we decided to streamline the anyway small showcase for “Weekly Project Status”:

Furthermore we changed the record structure for this showcase “from vertical to horicontal”, i.e. several values and texts are now stored on the same record in the fact table:

(5) Web Client: Improved query for same name level elements

Formerly there was a problem with elements on the same level with the same name: the data1.io query engine summed up all values with this element name but took not into account the branch of the dimension tree. Now we have changed that and the query engine retrieves the aggregations for an element by querying also the above levels of the element.

This way, two “Team 1” elements on the same level of the dimension tree get the right aggregated values on both elements:

For the sake of completeness: this feature was already implemented in May 2021 but not communicated until now.

(6) Web App: Improved sort & filter for text fields in large tables

With the May 2021 release we introduced the new paging mechanism for large tables (> 1000 records). One remaining issue was sorting & filtering for text fields in such tables, which was only applied to the 1000 records in the current page. This is solved now so that filters and sort commands are applied in the backend to the whole table:

For the sake of completeness: this feature was already implemented in May 2021 but not communicated until now.

(7) Technical improvements and debugging

We had an issue when uploading data into the fact table which contain empty strings (“”) instead of null in the dimension key fields. As a consequence the values of such records could not be shown in the workbook, this is solved now.

Furthermore we improved the READ performance in multi-sheet workbooks, since we found out that the recalculation was done for every sheet although once for all does the same job in much less time.

Finally, records with empty date fields in the fact table caused an error when the table was downloaded, this is solved now as well.

(8) SQL Days 2021 “Power BI and Data Entry” (in German)

Two weeks ago I had a session at the SQL Days 2021 in Munich (Germany) called “Power BI and Data Entry”:

I used data1.io as “SQL based planning engine” to show how a Direct Query application in Power BI has to be setup and how Power Apps and Power BI Custom Visual can be used as alternative frontends to Excel:

Find more information here (in german language):

https://linearis.at/blog/2021/10/29/session-power-bi-und-datenerfassung-bei-den-sql-days-2021/

(9) Supplement license information

We added a supplementary row to our pricing page in order to make clear that the Free Plan as well as the Enterprise Plans have limits concerning number of records and the resulting READ performance. So, there is not a limit for the number of records but the READ performance will go down the more records you will put into the fact table of your data1.io application:

The solution for larger application is “calculation power” in the form of additional DTUs (see bottom right).


Hope you like the new features – we are very curious about your feedback! Please let us know what you think and what kind of collection processes you would prefer to automate with data1.io. 

And: stay healthy!

Release September 2021

We are happy to deliver the brandnew September 2021 release with the new dynamic list reports! 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: New workflow timeline overview

We are really proud to present the new workflow timeline overview. You’ll see all your defined workflows in a graphical timeline visualization with a vertical bar for “Today”. This way it is very easy to see which workflows run at the same time and how long they will run.

For comparison, until now we only had this (very unintuitive) table based view on the workflows:

(2) Web App: New workflow editor

Embedded in the new timeline overview you’ll find the new editor for your workflows. You can change here start end date both visually by pulling the slider or by selecting the date from the data picker:

The form is structured into topics which makes the definition of a workflow much more intuitive than before:

For comparison, this was our data entry form for workflows until now:

(3) Web App: New UI form

We have developed a new “standard form” for entering the organizational data in your tenant. This form looks “quite normal” as you probably are used to from other cloud services.

For comparison, our “table based form” was not really suitable for this kind of data:

This was a simple solution for the start of your system but now we replace it with the new intuitive form. We plan to roll out this new form to more topics within the next months.

(4) Web App: New UI elements

With the new workflow editor and the new UI form we have streamlined and modernized the look & feel of the whole data1.io Web App.

Compare the new record editor …

… with the old one:

And compare the new login form …

… with the old one.

We will continue this process of modernizing the UI within the next months in order to bring the user experience of our Web App to the next level.

(5) Web Client: Performance improvement for the READ process

In workbooks with many cells activated for the data1.io READ process (named range “”data1_CELLS01) we had a performance issue since the check which cells in this area exactly have to be cleared (as part of the READ process) took a long time in this case. We have solved this issue and the READ process gained a huge performance win in this applications.


Hope you like the new features – we are very curious about your feedback! Please let us know what you think and what kind of collection processes you would prefer to automate with data1.io. 

And: stay healthy!

Release July 2021 (before the summer break)

We are happy to deliver the brandnew July 2021 release with the new dynamic list reports! 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 dynamic list reports

Until now, it was only possible to show aggregated values on the aggregated levels of the dimension tree:

With this release you can create reports like this which show the elements from the dimension tree in the report itself:

Of course, those reports can be filtered dynamically by double clicking in the dimension tree:

This new type of report uses the following new features:

  • New filter tables
  • New “data1_CELLS01_DIM001_Attribute” parameter
  • New list form for the “data1_CELLS01_DIM001” parameter

(2) Web Client: New filter tables

With this release you can query all dimension tables from your datamodel simply by using the following named range:

  • data1_CELLS01_InsertTable_T_DIMxxx

After the READ process has been executed …

… an Excel table with the dimension data is inserted starting at the defined cell:

Furthermore, you can add an filter condition which has to be written in the syntax of an “SQL where clause” using the following named range:

  • data1_CELLS01_InsertTable_T_DIMxxx_Filter

Please note that there a several restrictions at the moment:

  • Row Level Security (RLS) is NOT applied as filter
  • The filter table is read only (it is NOT possible to write changes back to the datamodel)

(3) Web Client: New “data1_CELLS01_DIM001_Attribute” parameter

There is only 1 thing missing to link the table to the selected element from the dimension tree: the name of the field from the selected element in the dimension tree. You can query this information now with this new named range:

  • data1_CELLS01_DIM001_Attribute

You can combine now the selected element with the attribute behind it in order to define a dynamic filter statement for the table:

Selecting another element from the dimension tree triggers a new query of the dynamic table and you get a new filtered table:

(4) Web Client: New list form for the “data1_CELLS01_DIM001” parameter

Until now, the parameter “data1_CELLS01_DIM001” had to be a single cell. With this release, you can define this parameter as a horicontal or vertical range. Double clicking an element in the dimension tree will transfer the name of the selected element to the first cell of the named range and the other cells from the named range will also be used as filter parameter for the query of the values in the cells area:

The same is true for the new parameter ” data1_CELLS01_DIM001_Attribute”:

Finally, you can connect the cells area with the READ/WRITE interaction with the dynamic filter table e.g. by using the INDEX() formula in order to get the elements from the filter table in relative order into the cells area:

Please note that there a several restrictions:

  • At the moment only the Measure fields and NOT the Text fields are retrievable
  • At the moment those sheets are read only (so it is NOT possible to write back data entries)

(5) Web Client: New vertical ByColumnMapping definition

The next feature has nothing to with the new dynamic list reports. Until now, the named range “data1_CELLS01_ByColumnMapping” could only be used in a horicontal list form

… with this release you can use this definition also in vertical list form which makes many more usecases realizable:

(6) Web Client: New Exception Type 0

Exception types overrule the definition from R/W control panel. This is useful if you have rows or columns which are partly relevant for the Read/Write process and partly not:

  • data1_CELLS01_ExceptionType0

Please note that the other exception types (1 to 4) were already available.


Hope you like the new features – we are very curious about your feedback! Please let us know what you think and what kind of collection processes you would prefer to automate with data1.io. 

We`ll be back after the summer break with the September Release!

And: stay healthy!