We have added the possibility to create, edit and manage KPIs and Expressions in Report Designer.
Expressions can be created and managed through the Designer menu under Expressions.
Using Expressions is a way of referring to dimension values outside single reports and are typically used to refer to a selection that will be used in multiple reports. By using an expression instead of an ordinary selection within the report you can easily update multiple reports by editing the expression instead of having to edit each report individually.
For example, if you add an account to your general ledger and you need to include this new account in your reports, it is very time-consuming having to open multiple reports and make sure the new account is included in the selection. If, however, you use an expression and you need to add an account, you simply edit the expression and all the reports where this expression is used will automatically be updated.
It is possible to create expressions on all dimensions and multiple dimensions can be combined in one expression. Expressions are organized in groups.
For more information, see Expressions.
KPIs can be created and managed through the Designer menu under KPIs.
A KPI is a calculation/key figure that you want to reuse across multiple reports. KPIs are used in the same way as measures (amount, quantity). Instead of dragging an amount or quantity into the report, you drag out the complete KPI.
KPIs can be based on:
For more information, see KPIs.
We have implemented a Close all button when users are viewing multiple reports in Archive.
To open multiple reports in Archive;
To close all open reports in Archive;
We have made some changes in View log error reporting. Users can now access detailed information about the error by clicking the View error drop-down button.
To access error an error message for a data import job;
We have implemented a new option for opening reports in Live Reporting. Users can now click the drop-down arrow and select Open in Excel. When a user clicks this option, the report opens in Report Designer (Excel) directly in Run mode. No editing is possible in this mode and the Design mode is disabled.
In the past, users who had access to the Get Data module was automatically allowed to create a connection. We have now implemented a Can manage connections setting, so administrators can turn off the possibility to create a connection for regular users, but still allowing the user to import company data (for the companies they have data access to)
We have added support for higher resolution for Report Designer. In the past, some users with high-resolution screens experienced some display issues with the Layout Editor in Report Designer. This issue is now resolved.
We have created nonclustered index on FactGLTransaction. This will improve the performance when users are running reports.
We have added two new factsets: