Pyramid 2023.15 a service pack for Pyramid 2023, has been released. It includes fixes with a few minor features. Importantly, it includes the release of API 3.0 which has breaking changes from the prior beta.

 

It should be noted that Pyramid 2024 LTS "Fibonacci" has also been released and is functionally equivalent to 2023.15.

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

 

 New Capabilities and Changes

 

Features

• DataDog Log Shipping - Added support for shipping Pyramid logs to DataDog
• MS Fabric support - Pyramid now offers support to connect to Microsoft Fabric
• New Conda options - added support for the Python Conda-forge repository as well as a new option to switch between Conda-forge and Anaconda.
• Upgraded Java 17 - change to Java 17 to close vulnerabilities found in earlier release of Java 17.
• API3 is now in GA - Previous beta and release candidate versions of API3 now upgraded to full General Availability. There were a last round of adjustments made to API3 as described below.

API3 breaking changes for GA release

Function	Description	Changes
getUserByPrincipalName	Find users using their “principal name” as specified in the SSO engine.	Function renamed to getUserByExternalId
createUsers	Creates users	Input object (CreateUserObject) was changed.  PrincipalName was renamed to ExternalId within the parameter
getUserByExternalId getUser getTenantUsersByUserType getUsersByName getUsersByRole getMe	Functions that retrieve user information	Output object (PyramidUserObject) was changed. PrincipalName was renamed to ExternalId within the output
updateUsers	Updates users	Input object (UpdateUserObject) was changed. pPincipalName was removed from the input object.
suspendSchedule	Pauses or suspends the processing of an active schedule	Domain admins can use this function with with data permissions
resumeSchedule	Resumes the processing of a paused or stopped schedule	Domain admins can use this function with with data permissions

Deprecations 

The database driver for MS SQL Server has been upgraded to be compliant with new Microsoft data technologies (like Fabric). The driver drops official Microsoft support for SQL Server 2012 and earlier. However, anecdotal testing shows SQL Server 2012 still works with this driver. Customers should migrate off older versions of SQL Server to avoid issues.  

 

 Items Fixed

 

Model

• Fixed an issue where a user was getting a "Permission Denied" error when trying to execute a model
• Fixed misaligned column headers in the Preview panel
• Fixed a blank screen issue when clicking on Translations in Model
• Fixed an issue where the drop-down to select an existing semantic model didn't appear for a user with a Model Only role
• Fixed an issue where a user with a role granting Read permission on a Model couldn't process it due to an additional role with Model Only permission
• Fixed an issue where a Table Filter was removed following an export/Import
• Fixed an issue where a Table Filter didn't work for datetime columns in Oracle
• Fixed an issue where a Calculated Column produced Null results
• Fixed an issue where a Null error message appeared after clicking on "Data Model"
• Improve the method of selecting bridging tables in diamond-shaped models
• Fixed an issue that was causing multiple jobs of the same schedule to run simultaneously
• Fixed an issue where a scheduled process failed when Sync All was enabled
• Better handling of canceled or timed-out JDBC queries during ETL preview 
• Fixed an issue where a Join failed with a "Double cannot be cast to" error
• Fixed an issue where an error message appeared upon opening a Master Flow in an existing model
• Added Simplified Chinese to the list of Model Translations

Discover

      Queries:

• Fixed an issue where reports containing multiple Parent-Child Hierarchies in Filters, combined with a custom List, failed to load
• Fixed an issue where Discovery Chat queries involving a time dimension didn't return results for OLAP and Tabular
• Fixed incorrect Dice results when Auto Run was disabled
• Fixed an issue where a Null member appeared in a grid although it was unselected in the filter
• Fixed a Custom Order issue that caused a Discovery to open with a "Cannot read properties of undefined (reading '0')" error
• Fixed a Hierarchy Security issue that caused reports to display a "not enough information" message upon opening
• Fixed an issue where a Pre Query filter wasn't being applied 

      Visuals:

• Fixed incorrect tooltips for Increase\Decrease border width
• Fixes incorrect Calendar Slicer caption
• Fixed an issue where the "Default Member" selection of a slicer was changed after an upgrade when using an OLAP source
• Fixed an issue where some charts were not visible when using Safari on a Mac
• Fixed an issue where Data Labels did not appear in a Marimekko chart
• Fixed an issue where a Bubble displayed incorrectly on a Map chart when using a multi-select filter

Present

