OneStream Architecture and Technical Support blog

OneStream 6.5.0 is a minor release that contains new features, enhancements to existing features, and business rule API additions.  The features of this type of release are developed to enhance the design capabilities, performance, and improve ease of use of applications.  Designers, system administrators, and users will benefit from the enhancements across their applications. Minor versions are compatible with prior versions. https://f.hubspotusercontent30.net/hubfs/2020381/OneStream%20Version%206.5.0%20Release%20Notes.pdf

Use the following tables: Table names are “TaskActivity” and “UserLogOnActivity” Create a dashboard using grid view and export the data from Grid view. Keep in mind to use WITH (NOLOCK) for the SQL so that you are not locking these tables which you perform the SELECT Another option is to export the log using Load/Extract option and then open the XML file in EXCEL Good Luck!

  Supported Authentication Providers OneStream XF Native Microsoft Active Directory (MSAD) LDAP Azure AD Okta PingFederate SAML 2.0

They are used to substitute values at run time for the following artifacts within the application: - Cube Views - Dashboards - Data Adapters - Data Management - Forms You can setup prompt for users such as Drop Lists, Dialog Box, and Text entry The MarketplaceXF ships with over 150+ standard parameters, and they are being updated/added in each release

Quick ad-hoc to analyze, drill and pivot into XF data in Excel/Spreadsheet Control which Dimensions are in columns and rows and apply Member Filters Spawn a Quick View from another Quick View or Cube View to further analyze a specific cell’s data

Under the theme of  Performance and Scalability , enable faster performance on large data sets by allowing users to manage paging controls on Cube Views and by enabling Sparse Data Suppression on Excel Quick Views. Look at Max unsuppressed row setting and  Allow Sparse Row Suppression =True  

The themes of this release are:  - Automatic notifications for tasks coming due or past due  - Ability to send notification emails to individual preparers and approvers  - Inclusion of comments in forwarded notification emails  - Usability improvements Deployment  - This release supports an over install however, OneStream strongly recommends an Uninstall UI instead.  - Use OneStream platform version 6.3.0 or later with this version of Task Manager.  URL for more information: https://f.hubspotusercontent30.net/hubfs/2020381/UTM_PV6.3.0_SV100_ReleaseNotes%203.23%20Jessica.pdf