Pyramid 2023.14, a service pack for Pyramid 2023, has been released. It includes fixes with a few minor features. Importantly, it includes the final preview of API 3.0 (beta) which has 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

New Release Framework

Pyramid has announced a new release framework that will come into effect after the 2023.14 release. It also includes announcements of two new upcoming versions, that will supersede Pyramid 2023 "Archimedes"

• Pyramid 2024 LTS "Fibonacci" 
• Pyramid 2025 FVS "Newton"

Please read this post for more information or see the documentation in help.

 New Capabilities and Changes

 

New Features

• Dual certificate swap with Ping1 (Forgerock): allowing reciprocal authentication between Pyramid and the IDP for enhanced security.
• Watsonx LLMs: New support for IBM Watsonx LLMs, to facilitate private or off-line LLM access.
• Log Shipping: new option to ship logs to Splunk
• Online Documentation: the help for the "Present" dashboard module has been significantly overhauled.
• API3 Beta in final preview: After its initial release in Pyramid 2023.10, the API Version 3 is now in its final preview version ahead of the fully supported production version.

Breaking Changes

With the last adjustments being made to API 3, there will be functional breaking changes in this release - related specifically to the "Access" functions.

To see the full listing, please click here.

Technology Updates

Support for new Linux operating systems:

• Ubuntu 24
• Debian 12

 Items Fixed

 

Model

• Fixed an issue where processing a model with Custom Columns had failed
• Fixed an issue where a Calculated Column failed with a NullPointerException when processing a model
• Removed an unneeded space at the end of a new table name based on a query when using the Hebrew UI
• Fixed an issue where partition tables of a PostgreSQL db were not visible in a pyramid model
• Fixed a Date Format issue when using Multi Files in a data flow
• Fixed an issue where a scheduled model referenced the original name after model renaming
• Fixed an issue where an Oracle 'Number' column was converted into dec(19,4)
• Fixed an issue that was causing the Validate Relationship functionality to fail on a BigQuery direct query model
• Fixed an issue where an OLAP data source didn't show cubes in the dataflow for a non-admin user
• Fixed an issue where The ModelProcessedDate did not work with Power BI Datasets
• Fixed an issue where uploading a JSON file as a model source failed with a IndexOutOfBoundException
• Fixed an issue where a Distribution column that was unselected in Tables did not appear in the Select Destination Column dropdown within the Schedule settings
• Added a Convert Decimal to Double checkbox for In Memory targets
• Fixed an issue where Table names in a Model changed depending on the selected UI language
• Fixed an issue that was causing an "ArrayIndexOutOfBoundsException" error to appear in the logs for a successful model process
• Fixed an issue that triggered a "Can't run insert query INSERT INTO etl_progress_log" error when processing a model, even though the model was processed successfully
• Fixed an issue where custom formats in Column Selection were removed after using Change Source in a Data Flow
• Fixed an indexing issue in IMDB
• Removed Marketplace scripts that require an Internet connection from an offline environment
• Fixed an issue where the Contcat function did not work in a Calculated Column
• Fixed an issue where a data flow using a Box source would time out
• Fixed a Master Flow error when opening a model

Discover

      Queries:

• Fixed an issue that was causing a cube action to timeout
• Fixed an issue where slicer results could not be selected when using Advanced Search to find members excluded from the filter due to the 'Slicer Elements Limit'
• Fixed an issue where Drill Path hierarchy levels were not recognized in Discovery
• Fixed an issue where the Grand Total appeared blank for a parallel month calculation
• Fixed an issue where the default value of a "Predefined Parameter" (BW Variable) supplied to Pyramid from BW when belonging to a node of a hierarchy had an incorrect uniqueName
• Fixed a problem where the open and close "carrot" brackets (<, >) weren't handled correctly and were throwing errors while parsing the response from BW. This is only applicable when working in BW with the "Optimize" and "Optimize Compressed" Execution Mode
• Fixed an error in fetching geo locations for Discovery
• Fixed an issue where a Link Back was causing an error in Discovery when the report had a quick filter applied
• Fixed an issue where Grand Totals were still applied to a Chart when the Chart was previously set as a Grid
• Added smarter heuristics to choose how to join the tables in the SQL statement, when the selections are ambiguous in the case of diamond shape models
• Fixed an issue where a Discovery failed to run when there were no default values configured for Model Parameters in SAP BW
• Fixed an issue where a SAP BW Predefined Model Parameters list did not load
• Fixed an issue where a SAP BW Predefined Model Parameters window did not pop up 
• Fixed an issue that was causing extra rows to be added into an IMDB model with outer and inner joins mixed with filtering

      Visuals:

