Pyramid 2023.13, a service pack for Pyramid 2023, has been released. It primarily includes fixes and adjustments for critical vulnerabilities in 3rd party technologies. There are also breaking changes.

Software

• The main installer files and client SDKs can be downloaded from the Customer Portal. 
• Docker containers have been upgraded for Kubernetes deployments.
• Upgraded Embed API libraries can be downloaded from NPM.

Installation & Upgrade Guidance

• Main Installation guidance can be found here.
• Help for upgrades can be found here.
• Help on how to test an upgrade before deployment can be found here.
• Help for Kubernetes deployments can be found here.

 Cautions

Additions and Deprecations

Breaking Changes

There will be BREAKING CHANGES in this release related to R and Tensorflow. Both of these 3rd party technologies have critical vulnerabilities which require upgrades. To address this, Pyramid has upgraded both items in this release. However, the upgraded versions of R (4.4.0) and Tensorflow (2.16.1) MAY NOT BE BACKWARDS COMPATIBLE with any models or scripts created with prior versions of either technology. This means customers may need to adjust scripts and/or rebuild models. These breaking changes are out of Pyramid's control. 

Technology Changes

OS Deprecations

Pyramid 2023.13 will be the last version of Pyramid to support the following operating systems, which are now end of life or out of standard support:

• Red Hat Linux 7
• CentOS 7
• Oracle Linux 7
• Ubuntu 16 and 18
• Debian 10

Customers should be migrating any Pyramid instances running on these operating systems to newer editions.

Python Upgrade

From 2023.13, the standard Pyramid Python environment will be based on Python 3.11. Any scripts or models that were built using an earlier version of Python or the prior Pyramid Python environment (3.7) should continue to work, unless specific Python packages have breaking changes. Customers are advised to start using the new version of Python for all new projects going forward.

New DS/ML service containers

As of 2023.13, Pyramid will publish 2 different containers for the Data Science and Machine Learning service in Kubernetes deployments. The standard DS/ML container is the same as previous releases and will allow customers to build custom Python environments as needed using live Python repositories. However, a new Full DSML container will also be released - containing a COMPLETE installation of the Anaconda system for building offline Python environments. This approach is useful for detached deployments where access to live Python repositories is unavailable. Unless required, the standard container is strongly recommended.

New Features

• Added a new connector for IBM Informix databases
• Added new LLM model options for Gen-BI integrations: Mistral and Google Gemini
• New notifications within the mobile apps
• New PQL functions: 3 in Granular Date-Time and 2 in Semantic Statistics
• New "Full" DSML container with the entire Anaconda Python repository pre-installed (see above)

Items Fixed

 

Model      

• Fixed an issue where the "File name filter" did not work when using a Box data source
• Fixed an issue where Append did not work for an Azure Blob target
• Fixed an issue where Pyramid failed to read the tables of a Netezza database that had spaces in the name
• Fixed an issue where a user was unable to schedule a model process due to an access issue
• Fixed an issue where OLAP Cubes were appearing in the Properties panel of the Source node only for Enterprise admin users
• Fixed an issue where a model process failed with a "No quotes mode set but no escape character is set" error
• Fixed an issue where changes made to an existing model schedule were not applied after clicking "Save"
• Fixed an issue where using Sort on a string column had failed if the column had null values
• Fixed an issue where a JSON Extract node with "Ignore null elements" selected had failed with a Server Error 1001
• Fixed an issue where the Modify Case node failed when there were null values in the data
• Fixed a "Data is too large" error message when trying to generate a script in the Python node
• Fixed an issue where tables with the same names on different schemas synced incorrectly
• Fixed an issue where users couldn't set an Authorization header in a JSON source
• Fixed an issue where non-admin data modelers could only see roles from their tenant in Model Security when Cross Tenant User Roles was enabled
• Removed data source number of tables limitation
• Fixed a Model process error when using Excel as a source

Discover

      Queries:

• Fixed an issue where a custom sort was not saving or being applied to the grid
• Fixed an issue where 'N of N' produced unexpected results when the members were from the same dimension
• Fixed an issue where the parent of a member incorrectly appeared in the grid after expanding and then collapsing the member
• Fixed an issue where a big decimal value in a slicer was causing the query to fail on Exasol
• Fixed an issue where selecting Last 3 Months in a calendar filter failed with a "Cannot read properties of undefined" error
• Fixed an issue where a combination of a Formula and Calendar hierarchy slicer caused a "Can't run the given query" error
• Fixed an issue where drilling down a geo hierarchy based on a custom map resulted in an error
• Fixed an issue that resulted in incorrect aggregation when using an attribute not related to the measure group
• Fixed an issue related to default values in SAP BW Predefined Parameters
• Fixed an issue with date range calculations on null values that was causing a report to fail to open
• Fixed an issue where selecting "All" in a Hierarchy Tree filter failed when using a database with aggregate tables
• Fixed a caching issue that was causing Row level member security to fail

      Visuals:

