OneStream Architecture and Technical Support blog

 Latest update on System Diagnostics within OneStream platform System Diagnostics will now run in SQL version 2016 or older. (MP3-3524) URL https://2020381.fs1.hubspotusercontent-na1.net/hubfs/2020381/OSD_PV6.2.0_SV201_ReleaseNotes.pdf?utm_medium=email&_hsmi=258518711&_hsenc=p2ANqtz-9LcQzemRJlPU95X3O_N57eHEZvnIOzE1_EwvLHzHN659Alk4R_xV9f-I7AawhEXAkF7n6XE_-0bRN7lcf_zzsiRTPH78k1zIxovpLMLNa6CBCcseA&utm_content=258518711&utm_source=hs_email

  OneStream upgrades are Fast and Simple 1 - Make sure all users are logged out 2 - Shut down IIS on Web Servers first, then on each App Servers 3 - Uninstall servers, Excel Add-in, and Studio 4 - Install Software 5 - Replace Config files with copies or reconfigure 6 - Update Databases to the latest version if required with OneStream Database Utility 7 - Restart IIS on all App Servers 8 - Restart IIS on all Web Servers 9 - Login and validate

Latest OneStream platform release schedule.   Starting 2023, we will have 3 Releases per year. 

  Note:  The 7.3.0 upgrade requires a framework and application schema update. Workspaces:  Operate as the foundation for Dashboards and facilitate community development. Workspaces will continue to evolve into the framework that encapsulates artifacts needed to develop business solutions. Cube View Row Tree Expansion Mode : New Cube View properties used to indicate desired hierarchical expansion levels when using  .Tree  in Cube View rows. Sankey Diagram : New Dashboard Component used to enhance visualization for data flow analysis. https://2020381.fs1.hubspotusercontent-na1.net/hubfs/2020381/OneStream%20Version%207.3.0%20Release%20Notes.pdf?utm_medium=email&_hsmi=242019444&_hsenc=p2ANqtz-8P3kfZm68Dy6Hta94X9Ei1-GDOhNoYmNFVDfnI0pN5VdyEu8uRrSSjM6NqqnP5f7CJST7dOGnmnZ8Fdpr6eVgKu9g4vTN7w8_ETo_H2MGvm0d7B2k&utm_content=242019444&utm_source=hs_email

OneStream MarketPlace provides   Log Cleaner tool to clean logs. You can select which type of activity to clean such as User Login, Task etc Some companies will run this every quarter and only retain minimum (30 days) logs while cleaning up all types except for user logon activity. If you are a public traded company, please use caution when clearing the error log, since this is where the system dashboard for Software Version Audit gets its information.  This can cause an issue with audit. Also, there is a default setting on your servers and those may be set low out of the box. 

OneStream Administrators can perform certain DIY (Do It Yourself) functions, that can be downloaded from the MarketPlace, called System Diagnostics Overview. This gives you the ability to diagnose metrics and data volumes that can effect your performance. You can perform Environment Analysis, Application Analysis, Task Analysis, and live monitoring.  You can also schedule snapshots, that can be analyzed at your convenience.  Another major feature is the ability to recycle applications servers.  This gives you the additional insight  for keeping a healthy environment for your end user community. Good Luck downloading and using it !!

U sing Microsoft Azure AD for SSO and every time you login, you get to choose which account to use for the login.  If you like to use Another Account, you can  click on “Use Another Account” on the Azure AD page that is returned with the User ID and the user can type in the Username they would like to use to sign in.   The User would still need to exist in OneStream, otherwise it would return that there is not a matching account with that name.