Version: v5.2.30109.0931
We have now enabled a Microsoft sign-in option for users when signing in to the OneStop Reporting portal.
Users can now choose to use their OneStop Reporting password, or click Sign in with Microsoft to use their Microsoft password.
NOTE: The first time you use Sign in with Microsoft, you must approve this as a sign-in method.
To be able to use AAD with the portal, you must register the portal as an app in your AAD tenant and retrieve the Application ID. See Microsoft documentation for more information.
Now, users can sign in to OneStop reporting using their Microsoft account.
If you want to enforce users to use Microsoft to sign in, see Require Azure Active Directory (AAD) sign-in for all users below.
Now all users are required to use their Microsoft account password to sign in to OneStop Reporting and can no longer use their OneStop Reporting password.
NOTE: If users have access to multiple tenants where one requires Microsoft sign-in and another does not, then they are required to sign in again when switching to the tenant that requires Microsoft sign-in.
When an administrator has entered a domain under Require Azure Active Directory (AAD) sign-in for the given domains, users will get a Sign in menu where they are asked to select a Microsoft account.
To enhance user security in OneStop Reporting, we have made it possible to use Multi-Factor Authentication (MFA) when signing in to the portal.
MFA is an enhanced security system that verifies a user’s identity by requiring two or more forms of authentication. Rather than just asking for a username and password, MFA requires additional credentials, such as a code from the user’s smartphone.
MFA is an effective way to provide increased security. Usernames and passwords can be stolen, and they have become increasingly susceptible to brute force attacks. MFA creates multiple layers of security to help increase the confidence that the user requesting access is actually who they claim to be.
With MFA, even if an attacker manages to learn the user’s username and password, it is useless without also having possession of the additional authentication method. In OneStop Reporting, MFA works by requiring two authentication methods:
An authenticator app is usually installed on a smartphone and you scan a barcode or enter a key to create an account. After the account is created, the authenticator app generates a 6-8 digit passcode every 30 seconds. The passcode can, for example, be used for login as an extra authentication method in addition to a username and password.
The passcodes are generated from a secret code that is shared between the service you are using, such as OneStop Reporting, and your device, as well as the current time.
Google Authenticator app example
There are a variety of authenticator apps you can download to your phone from Google Play and the IOS App Store, but we recommend that you use Google Authenticator or Microsoft Authenticator, as those are the ones we have fully tested our MFA solution on.
Authenticator apps in Google Play
For more information about installing and setting up an Authenticator app, see Install and set up an Authenticator app
In OneStop Reporting, users can set up MFA from their user settings. In addition, administrators can enforce an MFA policy for all end users. See the user procedures below for more information:
You have now set up MFA for your OneStop Reporting user profile. The next time you log in to OneStop Reporting portal, you must enter your username and password, and then enter a verification code from your authenticator app.
Click here for video on how to set up MFA on your account:
If you do not have a verification code, click the Do not have a code? link to read more about the MFA setup.
NOTE: You can click the More information link to read more about Multi-Factor Authentication (MFA).
Multi-Factor Authentication (MFA) policy is now enabled for this organization. All users must use MFA to sign into the underlying tenants and groups.
If your administrator has enabled a Multi-Factor Authentication (MFA) policy for your organization, you will receive a message:
Your organization’s security policy requires you to set up Multi-Factor Authentication (MFA) for your account.
You have now set up MFA for your OneStop Reporting user profile. The next time you log in to OneStop Reporting portal, you must enter your username and password, and then enter a verification code from your authentication app.
If you do not have a verification code, click the Do not have a code? link to read more about the MFA setup.
If enabled by an administrator, users can now use the Microsoft sign-in option when signing in to the OneStop Reporting portal.
Users can now choose to use their OneStop Reporting password, or click Sign in with Microsoft to use their Microsoft password.
Now, users can sign in to OneStop reporting using their Microsoft account.
* To be able to use AAD with the portal, you must register the portal as an app in your AAD tenant and retrieve the Application ID. See Microsoft documentation for more information.
Administrators can also require all users to use Microsoft to sign in. See Require Azure Active Directory (AAD) sign-in for all users below.
NOTE: To be able to use AAD sign-in, you must have enabled AAD in System Settings and entered the Application ID from Azure.
Now all users are required to use their Microsoft account password to sign in to OneStop Reporting and can no longer use their OneStop Reporting password.
NOTE: If users have access to multiple tenants where one requires Microsoft sign-in and another does not, then they are required to sign in again when switching to the tenant that requires Microsoft sign-in.
When an administrator has entered a domain under Require Azure Active Directory (AAD) sign-in for the given domains, users will get a Sign in menu where they are asked to select a Microsoft account.
We are now introducing a new Budgeting license. Users with this license will have the possibility to budget directly in the Budgeting module. In the past, users were required to have a license for Report Designer to have access to the Budgeting module, but this is no longer necessary.
In addition to budget directly in the portal, they can download budget templates from the Marketplace, and then download the budgets locally if they want. Furthermore, they can assign budget templates to other users and roles. NOTE: This license does not allow users to upload or create budget templates.
Users with the Budgeting license will also get access to the Assignments and Workflow modules.
If given the Can edit data from Data Manager permission, they also have access to Data Manager. For more information, see section below.
Users can now control access to Data Manager from Permissions in Administration.
To grant a user access to Data Manager;
We have added an option in Administration for Group Users, so that users can be added with full access permissions in all subtenants (data access, drilldown, etc.) without being administrators.
The three options for Group Users are now:
When existing users are added to a tenant, they are notified with information about the user that added them to the tenant.
Playlists in Archive are now sorted by date. In the past, users would see their unread playlists at the top of the list. We have changed this because most of our users are primarily interested in their most recent reports.
If you have ( ) selected a Category in Live Reporting or Budgeting, and select to upload, duplicate, create new, or download report/budget template(s) from the Marketplace, the report(s) is automatically added to the selected Category.
NOTE: You can select multiple categories to add report/budget templates to.
NOTE: Click here to learn more about managing categories in Live Reporting, or here to learn about managing categories in Budgeting.
The report templates are added to the Category/categories you have selected.
In the past, users had to press Ctrl/Shift to select multiple values in the parameter lookup. Now, users can click a value, then click again and scroll to select a range of values.
NOTE: This only applies to reports that allow multi-selection for parameters.
Some of our users have very large reports, containing numerous cells with formulas, many that are referring to other cells and functions. This might cause performance issues when running reports in the portal. Therefore, we have made it possible to run reports in “static mode”. This means that all formulas are removed in the workbook and the values are replaced with actual cell values.
Users can control the formula settings for a report template from the Report Properties in Report Designer. On the Reporting tab, there is now a Keep formulas in run report checkbox. If this checkbox is deselected, the formulas are removed from the report.
NOTE: This option will not have any impact on budgets.
All formulas in the generated report are kept during processing.
All formulas in the generated report are now removed during processing, and the values are replaced with actual cell values. When formulas are removed from a report, it is no longer possible to make calculations in run reports in Live Reporting.
When formulas are removed from the report template, the drilldown will function as normal.
NOTE: For reports that contain advanced formulas, such as IF and INDIRECT in the same formula or when referring to other sheets, it is safest to select the Keep formulas in run report checkbox to ensure the formulas work as intended in the portal.
In the past, users clicking the Help button in Report Designer would get the default language English. Now, users are redirected to the help in Norwegian, Danish or Swedish depending on their language settings.
Store even unchanged cells has changed name to Store unchanged cells. The logic remains the same: This option will force data from this cell to always be stored. The application will not do a check whether the input cell has changed its value or not.
Ignore cell value 0 has changed name to Delete transactions if cell value is 0, and will now have the following logic:
Suppress delete has changed name to Delete transactions for empty cells. The logic remains the same: If this option is selected, the value is used to update existing/insert a record in the storage dimension. This will also apply to transactions where there has been a value that has now been set to 0/blank/deleted.
It is now possible to download a budget as an Excel file from an assignment in Assignments. The Download functionality is available both for single assignments from Budgeting and assignments in a workflow.
In the past, there have been issues when using, for example, the Norwegian standard date format; day, textual month, and year. The issue has now been solved and the following setting can be used:
For this release, we have worked on improving the KPI and Expressions functionality in Report Designer. Specifically, we have implemented the following fixes:
We have fixed an issue where users have experienced that the grouping on the Grouping/Sorting tab would still be active even if they deselected the Expanding checkbox. This would cause the group to still expand. The issue is now fixed, so that when a user deselects the Expanding checkbox, the grouping is now automatically set to None.
Users can now expand columns in Line Item Details if they have large numbers that show a number sign, #, due to lack of space in the column.
In the past, some users have experienced that the language of their report changes to English when they export a report to pdf. This is now fixed, and reports will now have the same language as the user has set as their language.
We have fixed an issue where some users have experienced getting error messages when selecting parameters for their assignments (when the Let User Decide option is selected for parameters in Workflow).