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:

Formulas

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

UNION

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'.

Description	The UNION function is used to combine the result-sets of two or more input nodes.
Signature	UNION('Node1', 'Node2' [, 'Node3'])
Parameters	'Node1', 'Node2' [, 'Node3'] are nodes you want to combine the calculation result.
Limitations	inputs must have same levels inputs must not have overlapping rows

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

ROLLUP_TO

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

Description	Rolls up the first input node (Node1) to the level-dimensionality of the second input node (Node2)
Signature	ROLLUP_TO(Node1, Node2)
Parameters	Node1: Represents the input that will be rolled up Node2: Used to take the levels to roll Node1 up to
Limitations	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.