• Fixed an issue where Borders styles didn't apply to selected rows/columns when changed from the Formatting Panel
• Fixed an issue where a gauge didn't show the Data Point Name
• Fixed an issue where a negative value in a Stacked Column chart appeared incorrectly in a tooltip 

Present

• Fixed an issue where user Notes did not display in a presentation
• Fixed a "Failed to get cardinality…" error when opening a presentation
• Fixed an issue where interactions between content and mini-tabs did not update all mini-tabs
• Fixed a blank screen issue in the Presentation Preview that occurred after clicking the Previous or Move Up arrows
• Fixed an issue where the Text-to-Speech Icon that appears in a tooltip was hiding some of the text
• Fixed an issue where it was not possible to remove/add an interaction to a single query in an illustration that had multiple queries when using the Interaction Manager
• Fixed an issue that was causing a "Cannot read properties of undefined" error when changing a slicer selection in a present
• Fixed an issue where an initial selection of "All" in a Multi-Select Buttons filter visually appeared as if no members were selected
• Fixed an issue where a text parameter selection could not be undone using the Undo option
• Fixed an issue where Data Interaction across mini-tabs in the same mini-tabs object was not working 

Tabulate

• Fixed an issue where a nested calculation with parameters was showing N/A after executing
• Fixed an issue where a Tabulate was not displaying values in a Presentation

Publish

• Fixed an issue where editing a subscription that was created from within a publication, did not save the changes
• Fixed an issue where a Page Repeater did not work for a measure slicer
• After importing and replacing content that includes subscriptions, the subscriptions will now be disabled

Formulate

• Fixed an issue where a variable list of measures was executing the default measure in the background
• Fixed an issue where a formulation didn't return the expected results due to a problem with 'currentmember' 

Illustrate

• Fixed an issue where a rectangle image proportions was not correct when it was set to 10px 

Content Management

• Fixed an issue where the content path didn't appear intermittently when browsing content in the CMS
• Fixed an issue where saving a Live Version of a direct SQL model had failed
• Fixed an issue where users received a "You are not authorized to perform this action" error when attempting to paste content into a folder they had Write access to
• Fixed an issue where exporting a folder without the related content was causing an error
• Fixed an issue where a "General Error" appeared after cutting/pasting items in private content
• Fixed an issue where Domain Admins were unable to add users from other tenants to roles within their own tenant
• Fixed an issue where clicking on a Favorite folder on the Home page resulted in an error for Viewer users 

Printing/Export

• Fixed an issue where a grid column was not wrapped in an Excel export 

Admin

• Fixed an issue where psscript files were accumulating in the temp directory of the task server
• Fixed an issue where write permission for a data source was removed when configuring permissions on a model
• In Runtime Services, the "Query Track Timeout" and "Query Track Threads Number" were renamed to "Fast Track Timeout" and "Fast Track Threads Number"
• Fixed an issue where a "The file is not in the correct format; refer to the help for details" error appeared when importing roles using a CSV
• Fixed an issue where the Apply button was grayed out when setting up Open LDAP
• Fixed an issue that was causing users to get unexpectedly disabled
• Fixed an issue where the log cleaner was not clearing some logs

API

• Fixed an issue in /API3/access/createRoles where there was no flag allowing the creation of a folder in the work group content
• Fixed an issue where /API2/content/addRoleToItem removed existing roles if propagate was set to true
• Fixed an issue where attempting to use API3 to generate a user's token failed with an "unauthorized" message
• Fixed an issue with API2 and API3 where access/createUserOpenId did not add the user to a role when "cross-tenant user roles" was disabled

Other 

• Various Help improvements
• Fixed an issue where Hierarchy Tree slicers were not loading in an embedded content
• Fixed a label styles issue which was causing some labels to be cut off in embedded content
• Upgraded R version to 4.4
• Fixed an issue where users were getting a "You are not authorized to login…" message when logging in for the first time using SAML authentication
• Fixed an issue where a filter was not working correctly in an embedded present with model mapping
• Fixed an issue where a Legend had a border around it in embedded content which did not show when looking at the report directly in Pyramid
• Removed HTML tags from captions in Smart Insights
• The call to grab.cur was removed from embed calls when pre-query filters were used in the content
• Improved error handling of Box authentication issues
• Fixed an issue where queries did not run when opening an embedded presentation without a mobile layout on Android
• Enhanced logging for issues related to Satellite