We are happy to announce the September 2019 Release which is dedicated to the new Upload-from-Excel Function and the new Asymmetric Hierarchies in the Dimension Tree:
- New Upload-from-Excel Function in the Web App
From now on it is possible to upload e.g. your Actuals into the Fact Table in order to enrich your data collection process with reference data. How does this work?
You`ll find in in the info area a new link to a demo file ...
... which shows you, how the upload file basically must look like:
Below the Fact Table you`ll find now the new button Upload Excel File:
After selecting your upload file the upload process will start immediately. If everything was ok with the data you will get this success message ...
... if the data did not pass the technical validation for data types you`ll get an Error message like this:
- New Layout for button bar below data tables in the Web App
The new upload function made a redesign of the button bar below the data tables necessary. We reduced the size of all buttons to "icon", only the most important button "Add new" kept its caption.
Furthermore we have reordered the buttons and from now on the inactive buttons for a table are not shown anymore.
- New asymmetric Hierarchies in the Dimension Tree of the Excel Add-In
Until now, the hierarchy in the dimension tree of the Excel Add-In had to be symmetric, i.e. the bottom elements of the tree had to be all on the same level. From now on it is possible to define asymmetric hierarchies like this:
In practice, we can save now the unnecessary "fill elements" and get an even more intuitive dimension tree:
The definition is quite simple: just leave the Hierarchy Level fields "on the right" of the definition table empty:
- Format problems solved when using data1.io Templates in Excel and Excel Online
We learned that format conversion errors happen in the data1.io READ process if the language of the OS is different from the language of Excel Online (or also Excel). This leads to a misconversion of figures to text or the thousand separator will be misinterpreted:
We solved this issue in the September Release.
- Further Improvements in the Web App
We have solved bugs on deleting records from the dimension tree table, on saving changes in the workflow configurations and when switching between different Applications.
Hope you like the new features, let us know what you think about it!