Skip to main content
Skip table of contents

Release Notes 5.1.0

Valsight Version 5.1.0 adds an improved data preview, two new formulas, a new aggregation setting and an optimized scenario manager and line-item detail overview.

Data Preview

With the 5.1.0 release, Valsight introduces the feature of an aggregated overview in the data preview.

The data preview now features multiple additional options to adjust the view to individual preferences.

For example, reducing the data to a minimum (Clear All), automatically applying all available level to the axes (Apply All) or saving and restoring certain filters/settings (Save & Restore).

To learn more about the data preview and how to modify it, click here.

To learn more about the different functionalities, click here.

For an example on how to use the new functions of the data preview, click here.

Scenario Manager

With the 5.1.0 release, Valsight relocates the Scenario Manager and improves the usability and visibility of it. 

By relocating the Scenario Manager from the lower left corner of the workspace to the upper right corner, the Scenario Manager is easier to be found.

Loosening the Scenario Manager from the lower tab bar enables easier transition between sheets and the scenario manager.

Line-Item detail view

With the upgrade of the scenario manager, Valsight also introduces an optimized view onto the line-item detail view.

By rearranging several buttons and grouping them together, the line-item detail view now appears in a sharper view.

Furthermore, it is now possible to see in which unit a line-item is displayed and change the scale of this unit (if applicable).

Choosing the scenario on which the line-item data is based:

Customizing different table options to view your data:

More options that relate to the line-item detail view:


With the 5.1.0 Version of Valsight, two more operations/node formulas are introduced. 


This formula can be used as a more restrictive version of the ADDITION formula.

Whereas the ADDITION formula allows nodes with different levels to be combined, the UNION formula is restricted to only combine nodes that contain the same levels. 

This can also be used as a validation method as only nodes with the same levels can be 'united'.  


The UNION function is used to combine the result-sets of two or more input nodes. 


UNION('Node1',  'Node2' [, 'Node3'])


  • 'Node1',  'Node2' [, 'Node3'] are nodes you want to combine the calculation result
  • inputs must have same levels
  • inputs must not have overlapping rows

To learn more about the usage of the formula, click here.


The ROLLUP_TO formula enables users to bring one node to the same level-dimensionality as another node. 


Rolls up the first input node (Node1) to the level-dimensionality of the second input node (Node2)


 ROLLUP_TO(Node1, Node2)


  • Node1: Represents the input that will be rolled up
  • Node2: Used to take the levels to roll Node1 up to
  • Input node 'Node2' can not contain levels that are not in input Node1
  • Input nodes can not have equal levels

To learn more about possible use cases or the formula in general, click here.

FIRST Aggregation

With the FIRST aggregation, Valsight adds an additional setting to the already existing aggregations settings of the software. 

The FIRST aggregation can be used to aggregate data to the first existing data point of the data entered.

More information about this and other aggregation settings can be found here

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.