Release PV620 SV202

The theme of this release is v8 compatibility.

Prerequisites

• This solution is compatible with OneStream Platform v8.

New

None

Changed

None

Fixed

None

Known Issues

None

Contacting Support

OneStream Support can be contacted at any time by registering at http://support.onestreamsoftware.com and then emailing support@onestreamsoftware.com.

Release PV620 SV201

The theme of this release is documentation updates and clarification on function availability.

New

None

Changed

• The System Diagnostics Guide has been updated to reflect limitations to the Live Monitoring function.

• System Diagnostics will now run in SQL version 2016 or older. (MP3-3524)

Fixed

None

Known Issues

None

Contacting Support

OneStream Support can be contacted at any time by registering at http://support.onestreamsoftware.com and then emailing support@onestreamsoftware.com.

Release PV620 SV200

The theme of this release is UI and functionality enhancements, the introduction of the report package function, and the modification of existing metrics and reports within System Diagnostics.

Prerequisites

This release supports an upgrade from previous releases of System Diagnostics.

Since this solution can be installed in multiple OneStream applications, refer to the following for upgrading to SV200:

• Upgrading System Diagnostics using only one OneStream application:

  • Log in to the application where System Diagnostics is currently loaded.

  • Click on the settings icon and navigate to Uninstall.

  • Click on Uninstall UI.

  • Navigate to Application > Load/Extract and load the PV620 SV200 .zip file.

  • Click Setup Tables to update the database schema from previous versions of System Diagnostics.

  • Click Launch Solution.

• Upgrading System Diagnostics connected using multiple OneStream applications:

  • Log in to System Diagnostics for each of the applications and perform the following:

    • Click on the settings icon and click Uninstall.

    • Click on Uninstall UI.

    • Once this has been done in all applications, log in to each application and load the PV620 SV200 .zip file to upgrade.

    • Click Setup Tables to update the database schema from previous versions of System Diagnostics.

    • Click Launch Solution.

New

• A new Report Package functionality has been added to automatically take an environment and application snapshot, run through all system reports, and create a .zip file in the user's file share location. Any errors processed during the report package execution will be included within the .zip file as a .txt file. (MP7-5, MP7-214)

• The Machine Culture Name field has been added to the application server grid. This will allow users to know if the application servers are assigned the same machine culture name. (MP7-2)

• The platform server version has been added to the existing application snapshot summary report and the database version has been added to the Database Sizes report. (MP7-210, MP7-211)

• A new report named Database Table Sizes has been added under the Application Analysis reports. This report will contain data for both the application and framework table types and is based on the most recent application snapshot. (MP7-6)

• A new report named Database Sizes has been added under the Environment Analysis reports. This report will contain data for both the application and framework. (MP7-179)

  • Cloud customers will also see a new Elastic Pool Usage pie chart that will appear above the Database Sizes report. The chart will display allocated, used, and unused space of the cloud customer's elastic pool. (MP7-187)

• The following new metrics have been added under the Application metrics: 

  • Potential Number of Stored Data Cells for Largest Data Unit (MP7-11)

  • Number of Closed Cube Root Workflow Profiles (MP7-4)

  • Number of Active Finance Rules and Member Formulas that Execute Api.Data.Calculate within a For Each Loop (MP7-201)

Changed

• The following changes have been made to the System Diagnostics UI:

  • The homepage has been updated to an Overview page. This page contains high level metrics from the following four areas: Server Status, Resources Validation, Daily Logon Concurrency, and Application Metrics. (MP7-33)

  • The Environment Analysis UI has been updated to improve user experience and navigation. (MP7-34)

  • The Application Analysis UI has been updated to improve user experience and navigation. (MP7-35)

  • The Task Analysis UI has been updated to improve user experience and navigation. (MP7-40)

  • The Live Monitoring UI has been updated to improve user experience and navigation. (MP7-37)

• The ability to recycle application servers has been removed. Recycling servers can be performed within the Platform itself rather than using System Diagnostics. (MP7-18)

• The Error Log and Task Activity reports have been removed in this release. (MP7-8)

• The Resource Validation report has been updated to show the same metrics for both users and servers for Gen-Stage and Con-DataMgmt servers. (MP7-218)

• The data explosion cube data volumes stat under Application Analysis has been removed. (MP7-29)