• Fixed an issue where keyboard keys could not be used in a slicer
• Fixed an issue where a member was removed from a Word Cloud chart after changing the orientation from Perpendicular to Horizontal
• Fixed an issue where clicking on a member in a disabled button filter caused that member to remain disabled when the filter was enabled
• Fixed an issue where measures were sorted incorrectly in the Discovery measure selection area
• Fixed an issue where the X-axis vertical label in a Bar chart was offset to the left when using the Hebrew UI
• Fixed an issue where selecting Rows/Columns Totals Only from the grid's context menu did not function properly if totals had already been applied to the grid
• Fixed an issue where making a selection in a multi-select slicer caused a grid to appear blank
• Fixed an issue where the Opacity option was missing for the Shape Map visual
• Fixed an issue where Bubble Map chart data labels ignored the measure Format String
• Fixed an issue where the custom names of slicers were not displayed
• Fixed an issue where adding a Line chart to the Y2 axis in a Waterfall chart was causing an error
• Fixed an issue where the "-" sign appeared to the right of a negative value in Raw and Tabular girds when using the Hebrew UI
• Fixed an issue with inconsistent colors in charts
• Fixed an issue where a disabled Legend title re-appeared after upgrading
• Added a Bookmarks button to the ribbon in Discover Lite
• Fixed an issue that was causing a visual to become blank 

Present

• Fixed a slicer-related issue that was causing a "The resultant attribute of this list does not match the attribute defined for this list" error message to pop up
• Fixed an issue where Model Mapping was removed from a Present following an import
• Fixed an issue where Date Slicer options remained visible after changing the Initial Selection Mechanism in a calendar slicer from Functional to Saved Selection
• Fixed an issue where the Range Slider appeared different depending on the scale mode
• Fixed an issue that was causing 'Cannot Read Properties of Undefined' errors to appear in the System Logs when using Mini Tabs
• Fixed an issue where a "Error loading component" message appeared when clicking on Undo after Add or Dice
• Fixed a blank screen issue after clicking on the 'Interaction Manager' button
• Fixed an issue where Undo and Reset failed to Revert Cross-Visual Interactions
• Fixed an issue where a Chat Bot interaction from within a presentation returned an error while the same interaction from Discovery did work
• Fixed an issue where a custom font intermittently failed to load
• Fixed an incorrect Tooltip alignment issue on a Trellised Chart
• Added the ability to change the size and color of bullet points
• Fixed an issue where an interaction from a grid containing a Custom Column formula failed

Publish

• Fixed an issue where a scheduled publication failed to send when using office365 as the SMTP mail provider
• Fixed an issue where a publication was sent out although the publication schedule was stopped
• Fixed an issue where PQL was not saved when configuring Data Mapping in the Email Distribution settings of a Schedule
• Fixed an issue where Excel attachments that were sent in a scheduled email were removed by the Microsoft Exchange server
• Fixed an issue where a Viewer user was unable to edit a Subscription
• Fixed an issue that was causing duplicate publication outputs to be sent 

Formulate

• Fixed an issue where saving a Formulation with a 'Date Block' had failed
• Fixed an issue where a list that was based on a calculated column and had an Exclude filter failed when using a Snowflake data source
• Fixed an issue where a nested Custom Column formulation failed to run in Discovery
• Fixed an issue where a YTD function was not showing the right result for a PostgreSQL data source

Illustrate

• Fixed a padding issue for an Illustrate in a Matrix Grid 

Content Management

• Fixed an issue where exporting a folder without Related Content did not function as expected
• Fixed an issue where using "Save As" on an older version of content caused the active version to disappear 

Printing/Export

• Fixed an issue where a Slicer that is based on a Custom Column failed to print when Print Slicers was on
• Fixed an issue where printing failed on embedded dashboards
• Fixed an issue where printing a Discovery to Excel failed with a "Cannot invoke "String.equals(Object)" error
• Fixed an issue where a Discover failed to export to Excel 

Admin

• Fixed an issue that was causing a "Could not retrieve service memory for service fs,imdb running on host" error message to appear in the System Logs
• Failed to change the authentication from DB to SAML when using the Disable Users option
• Fixed an issue where the Add Embed Hub button was missing when editing a Hub Template
• Added an option to Pause a data source from the Data Source list to temporarily prevent access
• Fixed an issue where Mistral LLM Provider was not working
• Fixed an issue where AD groups that could not be resolved caused users to be removed from related roles in Pyramid, despite "Use atomic action" being enabled
• Fixed an issue that was causing unnecessary restarts of the IMDB server
• Added a new feature to allow scheduling the Task Engine restart 

API

• Fixed an issue where the FindSchedule API didn't return the tenant ID of a schedule
• Fixed an issue where the Findschedule API returned a blank response for none admins for schedules of deleted content

Other 

• Fixed an issue where the Logs Clean task failed to delete waste files
• Fixed an issue where the position of a Calendar Slicer in an embedded content exceeded the embed-container
• Added support for Kubernetes deployments to enable connections to an IMDB data source located outside the Kubernetes cluster
• Resolved an issue in Kubernetes where the Java process for the task engine was limited to a maximum of 750 MB, regardless of the pod's allocated size
• Fixed an issue where scrolling on a report with multiple columns did not work on the Android app
• Upgraded help
• Fixed an issue where R failed to install during the upgrade On Ubuntu 18
• Fixed a mobile app login issue with older versions of Pyramid
• Fixed an issue where the IMDB server intermittently became unavailable
• Fixed an issue that was causing getPrimaryKeys errors to appear in the System Logs for databricks
• Fixed an issue where OpenID authentication had failed
• Added support for SQL2022 as a repository