• Fixed an issue that caused an "Error loading component" message to appear when clicking on a Waterfall chart interacting with another visual
• Fixed an issue where the number of items in a filter did not respect the admin Result Limit setting in a Discovery report
• Fixed an issue where the Search icon for a New Slicer was out of place for a BW source
• Fixed an issue where Adding a filter in Presentation using the "Add New Slicer" button was not working on SAP BW source with predefined parameters
• Fixed an issue where the Initial Selection was not applied after changing a slicer type
• Fixed a permission issue that was causing a Presentation to show cached data in illustrations
• Fixed an issue where a filter was cut in a Scrollable Panel
• Fixed an issue where a Mini Tab didn't appear in Edit Model while it did appear during Runtime
• Fixed an issue where the Advanced Slicer Initial Selection Mechanism was not working as expected
• Fixed an issue where Dropdown Navigation didn't work as expected in embedded presentations
• Fixed an issue where a tooltip didn't appear for selections in a Hierarchy Tree filter

Publish

• Fixed an issue where a monthly schedule for the first Monday of the month had failed to run
• Fixed an issue where the distribution of a Publication had failed when using File Mapping with a CSV file that contained commas
• Resolved an issue where a Publication Schedule did not function as expected after a change in the case of a member caption used in a filter within the schedule
• Fixed an issue where Dynamic Text printed intermittently with unexpected values
• Fixed an issue where a dynamic text in a Publication with a Page Repeater showed wrong results once printed

Formulate

• Fixed an issue where a Direct query column calculation could not be aggregated
• Fixed an issue where a Custom Column didn't update in cases it was using a Parameter in conjunction with a custom measure
• Fixed an issue where the StrToMember function failed with a "Can't run the given query" error
• Fixed an issue where the title of a Model Parameter was changed to a dimension name after a metadata refresh
• Fixed an issue where the Date() function did not work when using the Informix data source 

Content Management

• Fixed an issue where a Presentation export did not include a one-off parameter
• Fixed an issue where a user could not access a Present in Workgroup content after saving an old version
• Fixed an issue a pie file that was exported without related content had failed to import
• Fixed an issue where a user was unable to access public content folders in Favorites
• Fixed an issue where the import replace function did not delete Discovery actions when replacing a Discovery containing an action with one that does not
• When editing a content Description field, clicking outside the field now saves the changes automatically
• Fixed an issue where new imported content was mapped to a deleted materialized model 

Printing/Export

• Fixed an issue where hyperlinks in a grid were not correctly exported to Excel and PDF
• Fixed an issue printing a discovery with a line chart and a measure list to Excel
• Fixed an issue where a grid was printed to Excel with a background color although "Ignore Styling" was checked
• Fixed an issue where a Publication print failed due to an issue with a Map visual
• Fixed an issue where an image in a Present was missing in the printed output
• Fixed an issue where the Document Format of a Publication Print Action could not be changed 

Admin

• Fixed an issue where a customized help URL persisted after changing to a license without White Label
• Fixed an issue that was preventing new users from being added successfully
• Fixed an issue where the Router service could not be restarted from the UI
• Fixed an issue where Administrative Alerts displayed the Machine ID instead of the Machine Name
• Fixed an issue where deleting a user failed due to a large number of items in its Private Folder
• Fixed a "value too long for type character varying(256)" error when adding an Open AI key
• Fixed an issue where a 'Failed Login - Missing authorizationHeader' error appeared in the Entries Logs following a successful Basic Auth login
• Fixed an issue where the Server Instances page showed different times for the same machine

Other 

• Fixed an issue where the Maintenance Tool failed to run due to LogShipper Errors
• Fixed an issue where a Kubernetes deployment timed out when selecting to use an existing repository
• Fixed an issue where "Analyze Further" was not working on an iPad
• Fixed an issue where Data Labels were cut off in a Chart on an iPad
• Fixed an issue which was causing the upgrade to fail when using Helm on Kubernetes
• Fixed an issue where subscriptions were running on a task server configured to run data flows only
• Fixed an issue that was causing multiple "Can't run k8s pod monitor" error messages to appear in the logs after adding a Windows Connecter in Kubernetes
• Fixed an issue where adding a new Python environment using the offline AI pod failed
• Fixed an issue where Illustration Dynamic Color didn't work on Embed in the initial load
• Improved error message for a Migration Destination test failure
• Fixed an issue where no loading icon appeared when loading an embedded presentation with pre-query slicers
• Fixed an issue where deploying Pyramid on OpenShift didn't work with the default YAML
• The Conda version was upgraded to 24.5.0
• Fixed an issue with the number of satellites generated when using the 'load balanced' option in the task engine 
• Various Help improvements