• The following changes have been made to existing metrics: 

  • The Number of Stored Records for Largest Data Unit thresholds have been updated to the following statuses: Green - Less than 1 million, Orange- Between 1 and 2 million, Red- Higher than 2 million. (MP7-317)

  • Under the Application metrics, Number of Finance Rules and Member Formulas using BRApis has been modified to only include finance rules and member formulas if they are activated or being used in the application. (MP7-183)

  • Under the Application metrics, Number of Active Finance Rules and Member Formulas without Consolidation Conditions has been modified to only include finance rules and member formulas if they are activated or being used in the application. (MP7-195)

  • Under the Application metrics, Number of Finance Rules and Member Formulas without Entity Conditions has been modified to only include finance rules and member formulas if they are activated or being used in the application. (MP7-197)

  • Under the Application metrics, Number of Finance Rules and Member Formulas Using Error Logging has been modified to only include finance rules and member formulas if they are activated or being used in the application. (MP7-199)

  • Under the Application metrics, Number of Finance Rules and Member Formulas that execute Api.Data.Calculate within a For Each Loop has been modified to only include finance rules and member formulas if they are activated or being used in the application. (MP7-201)

Fixed

• The database server statistic metrics will load dynamically for cloud or on prem customers. (MP7-28)
• The warning message for Max Cube View Row Limit has been fixed. (MP7-17)
• While running the Long Running Formulas Report, the user was receiving an error: the sub-query was modified to resolve this issue. (MP7-22)
• This release fixed the issue of zeros appearing if the user drilled down on the Number of Stored Records for Largest Data Unit if the application is weekly with scenarios of monthly, quarterly, yearly, and half-yearly. (MP7-77)
• If culture code is non-US, the system will allow users to create an application snapshot without any errors.(MP7-247)

Known Issues

• None

Contacting Support

OneStream Support can be contacted at any time by registering at http://support.onestreamsoftware.com and then emailing support@onestreamsoftware.com.

Release PV620 SV100

The theme for this release is the addition of Application Analysis and rebranding to System Diagnostics.

Prerequisites

Uninstall

• This release does not support an overinstall of System Diagnostics. An uninstall UI or uninstall full is recommended before upgrading to this release version.

• A full uninstall of System Diagnostics breaks any other installations of System Diagnostics within the same environment.

Schema or Database Changes

• If upgrading from PV430 SV100, an Uninstall UI (under Settings) of System Diagnostics is required before installing this release. See the chapter on How to Install in the System Diagnostics Guide.

New

• This solution was previously named Diagnostics 123 but has been rebranded as System Diagnostics. (MP3-187)

• The Application Analysis snapshot lets you capture critical application metrics and data volume statistics for any available applications in the current environment. (MP3-165)

  • You can manage the list of snapshots, and compare any two snapshots in any available applications, as well as change a snapshot's name.

  • Application metrics captured for Data volume statistics include Cube data, Stage data, Register data and BiBlend data.

  • All previously created snapshots are permanently accessible until you delete them.

• The Application Metrics Panel displays two tabs that show critical application metrics and data volume statistics, providing more insights to diagnose performance issues. (MP3-169)

  • The Application Metrics tab shows each defined statistic, its status, instance counts and diagnostic information.

  • The Data Volume Stats tab shows details for Cube and State data volumes, Register data volumes, and BiBlend data volumes.

• Application Analysis includes three reports that let you assess the overall information being presented in Application Analysis results. (MP3-171)

  • The Snapshot Summary report shows information captured and available in the Application Metrics tab.

  • The Long-Running Formulas report shows any formulas associated with the application that take longer than five seconds to run.

  • The MarketPlace Solution Deployment report shows all the MarketPlace solutions associated with the application selected in the Snapshot panel dropdown filter.

• Application Analysis comparison lets you view and compare application statistics between any two snapshots in any of your current environment's applications. This information is available in either a Snapshot Comparison window, or in a PDF report. (MP3-172)

• A task in the OneStream Task Scheduler is automatically generated when System Diagnostics is installed. This automates snapshot creation so a snapshot is taken at 11:30 PM on the third Saturday of the month. (MP3-162)

Enhancements

• Two reports have been added to Environment Analysis to support enhanced environment and user concurrency reporting for a more granular understanding of environment usage. (MP3-829)

  • The Error Log report shows the last 30 days of task log activity based on when the selected environment snapshot was taken.

  • The Task Activity Log report shows the last 30 days of error log activity based on when the selected environment snapshot was taken.

• The following statistics are included as items in the Gen-Stage Concurrency group when running Environment Analysis:

  • Number of Enabled User Licenses

  • Number of Disabled User Licenses

  • Actual Concurrent Logins

  • Actual Concurrent Users

Fixed

• A user with culture code set to French could not create a new snapshot with System Diagnostics. (MP3-823)

Known Issues

None.