Pyramid 2024.05, a service pack for Pyramid 2024 LTS, has been released. This is the fourth service pack for Pyramid 2024, which only includes a driver upgrade and some critical security updates for 3rd party vulnerabilities. 

Note: Pyramid 2024 LTS is now deployed under extended support coverage only, as described here. 

Software

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

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.

Items Fixed

• Upgraded the Snowflake driver to resolve an issue where a model process failed with a “Max retry reached of chunk” error
• Updated a few Java libraries that had security vulnerabilities

Pyramid 2025.03, primarily a maintenance pack for Pyramid 2025 Newton, has been released. It includes fixes for issues, security updates, as well as a small number of upgraded capabilities.

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

Upgrading from Pyramid 2018 or 2020

Upgraded Features

Items Fixed

Model

• Fixed an issue where ETL progress was not displayed for previous runs of schedules triggered via the API 

Discover

      Queries:

• Fixed an issue where drilling down from a custom map hierarchy and deselecting members in a multi-select slicer returned incorrect data

      Visuals:

• Fixed an issue where the bottom borders of URL members did not align in a Discovery grid
• Fixed an issue where "Total Formatting" didn't work on a Tabular grid
• Fixed an issue where small decimal values appeared as NaN in a grid 

Present

• Fixed an issue where a cascaded calendar slicer, based on a modified dynamic custom column, did not reflect updated data when reopening Discovery or Present
• Fixed an issue where copying and pasting a global parameter in Present did not alert the user that it already existed
• Fixed an issue where Parameter Interaction was enabled by default on targets, causing issues interacting with parameterized content. The option is now disabled by default
• Fixed an issue where a PQL function passed via URL did not work in Present
• Fixed an issue where selecting All in a Present cascading slicer did not correctly filter a parameter-based calculation in a grid 

Publish/Subscription

• Fixed an issue where the publication schedule, when the report trigger evaluated to false, remained stuck in a Pending state in the Task Manager
• Fixed an issue where a publication download link did not work if the user was not authenticated when using SAML authentication

Content Management

• Fixed an issue where updating the Description field updated the timestamp but not the Modified By user
• Fixed an issue where opening live-shared content via Gmail while MFA was enabled prompted for login and MFA but redirected to the Home page instead of opening the content
• Fixed a blank screen issue

Printing/Export

• Fixed an issue where exporting a Tabular grid Discovery to CSV omitted certain columns
• Fixed an issue where Grid Totals were Not Exported to Excel
• Fixed an issue where printing a Discovery with Totals to Excel failed
• Fixed an issue where Print to Excel from Extended Operations did not download the file automatically
• Fixed an issue that was causing slow exports to Excel
• Fixed an issue where distributing a file to the file system could fail but still be shown as successful with a green status

Admin

• Fixed an issue where changing an admin type from Enterprise to Domain Admin in SAML/OpenID prompted for a password without displaying an input field
• Fixed an issue where exporting the Transaction Logs failed when using an Oracle repository
• Fixed an issue where newly created users no longer had Proxy Account 1 automatically assigned

Other 

• Fixed an issue where a user could not log in after being enabled via the updateUsers API
• Upgraded ClickHouse and Snowflake drivers
• Online help improvements

Pyramid 2024.04, a service pack for Pyramid 2024 LTS, has been released. This is the fourth service pack for Pyramid 2024, which only includes fixes for key issues and important security updates. 

Software

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

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

 Items Fixed

Model

• Reduced sort memory usage to prevent OutOfMemory errors during high parallel sort/join workloads
• Fixed an issue that was causing Roles to be removed from a Model after importing the same model to a different server
• Fixed an issue where uploading large Google Sheets failed with a 429 Too Many Requests error from the Sheets API
• Fixed an issue that caused missing data when multiple data flows wrote to the same IMDB target
• Fixed an issue where previewing data from a Google Sheet caused a "Error getting excel row"
• Fixed an issue where queries running through a Pulse server returned only first 100 records
• Added BigInteger to Python output column dropdown
• Fixed an issue where a Postgres query to the Pyramid repository failed due to incorrect syntax when a model process failed to run
• Fixed an issue where ETL calculated columns using string comparisons produced incorrect results 

Discover

      Queries:

• Resolved an issue in which enabling caching caused the grid to display an outdated cached view when slicers were updated
• Fixed an issue where an “Explanation” note appeared whenever a regression line was added although 'Show Notes' was off
• Disabled context calculations in the filter dropzone, which were never meant to function as filters
• Fixed an issue where a Parent-Child hierarchy with "Include All Level" and "Roots" orphan handling didn't expand to include the root members
• Fixed an issue where the SAP BW Tree View icon was missing on a New Discovery page
• Fixed an issue that caused a query failure while processing zipped information from SAP BW that contains specific special characters 

      Visuals:

• Removed redundant space from a row header
• Resolved an issue where extra whitespace appeared in rows, occurring only when the second member on the rows was a URL type member
• Fixed incorrect colors in conditional formatting 

Present

• Fixed an issue where a date calendar slicer selection was not injected into a tooltip action
• Resolved an issue causing the tooltip action to appear in an unexpected position within an embedded presentation
• Fixed an issue where a Parameter icon is shown in a direct URL when it should be hidden
• Fixed an issue where embedded presentations in RTL UI were printed to PDF in LTR format
• Fixed an issue where a Tabulate item located in private content was causing a timeout in a Present
• Fixed missing total labels on stacked charts when “No Scale” mode was enabled 

Illustrate

• Resolved an issue in which missing data-source permissions for a single illustration caused other dashboard illustrations to fail
• Fixed line-height not updating when lowering the font size in the Asset Tooltip Designer 

Content Management

• Fixed an issue preventing discoveries from being deleted due to falsely remaining linked to a Presentation

Printing/Export

• Fixed an issue where a Matrix Table in a printed present incorrectly showed the slicer caption as a breadcrumb
• Fixed an issue where certain levels of opacity for text or shapes were not printing when exporting to PPTX
• Fixed an issue where a Dynamic text in a table cell was cut off in a print 

Mobile

• Fixed an issue that caused an infinite loading screen when a user attempted to log into the mobile app

Admin

• Fixed an issue where an error message appeared when attempting to save changes in the Logs Clean task within Task Manager 

Other 

• Resolved a problem that caused the runtime to crash continuously, creating additional runtime engin processes each time
• Fixed an issue where some openID tokens were rejected by Pyramid causing login failures
• Fixed an issue where upgrade failed due to duplicated values in the user_prom_selection table
• Third party libraries with critical vulnerabilities that can be fixed have been upgraded.

Pyramid 2025.02, a feature pack for Pyramid 2025 Newton, has been released. It includes numerous fixes for issues, security updates, as well as a few new features and upgraded capabilities for Pyramid 2025.

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

Upgrading from Pyramid 2018 or 2020

New Features

Other Changes

• Java was upgraded to 21.09
• Full support for RedHat 10 has been added.
• Beta support for Windows 2025 has been added.

Fixed Issues

Numerous issues were addressed in 2025.02. Click here to see the fix listing.

Pyramid 2025.01, a feature pack for Pyramid 2025 Newton, has been released. It includes numerous fixes for issues as well as a sizable collection of new features and upgraded capabilities for Pyramid 2025.

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 Features

Over 50 named New Features were added in 2025.01. Click here to see the feature listing.

Fixed Issues

Numerous issues were address in 2025.01. Click here to see the fix listing.

Pyramid 2024.03, a service pack for Pyramid 2024 LTS, has been released. This is the third service pack for Pyramid 2024, which only includes fixes for key issues and security updates. 

A new version of Pyramid 2023 has also been released.  This is the final release for Pyramid 2023, which is now end-of-life. Customers should migrate over to Pyramid 2024 LTS (which is the same code base as 2023) or upgrade to Pyramid 2025.

Software

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

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

 Items Fixed

Model

• Fixed an issue where ETL Progress was not showing up for previous runs for schedules triggered from a Pyramid Event
• Fixed an issue where Masking was not working for Calculated Columns
• Fixed a Pulse timeout issue that was causing a "Stream has been closed due to timeout of inactivity when using a Pulse Data Source in ETL" error
• Fixed an issue where a deselected column in a SELECT node caused preview failures on AS400 data sources
• Fixed an issue where the database list was empty if a custom JDBC driver did not return catalogs
• Fixed an issue where expanding a table in the editor to access the column list took an unusually long time or failed.
• Fixed an issue where expanding a table in the editor to access the column list took an unusually long time or failed. 
• Fixed an issue where a private role set on a model did not take precedence over a public role
• Fixed a specific scenario that caused a black screen and corrupted the model

Discover

      Queries:

• Fixed an issue where joining tables using a Calculated Column that referenced multiple tables had failed
• Fixed an issue where the first load of a Direct URL report had failed with a 404 error - 
• Fixed an issue that was causing the DayOfWeek function to return unexpected results
• Fixed an issue that caused a query failure while processing zipped information from SAP BW that contains specific special characters
• Fixed an issue where the Discovery row limit set in User Defaults was not applied correctly
• Added explicit handling for Oracle’s inability to cast between varchar and nvarchar automatically
• Text direction settings were added to rows and columns to assist with signs in right-to-left languages. 

      Visuals:

• Fixed an issue where the X-axis labels on a chart became misaligned after adding more data or increasing the label font size
• Fixed an issue where the Total Label position was incorrect in a Stacked Column/Bar chart with negative values
• Fixed an issue where X-axis labels were overlapping each other in a chart with a Range Slide
• Fixed an issue where Data Labels on a line chart were aligned slightly to the left
• Fixed an issue where Legend formatting options didn't work for a regression line
• Fixed an issue that caused a new report to appear blank when using RTL UI language
• Fixed an issue where changes to measure properties in Discover were not applied as expected
• Fixed an issue where chart labels for negative values were missing when the chart was displayed in a small container
• Fixed an issue where the Date Slicer pop-up was cut off in embedded content
• Resolved the inconsistent placement of total data labels for negative values

Present

• Fixed an issue in the Action Panel where Action Settings' Values were not displayed until Edit button was clicked
• Fixed an issue where using a jump action from a direct link would open a new tab with an incorrect URL containing an extra "Direct", resulting in a 404 error
• Fixed an error that occurred when deselecting a list in Slicer Settings with a measure applied in the "Non Empty Filter" and "Hide Empty Hierarchy Members" enabled
• Fixed an issue where a disabled slicer still filtered the target when using Model Mapping
• Fixed an issue where a deleted parameter value remained selected if it had been set as the default
• Fixed an issue where an interaction failed to correctly filter a grid after it was expanded and collapsed
• Fixed an issue where a Master Page that was created for a Theme did not appear when selecting this Theme in a new Presentation
• Fixed an issue where duplicate #ModelProcessedDate text blocks in the content master prevented slides from running
• Fixed an issue that caused the order of mapped hierarchies to change under Model Mapping
• Fixed an issue that was causing inconsistent Insight results
• Fixed an issue where a mini-tab didn't update after changing the slicer selection 

Publish/Subscription

• Fixed an issue where calendar slicers using "current date" with "last X days" did not dynamically update in scheduled reports, causing outdated data to appear in subscriptions and publications
• Fixed an issue where subscriptions failed when Discovery parameters or slicers were changed 

Formulate

• Fixed an issue where the Custom Order didn't work for items with StrToMember

Content Management

• Fixed an issue where saving content that was opened from a Direct URL had failed
• Fixed an issue where non-admin users were unable to see the "Business Logic" icon in certain reports
• Fixed an issue where the Merge functionality failed to update content correctly in certain scenarios 

Printing/Export

• Fixed an issue where a Panel title was incorrectly aligned in a print
• Fixed an issue where Excel export failed if the combined report and page repeater member names exceeded the 31-character sheet name limit 

Mobile

• Fixed a redundant (x) close button in the UI 

Data Sources

• Added support for Microsoft Entra ID authentication for "MS SQL Server Azure and Azure Synapse" data sources

Admin

• Fixed an issue where removing an AI service instance from the server instances did not remove it from the AI servers list, which sometimes caused ML environment reinstalls to fail by referencing an invalid AI server.
• Fixed an issue where auto-provisioning continued running after deactivation

Other 

• Fixed an issue where Roles were not inherited from the parent folder when importing via the API
• Fixed an issue where the Smart Insights close button didn't respond in the iOS App
• Fixed an issue causing the Router service to stop with a "Cannot invoke because 'machineStatus' is null" error
• Fixed an issue that was causing a "Can't run k8s pod monitor" error
• Various help improvements
• Fixed an issue that was causing IMDB connection failures
• Fixed an issue that caused an "Exception while executing batch" error to appear in the System Logs
• Fixed an issue where the Recommendation task caused an out-of-memory error
• Fixed an issue where the login failed with error 500
• Fixed an issue where users could be assigned to roles from other tenants via the API, even when "Enable cross-tenant user roles" was disabled
• Fixed an issue where reusing one of the last 12 passwords with High strength settings caused the password change screen to hang without feedback
• Fixed a member security issue on a parent-child hierarchy
• Fixed an issue with Helm roles. 
  The install files were already released to GitHub as part of the Kubernetes deployment. 

Pyramid 2023.18, a service pack for Pyramid 2023, has been released. This service pack only includes fixes for key issues and security updates. A separate new version of Pyramid 2024 has also been released.

This is the FINAL release for Pyramid 2023, which is now end-of-life. Customers should migrate over to Pyramid 2024 LTS (which is the same code base as 2023) or upgrade to Pyramid 2025. Click here for more details on Pyramid's release protocols.

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

 Items Fixed

Model

• Fixed an issue where ETL Progress was not showing up for previous runs for schedules triggered from a Pyramid Event
• Fixed an issue where Masking was not working for Calculated Columns
• Fixed a Pulse timeout issue that was causing a "Stream has been closed due to timeout of inactivity when using a Pulse Data Source in ETL" error
• Fixed an issue where a deselected column in a SELECT node caused preview failures on AS400 data sources
• Fixed an issue where the database list was empty if a custom JDBC driver did not return catalogs
• Fixed an issue where expanding a table in the editor to access the column list took an unusually long time or failed.
• Fixed an issue where a private role set on a model did not take precedence over a public role
• Fixed a specific scenario that caused a black screen and corrupted the model

Discover

      Queries:

• Fixed an issue where joining tables using a Calculated Column that referenced multiple tables had failed
• Fixed an issue where the first load of a Direct URL report had failed with a 404 error - 
• Fixed an issue that was causing the DayOfWeek function to return unexpected results
• Fixed an issue that caused a query failure while processing zipped information from SAP BW that contains specific special characters
• Fixed an issue where the Discovery row limit set in User Defaults was not applied correctly
• Added explicit handling for Oracle’s inability to cast between varchar and nvarchar automatically
• Text direction settings were added to rows and columns to assist with signs in right-to-left languages.

      Visuals:

• Fixed an issue where the X-axis labels on a chart became misaligned after adding more data or increasing the label font size
• Fixed an issue where the Total Label position was incorrect in a Stacked Column/Bar chart with negative values
• Fixed an issue where X-axis labels were overlapping each other in a chart with a Range Slide
• Fixed an issue where Data Labels on a line chart were aligned slightly to the left
• Fixed an issue where Legend formatting options didn't work for a regression line
• Fixed an issue that caused a new report to appear blank when using RTL UI language
• Fixed an issue where changes to measure properties in Discover were not applied as expected
• Fixed an issue where chart labels for negative values were missing when the chart was displayed in a small container
• Fixed an issue where the Date Slicer pop-up was cut off in embedded content
• Resolved the inconsistent placement of total data labels for negative values

Present

• Fixed an issue in the Action Panel where Action Settings' Values were not displayed until Edit button was clicked
• Fixed an issue where using a jump action from a direct link would open a new tab with an incorrect URL containing an extra "Direct", resulting in a 404 error
• Fixed an error that occurred when deselecting a list in Slicer Settings with a measure applied in the "Non Empty Filter" and "Hide Empty Hierarchy Members" enabled
• Fixed an issue where a disabled slicer still filtered the target when using Model Mapping
• Fixed an issue where a deleted parameter value remained selected if it had been set as the default
• Fixed an issue where an interaction failed to correctly filter a grid after it was expanded and collapsed
• Fixed an issue where a Master Page that was created for a Theme did not appear when selecting this Theme in a new Presentation
• Fixed an issue where duplicate #ModelProcessedDate text blocks in the content master prevented slides from running
• Fixed an issue that caused the order of mapped hierarchies to change under Model Mapping
• Fixed an issue that was causing inconsistent Insight results
• Fixed an issue where a mini-tab didn't update after changing the slicer selection 

Publish/Subscription

• Fixed an issue where calendar slicers using "current date" with "last X days" did not dynamically update in scheduled reports, causing outdated data to appear in subscriptions and publications
• Fixed an issue where subscriptions failed when Discovery parameters or slicers were changed 

Formulate

• Fixed an issue where the Custom Order didn't work for items with StrToMember

Content Management

• Fixed an issue where saving content that was opened from a Direct URL had failed
• Fixed an issue where non-admin users were unable to see the "Business Logic" icon in certain reports
• Fixed an issue where the Merge functionality failed to update content correctly in certain scenarios 

Printing/Export

• Fixed an issue where a Panel title was incorrectly aligned in a print
• Fixed an issue where Excel export failed if the combined report and page repeater member names exceeded the 31-character sheet name limit 

Mobile

• Fixed a redundant (x) close button in the UI 

Data Sources

• Added support for Microsoft Entra ID authentication for "MS SQL Server Azure and Azure Synapse" data sources

Admin

• Fixed an issue where removing an AI service instance from the server instances did not remove it from the AI servers list, which sometimes caused ML environment reinstalls to fail by referencing an invalid AI server.
• Fixed an issue where auto-provisioning continued running after deactivation

Other 

• Fixed an issue where Roles were not inherited from the parent folder when importing via the API
• Fixed an issue where the Smart Insights close button didn't respond in the iOS App
• Fixed an issue causing the Router service to stop with a "Cannot invoke because 'machineStatus' is null" error
• Fixed an issue that was causing a "Can't run k8s pod monitor" error
• Various help improvements
• Fixed an issue that was causing IMDB connection failures
• Fixed an issue that caused an "Exception while executing batch" error to appear in the System Logs
• Fixed an issue where the Recommendation task caused an out-of-memory error
• Fixed an issue where the login failed with error 500
• Fixed an issue where users could be assigned to roles from other tenants via the API, even when "Enable cross-tenant user roles" was disabled
• Fixed an issue where reusing one of the last 12 passwords with High-strength settings caused the password change screen to hang without feedback
• Fixed a member security issue on a parent-child hierarchy
• Fixed an issue with Helm roles. 
  The install files were already released to GitHub as part of the Kubernetes deployment.

Pyramid 2024.02, a service pack for Pyramid 2024 LTS, has been released. This is the second service pack for Pyramid 2024, which only includes fixes for key issues and security updates.  A separate new version of Pyramid 2023 has also been released.

Pyramid 2024.02 LTS "Fibonacci"

Pyramid 2024.02 LTS is a maintenance release for the official Long Term Support version. Pyramid 2024 LTS is designed to offer a longer period of support with security maintenance releases but without the complications of new features. It is functionally equivalent to the latest release of Pyramid 2023, but will be supported well beyond Pyramid 2023's end-of-life schedule (Q2-2025). For a detailed discussion of Pyramid's release strategy, please see the postings in this forum or read more in the online help.

Software

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

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

 Items Fixed

Model

• Fixed an issue where a Variable is not set correctly
• Fixed an SQL type issue for Trino
• Fixed an issue where an unexpected array in an LLM response caused a model process to fail
• Fixed an error that occurred when using a column from a table in an outer join within an Oracle Direct Query model, specifically when the table contained CLOB-type columns
• Fixed an inaccurate BigInt value in the Preview 

Discover

      Queries:

• Fixed a strToMember issue with CurrentMember functions
• Fixed an issue where 'Total Function per Measure' Produced unexpected results
• Fixed an issue where a nested Custom Column functioned as a filter only when "All" was selected
• Fixed an issue where a Discover failed to open with a "Could not find column error"
• Fixed an issue where a filtered list based on a custom column didn't return the right items
• Fixed an issue where Sort didn't work as expected for a chart that uses a dynamic dimension based on a Custom Column
• Fixed an issue where the Explain feature wasn't working when using custom calculations and parameters
• Fixed an issue where an Action didn't pass the Context when using a Custom Column
• Sub querying optimizations 

      Visuals:

• Fixed an issue where a Custom Column sort by global parameter didn't work
• Fixed a Range Slider issue in Firefox
• Fixed an issue where a Discover caused a blank screen upon opening 

Present

• Fixed an issue where Smart Insights failed with a "Cannot read properties of undefined" error
• Fixed an issue where a Jump Action was not working when triggered from a chart that uses a Parameter
• Fixed an issue where drilling down a multi-level hierarchy in a Present caused a "connection closed" error
• Fixed an issue where visualized content from Tabulate failed to load in present
• Fixed an issue where a Present didn’t update after the first slicer change when multiple custom columns with different parameter values were used 

Tabulate

• Fixed an issue where the XIRR formula didn't work in Tabulate 

Publish/Subscription

• Fixed a page trigger issue when using model mapping
• Fixed an issue in Kubernetes environments where subscriptions with the 'Attach Content' option enabled failed to send with a 'No such file or directory' error

Formulate

• Fixed an issue creating Custom Columns when metadata cache is off
• Fixed an issue where NextMember, Lags, and Leads functions returned NULL when a column was sorted as descending in the model

Illustrate 

• Fixed a Text alignment issue in a one-off illustration 

Content Management

• Resolved an issue where items created in Formulate were not appearing in the formula tree when creating a new item
• Improved handling of content opening in cases where its data source has been deleted
• Fixed an issue where Pro users couldn't delete a folder they created 

Printing/Export

• Fixed a scaling issue of a Dynamic text in a present table when printed to PPT
• Fixed an issue where a "Publication print click action" downloaded multiple files
• Fixed a time format error on a measure that caused a print to Excel to fail
• Fixed an issue where a Custom Subtitle in a Publication was not reflected in the Excel Export

Mobile

• Fixed an issue where Labels were cut off when viewing a bar chart on an iPad
• Fixed an issue where clicking a link in a Discovery grid didn't work in a mobile browser 

Admin

• Fixed an issue where the Maximum File Size setting was ignored
• Fixed an issue where "Download logs" for the In-Memory DB failed in a Linux environment where the default location was changed
• Fixed an issue that prevented certain filters in the Transaction Logs from working properly 
• Added support for support for key-pair authentication on SnowFlake

Other 

• Fixed an issue where "Not enough information" appeared in an embedded Present in the initial loading
• Fixed an issue where Prometheus, deployed via Helm, failed due to a missing Content-Type header
• Fixed an issue where the app tabs order couldn't be changed on macOS
• Fixed an issue where a  "Can't create process at schedule" error appeared in the System Logs until a restart of the pods
• Fixed an issue with Pyramid embed using React when installing in the root of the project
• Fixed an IMDB connection issue that caused the IMDB server to become unresponsive 

Pyramid 2023.17, a service pack for Pyramid 2023, has been released. It mainly includes fixes for key issues only. A separate new version of Pyramid 2024 LTS has also been released.

Note: Pyramid 2023 will be out of support by the end of Q2-2025. Customers should be actively planning to upgrade to Pyramid 2024 LTS Fibonacci or Pyramid 2025 Newton. See help for more guidance.

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

 Items Fixed

Model

• Fixed an issue where a Variable is not set correctly
• Fixed an SQL type issue for Trino
• Fixed an issue where an unexpected array in an LLM response caused a model process to fail
• Fixed an error that occurred when using a column from a table in an outer join within an Oracle Direct Query model, specifically when the table contained CLOB-type columns
• Fixed an inaccurate BigInt value in the Preview 

Discover

      Queries:

• Fixed a strToMember issue with CurrentMember functions
• Fixed an issue where 'Total Function per Measure' Produced unexpected results
• Fixed an issue where a nested Custom Column functioned as a filter only when "All" was selected
• Fixed an issue where a Discover failed to open with a "Could not find column error"
• Fixed an issue where a filtered list based on a custom column didn't return the right items
• Fixed an issue where Sort didn't work as expected for a chart that uses a dynamic dimension based on a Custom Column
• Fixed an issue where the Explain feature wasn't working when using custom calculations and parameters
• Fixed an issue where an Action didn't pass the Context when using a Custom Column
• Sub querying optimizations 

      Visuals:

• Fixed an issue where a Custom Column sort by global parameter didn't work
• Fixed a Range Slider issue in Firefox
• Fixed an issue where a Discover caused a blank screen upon opening 

Present

• Fixed an issue where Smart Insights failed with a "Cannot read properties of undefined" error
• Fixed an issue where a Jump Action was not working when triggered from a chart that uses a Parameter
• Fixed an issue where drilling down a multi-level hierarchy in a Present caused a "connection closed" error
• Fixed an issue where visualized content from Tabulate failed to load in present
• Fixed an issue where a Present didn’t update after the first slicer change when multiple custom columns with different parameter values were used 

Tabulate

• Fixed an issue where the XIRR formula didn't work in Tabulate 

Publish/Subscription

• Fixed a page trigger issue when using model mapping
• Fixed an issue in Kubernetes environments where subscriptions with the 'Attach Content' option enabled failed to send with a 'No such file or directory' error

Formulate

• Fixed an issue creating Custom Columns when metadata cache is off
• Fixed an issue where NextMember, Lags, and Leads functions returned NULL when a column was sorted as descending in the model

Illustrate 

• Fixed a Text alignment issue in a one-off illustration 

Content Management

• Resolved an issue where items created in Formulate were not appearing in the formula tree when creating a new item
• Improved handling of content opening in cases where its data source has been deleted
• Fixed an issue where Pro users couldn't delete a folder they created 

Printing/Export

• Fixed a scaling issue of a Dynamic text in a present table when printed to PPT
• Fixed an issue where a "Publication print click action" downloaded multiple files
• Fixed a time format error on a measure that caused a print to Excel to fail
• Fixed an issue where a Custom Subtitle in a Publication was not reflected in the Excel Export

Mobile

• Fixed an issue where Labels were cut off when viewing a bar chart on an iPad
• Fixed an issue where clicking a link in a Discovery grid didn't work in a mobile browser 

Admin

• Fixed an issue where the Maximum File Size setting was ignored
• Fixed an issue where "Download logs" for the In-Memory DB failed in a Linux environment where the default location was changed
• Fixed an issue that prevented certain filters in the Transaction Logs from working properly 
• Added support for support for key-pair authentication on SnowFlake

Other 

• Fixed an issue where "Not enough information" appeared in an embedded Present in the initial loading
• Fixed an issue where Prometheus, deployed via Helm, failed due to a missing Content-Type header
• Fixed an issue where the app tabs order couldn't be changed on macOS
• Fixed an issue where a  "Can't create process at schedule" error appeared in the System Logs until a restart of the pods
• Fixed an issue with Pyramid embed using React when installing in the root of the project
• Fixed an IMDB connection issue that caused the IMDB server to become unresponsive 

Pyramid 2025  - codenamed "Newton" - is the next major release of the Pyramid Decision Intelligence platform. It includes over 75 new named features together with numerous functional upgrades, unnamed features, and fixes.

This release significantly expands on the platform’s embedded analytics capabilities. It marks a milestone in delivering functionality to suit the augmented analytics needs of Pyramid’s current and future OEM partners while improving in-house embedded solutions for enterprise customers. This release also includes dozens of enhancements and features requested by Pyramid users and customers in the user community and other venues.

Feature Version vs Long Term Support Version

Pyramid 2025 Newton is a major FEATURE VERSION release. It includes numerous new features and capabilities together with bug fixes. With Pyramid's new release protocol, as described here, customers who wish to deploy the platform on a more conservative basis should use the more stable Pyramid 2024 Fibonacci LTS release track. Those wishing to try out newer features and capabilities can deploy the "FVS" release instead.

Key bug fixes added into Pyramid 2025 will also be released as well as part of an upgrade to Pyramid 2023 Archimedes and Pyramid 2024 Fibonacci in the next few weeks.

New Version Details

Visit the official release page for Pyramid 2025 for details on the key new functions and capabilities.

• The embedded search bar, significantly enhanced formatting capability for embedded content and the database Xtender greatly enhance and simplify creating Pyramid embedded applications, especially for multi-tenant and OEM solutions.
• The version includes over 55 specific customer requested features collected from the forum and other venues, representing nearly 75% of the new or enhanced named features. A listing with links back to the originating post can be found here.
• A complete detailed list of the new and upgraded named capabilities can be found on the version key features listing page - which includes explanations and links to blogs and demo videos on the most significant new functions. 
• A separate listing of bug fixes in the version can be found here.

Software

The installer files for Pyramid 2025 can be downloaded from the Pyramid Customer Portal. Help for upgrade installations can be found here.

• 2025 containers for Kubernetes-based deployments have also been released on Docker and can be downloaded for deployment. The HELM scripts for Kubernetes have also been updated.
• Updates to the Embed APIs for new and upgraded 2025 capabilities have also been posted to NPM.
• Updates to mobile apps have also been released.

Release Notifications

Upgrade Warning

Pyramid 2023.16 a service pack for Pyramid 2023, has been released. It includes fixes for key issues only. A separate new version of Pyramid 2024 has also been released.

Note: Pyramid 2023 will be out of support by the end of Q2-2025. Customers should be actively planning to upgrade to Pyramid 2024 LTS Fibonacci  or the upcoming release of Pyramid 2025 Newton. See help for more guidance.

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

 Items Fixed

Model

• Fixed an issue where an Or operator in a join criteria caused an error when used in Discovery
• Fixed an issue where a Custom Column translation did not work in a Discovery
• Fixed an issue where unexpected values appeared in a Python output column
• Improved the error message when trying to union two tables with mismatched column orders for better clarity
• Fixed an issue where changing a Pyramid Content source item resulted in a blank screen
• Improved error message for a scenario where uploading a text file that is larger than the upload limit fails
• Fixed an issue where the Edit button did not function after adding multiple Excel files via "Shared Folder"
• Fixed an issue where Excel files could not be deleted from a Multifile source
• Fixed an issue that caused slow SSO data source connections

Discover

      Queries:

• Fixed a cache-related issue that was causing outdated data to display in a Custom Column
• Fixed an issue where queries with custom measures were not getting cached
• Fixed a Null Pointer Exception while editing a Discover with filters
• Fixed an issue where a report that was opened in Analyze Further was filtered incorrectly
• Fixed an issue that was causing unexpected Totals result in a report that had a calculated measure filtered by a sorted list
• Fixed an issue where a text measure based on an attribute failed to appear in the grid when the attribute was added to the report

      Visuals:

• Fixed incorrect axis labels in an IBCS Waterfall chart
• Fixed an issue where the Theme dropdown was missing from a Discover Lite after a report is duplicated
• Fixed an issue preventing two items in the same attribute from being set as a Circle in the Shape drop zone
• Fixed an issue where the IBCS Waterfall Chart turned blank after replacing the attribute in Categories
• Fixed an issue that was causing values in a grid to be cut off when using Conditional Formatting Indicators vertically aligned to center 

Present

• Fixed an issue where slicers located at the edge of the slide did not expand as expected
• Fixed incorrect filter selection after de-selecting items in a cascading slicer
• Fixed an issue where the Initial Selection in a 'Multi-Select Tree' filter was limited to 50 members
• Fixed a 'parameter has no input' error when opening a presentation with a Switch list
• Fixed an issue where a Presentation slicer was causing a visual to appear blank
• Fixed an issue where the "Jump to Tab" action in a mini tab, based on a member selection caption, was not working
• Fixed an issue where advanced model mapping between two hierarchies with a different number of levels was not working

Tabulate

• Fixed an issue where the Tabulate cell selection format was not retained after reopening
• Fixed incorrect formatting when using Solve

Formulate

• Fixed a blank screen issue when creating a parameter based on an attribute with a null member
• Fixed incorrect dynamic caption when using  Custom Columns
• Fixed a multi-nested date offsets issue that was causing the AddDays and AddMonths functions to behave unexpectedly
• Fixed an issue where a calculation creation failed with a "Cannot desctructure property id" error

Content Management

• Fixed an issue where Python scripts were not visible for non-admin users
• Fixed a scrolling issue in the Recent Activity panel
• Fixed an issue that was causing multiple versions to appear for a Discovery under Versioning

Printing/Export

• Fixed an issue where line feeds were removed from an export to PowerPoint
• Fixed an issue where rotated assets were cropped when printing
• Fixed an issue where RTL text boxes and report titles were misaligned in a print
• Fixed a vertical alignment of text object issue when printing to PowerPoint
• Fixed an issue that was causing incorrect data to appear in an Illustrate when exporting the entire present
• Fixed an issue where OLAP content failed to export to Excel
• Fixed an issue where a Custom Font sometimes was not displayed in a PDF
• Fixed an issue where a min tab print was cut off
• Fixed an issue printing a report with custom columns to a CSV file
• Fixed incorrect totals in a Tabular grid print to Excel
• Fixed an Excel printing issue when using SAP BW
• Fixed a time format issue in an Excel print

Admin

• Fixed an issue where a 1001 error appeared after accessing the Source Manager and Server Instances
• Added a new Warehouse name field to fix an issue where a Microsoft Fabric connection failed when the Azure App Registration didn't have Permissions to at least one Warehouse
• Fixed an issue where Cross tenant roles didn't appear in the Data Model Manager
• Fixed an issue where the Query Timeout setting on the Data Source Limit page was not functioning properly
• Fixed an MS Fabric data source connection issue when using the Service Account Authentication Method 

Other 

• Fixed an issue where the Logs Clean task failed to Delete server_log_transactions_texts
• Fixed an issue deleting waste files
• Improved German translation in Conversation
• Various online help improvements
• Fixed an issue where, in some cases, a viewer user could log in directly to Pyramid when using SAML authentication
• Fixed an iPhone app login issue
• Added support for EKS version 1.31 onwards when installing Pyramid on Kubernetes
• Updated jQuery and JavaScript versions
• Fixed an issue where the Diagnostic page incorrectly used LDAP to test AD connections when Pyramid was configured to use LDAPS
• Fixed an issue that caused Java Store Cacerts files to become corrupted
• Fixed an issue in Kubernetes deployment where the GIS pod failed to connect when Internal Network Encryption was enabled
• The IP address of the internal web server is now hidden on the diagnostic page for users who are not authenticated to Pyramid

Pyramid 2024.01 LTS "Fibonacci" has been released. This is the first service pack for Pyramid 2024 which only includes fixes for key issues and security updates. 

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

Pyramid 2024.01 LTS includes a number of changes to existing capabilities. As such, Pyramid recommends that the new release be tested on a duplicate version of an existing content database repository before any production upgrades are applied.

Further, a database repository backup should be made before upgrading any production systems and repositories.

Pyramid 2024.01 LTS "Fibonacci"

Pyramid 2024.01 LTS "Fibonacci" is a maintenance release for the official Long Term Support version. Pyramid 2024 LTS is designed to offer a longer period of support with security maintenance releases but without the complications of new features or significant changes in functionality. Pyramid 2024 is functionally equivalent to the latest release of Pyramid 2023, but will be supported well beyond Pyramid 2023's end of life schedule.

It is possible to upgrade from a number of previous releases to this 2024 LTS release.  If you decide to adopt the 2024 LTS version release and then decide later that a particular feature in a later "Feature Version" release of Pyramid (say Pyramid 2025), you can comfortably upgrade from an LTS release to a later FVS release (say 2024.01 to 2025.01). It is NOT possible to move backwards in the release cycle, for example from 2025.0 FVS to 2024.0 LTS.

For a detailed discussion of Pyramid's LTS release strategy please consult the "Release Framework" document previously published in this forum or read more in the online help.

We are continually working to make Pyramid the best platform in the market for solving the most difficult problems through industry leading analytics.  Customer feedback and input are key to us being able to do just that. 

Pyramid analytics would like to invite you to take part in the beta testing of Pyramid 2025 Newton. We anticipate the initial on premise, installable version to be available Friday 21st February 2025, or soon after.

Taking part in the beta testing process allows you to get an advance preview of the new and enhanced features available with the new release and gives you the ability to test your existing solutions against the new release.

If you would like to take part, please email me, Ian Macdonald, VP Product Management at Pyramid at ian.macdonald@pyramidanalytics with your contact details and further information will be provided on how to download, install and report issues to get you started on our beta program.

As aways we appreciate your partnership and trust.  We look forward to continuing to support your success with Pyramid Analytics.

Best regards,

Ian

It is recommended that any Pyramid 2020 deployments be upgraded to either the latest versions of Pyramid 2023 or Pyramid 2024 LTS (the long term support version). Since Pyramid 2023 is near end of support as well, Pyramid 2024 is highly recommended.

Pyramid 2025 will be released by the end of Q1 2025, which is another upgrade option. Of course, customers can upgrade to Pyramid 2024 LTS and then to Pyramid 2025 at a future date.

For a broader explanation of Pyramid releases and lifecycles, please see help.

Pyramid 2024 LTS "Fibonacci" has been released. It is a Long Term Support version designed for stable functionality with extended security maintenance, but without new features over its lifetime. 

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

Pyramid 2024 LTS includes a number of changes to existing capabilities. As such, Pyramid recommends that the new release be tested on a duplicate version of an existing content database repository before any production upgrades are applied.

Further, a database repository backup should be made before upgrading any production systems and repositories.

Pyramid 2024 LTS "Fibonacci"

We are delighted to announce the availability of the first official Long Term Support version: Pyramid 2024 LTS "Fibonacci".

Pyramid 2024 LTS is designed to offer a longer period of support with security maintenance releases but without the complications of new features or significant changes in functionality. Pyramid 2024 is functionally equivalent to the latest release of Pyramid 2023, but will be supported well beyond Pyramid 2023's end of life schedule.

Pyramid 2024 LTS will be supported for a period of two and a half years with key functional fixes available till the middle of 2025, followed  by critical security fixes until the end of its life in 2027. During this time, however, no new features will be introduced to the version. This gives customers an option to deploy a stable, unchanging platform that has the reliability for mission critical  analytic workloads.

It is possible to upgrade from a number of previous releases to this 2024 LTS release.  If you decide to adopt the 2024 LTS version release and then decide later that a particular feature in a later "Feature Version" release of Pyramid (say Pyramid 2025), you can comfortably upgrade from an LTS release to a later FVS release (say 2024.0 to 2025.1). It is NOT possible to move backwards in the release cycle, for example from 2025.0 FVS to 2024.0 LTS.

For a detailed discussion of Pyramid's LTS release strategy please consult the "Release Framework" document previously published in this forum or read more in the online help.

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

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

In 2023.14, some changes were made to functions, itemized below, that will break any prototypical code built using either the API3 REST or SDK libraries. All changes relate to the "ACCESS" function list - and were made to optimize the structure and remove duplication.

Name and Signature Changes

Function Input Changes

Function Output Changes

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 Models Only permission doesn't show the Semantic model for a non-admin user
• 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

Starting in Q4-2024, Pyramid Analytics will offer a new software release framework, providing a choice between ‘Long Term Support’ and ‘Feature Version Support’ releases. We are delighted to be able to offer additional options in our release approach to give customers a wider scope for how to deploy Pyramid.

Long Term Support (LTS) is a product lifecycle management policy in which a stable release of computer software is maintained for a longer period than the standard ‘feature’ edition.

Feature Version Support (FVS) is a term that describes the software's standard or ‘feature’ edition. FVS software has a comparatively short life cycle and includes new, cutting-edge features.

Pyramid will therefore offer two version tracks in its new release framework:

• LTS: Delivered every EVEN year. It is supported for 2.5 years; does NOT include new features; and will only include critical security fixes.
• FVS: Delivered every ODD year with both features and all on-going fixes (service packs “SP”).

This approach allows customers to choose how they wish to implement Pyramid: a stable, unchanging version for 2.5 years or the shorter lifecycle version which incorporates the latest features and enhancements. Importantly, customers can always switch between tracks provided they always switch to a later release.

New Pyramid Releases

Pyramid 2023 will reach end of standard support in Q4-2024, with extended support for key bugs and its ‘end of life’ by the Summer of 2025.

Pyramid 2024 LTS, code named “Fibonacci,” is due for release in Q4-2024. This version will provide the off-ramp for customers wanting to use the LTS track from Pyramid 2023 “Archimedes”.

Pyramid 2025, code named “Newton,” is due for release in Q1-2025, providing the alternative ‘feature version’ off-ramp from Pyramid 2023.

Please click here  to delve into more detail on the new release framework or see the release documentation in help.

Watch a recording of our explanatory webinar on 1st October 2024 for further explanations. If you have Questions, please reach out to your Customer Success Manager or our Support Team.

Webinar Recording:

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

Pyramid 2023.12, a service pack for Pyramid 2023, has been released. It primarily includes fixes with a few small features. It also includes support for newer operating systems. 

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

Technology: Additions and Deprecations

 Repository Databases

Pyramid 2023.12 will be the last Pyramid release to support these versions of databases for the Pyramid repository.

• SQL Server 2012
• PostgreSQL 11
• Oracle 10c

Note, that this does NOT apply to using these database versions as an analytic data source. 

 Operating Systems

Pyramid 2023.12 now provides support for newer versions of various operating systems:

• RedHat 9 Linux
• Oracle 9 Linux
• Amazon 2023 Linux

Pyramid 2023.12 will be the last version of Pyramid to support Windows Server 2012. 

Support for these operating systems will be ending in the near future as well:

• Red Hat Enterprise Linux 7
• CentOS 7
• Ubuntu 16 and 18

Customers should start planning now to migrate any Pyramid instance running on these operating systems to newer editions.

For further details, please see the posting Discontinued support for EOL operating systems and databases 2024 in the Product Knowledgebase Forum.

 New Capabilities and Upgrades

Pyramid 2023.12 is primarily a maintenance release for the 2023 "Archimedes" release series. However, there a few new features and upgrades. 

• Gen-BI Enhancements: Ability to add dynamic text tooltip for slide insights into Present slide. This speeds up the page loading by only populating the Slide Insights only when the tooltip is triggered. See help for more. 
• Model Data Sources: Google Drive is now supported as a Source and Target for Model Data Flows.
• Present Panels: Updated interface for Panel formatting, making it easier and more intuitive to use inline with other formatting options. See help for more.
• OData: Updated framework (and UI) for accessing OData endpoints to authenticate with web tokens in Excel or Power BI. See help for more.
• White labeling option: New option for user defined icons in Webhooks for Teams or Slack. See help for more. 
• Upgraded Excel Publications: Excel workbook tabs will now incorporate slicer values into their names when they are used in page repeaters. See Community Forum here and here, or see help for more.
• Conditional Publication Distributions: New option to limit auto-distribution to "Completely Successful" publications only. See Community Forum. See help for more.
• Present Slicer Unlinking: Added the ability to unlink a slicer from its parent Discover to enable editing of the slicer elements. See Community Forum.  See help for more.

 Items Fixed

Model      

• Fixed an issue where a decimal measure erroneously appeared as an integer in Discover following the addition of a date range to the underlying model
• Fixed an issue where Sort Descending did not work with sort-by column
• Fixed an issue where the Gen-AI nodes in the Data Flow ignored a custom New Column Name
• Fixed an issue where a Database Query variable reverted to the first item in the Database dropdown after saving
• Fixed an issue where an Unsigned Int column was converted to String when using an Oracle source
• Fixed an error that occurred when attempting to use S3 buckets containing a "." (period) in the name as model Source
• Fixed an issue where the page became unresponsive after selecting a source database that had a very large number of tables
• Fixed an issue causing slow loading times in the Model page of a Direct Query
• Fixed inaccurate aggregation of Decimal type values with multiple digits after the decimal point in IMDB models
• Added a Process Timeout setting for the Execute Process node in the Master Flow
• Fixed an issue where previewing the tables of a large Excel file when utilizing Named Ranges & Tables was causing instability in the Runtime Engine
• Fixed an issue where source tables in the data flow were de-selected after exporting and importing the Model file from one environment to another
• Fixed an issue where the LLM General node failed with a NullPointerException if there was a Null value in the selected column

Discover

      Queries:

• Fixed an issue where members in a Parent-Child Hierarchy were sorted incorrectly in the selection tree
• Improved error messages when using wrong parameters in the 'hasdatapoints' function
• Fixed an issue where a query failed with a "dimension attribute was not found" error
• Fixed an issue where "Show Key & Text" displayed leading zeros in the Key in a Discovery created with a SAP BW data source
• Fixed an issue where a report with a Parent-Child Hierarchy was filtered incorrectly
• Fixed an issue where a report that was using a Rank calculation had failed after switching from Metrix to Tabular
• Fixed an issue where an empty member (--) was removed from a multi-select filter after saving the report
• Added the options for top-down and bottom-up totals for SQL
• Fixed inconsistent Grand Totals results of a First Child/Last Child measure 

      Visuals:

• Fixed an issue where the X-axis label location in a Scatter plot did not match the value
• Fixed an issue where clicking a legend item in a Line chart failed to gray out the other lines
• Fixed an issue where Bar chart data labels were cut off
• Fixed an issue where the dimension description did not appear when hovering over the dimension in the Discovery Dimension panel
• Fixed an issue where Wrap Text added a redundant additional space in Grid rows
• Fixed an issue where the size of the dimension properties description tooltip was too small
• Fixed an issue where the first category label of the x-axis was out of center after changing the chart category padding
• Improved performance for opening and printing a Discovery with a Tabular Grid
• Added a spinner to indicate when the query runs after making a selection in a pre-query filter when using an embedded discovery

Present

• Fixed an issue where Data from a tabulation was not seen in a Presentation
• Fixed an issue where a line appeared above a Buttons filter when Clean style was applied
• Fixed an issue where a disabled slicer in a Presentation was enabled in Analyze Further
• Fixed an issue where changing the initial selection of a slicer had failed in a case where that slicer had highlight interaction configured from another slicer
• Fixed an issue where a Cascading filter failed with a "Feature not supported: correlations in where-clause of a group-by-select" error when using an Exasol data source
• Fixed a role access issue that occurred after clicking on re-run queries
• Fixed an issue where Analyze further didn't respect the manual query execution setting
• Fixed an issue where the Undo button failed to reverse interactions from a visual element to a placeholder
• Fixed an issue where changing the rotation of a line shape didn't update the X and Y positions accordingly
• Fixed an issue where content in mini tabs showed no values in the second tab when filtered by a measure filter
• Fixed an issue where the slicer selection order affected the query results
• Fixed an issue where an empty column in a Tabulation visual area was not displayed correctly in a Presentation
• Fixed an issue where deleted content still appeared under Used Content and the Interaction Manager

Tabulate

• Fixed an issue where adding a formula to Favorites failed to save properly
• Fixed an issue where it was not possible to complete a formula criteria after switching between sheets
• Fixed an issue where a Discovery grid with top totals was imported incorrectly into a Tabulation
• Fixed an issue where a Data function that was using string values produced an error
• Fixed an issue where indicators were incorrectly applied to all members after a slicer change 

Publish

• Fixed an issue where a role marked as hidden was available on the Subscription Distribution screen
• Fixed an issue where a publication containing a page repeater was not correctly printed to Excel 

Formulate

• Fixed an issue where OLAP and Tabular servers were visible when creating a new Calculated Column Logic
• Fixed an issue where a formula with a Dynamic Caption sometimes appeared with the formula caption in a grid 

Illustrate

• Fixed a role access issue related to a measure that was used in an illustration 

Content Management

• Fixed an issue where using Drag and Drop to move a folder with many items resulted in a timeout.
• Fixed an issue where the Structure Analyzer continued to alert about previously resolved issues
• Fixed an issue wherein exporting or employing copy/deep paste functionality with a large group of content items resulted in an "update conflict" error.
• Fixed an issue where Analyze Structure failed with 502 and Runtime errors
• Fixed an issue where running the Data Source Changer on a migrated folder had failed with a 3008 error
• Fixed an issue where presentation slide modifications were not updated visually in the Content Management preview
• Fixed an issue where a scroll bar was missing from the "affected items" list in the Data Source Changer 

Printing/Export

• Fixed an issue where printing failed with a NullPointerException error
• Fixed an issue where a Publication failed to print due to a Table of Content error
• Fixed an issue where a line was missing from the grid in a Discovery that was exported to an A4 PDF
• Fixed an issue where a missing slicer caused the Present print to fail
• Fixed an issue where an incorrect header text appeared for measures in a gird that was exported to Excel
• Fixed an issue where Bullet Point Lists were formatted incorrectly when exporting to PowerPoint
• Fixed an issue where a presentation print to Excel had failed with a "The workbook already contains a sheet named..." error
• Fixed an issue where the exported master page of a Present/Publication to PowerPoint defaulted to A5 despite selecting A4 Page Type
• Fixed an issue where an Extra blank page was added to a publication with a page repeater
• Improved printing performance 

Admin

• Fixed an issue where the "Login help link" did not work when using Windows Authentication
• Fixed an issue where the Schedule Name column filter dialogue in the Task Manager no longer showed the schedules that have run
• Fixed an issue where the System Details were showing a wrong memory count on Azure VMs
• Fixed an issue where licenses were unassigned from tenants after an upgrade
• Fixed an issue where users couldn't be added despite having available license seats 
• Extended username size from a 50-character limit to 150 characters
• Fixed an issue where the Admin Hub intermittently showed a negative number for active requests on the NLP service

Other Items

Security

• The linkback URL is now encrypted

• The latest critical vulnerabilities in 3rd party components have been addressed

API

• Fixed an issue where API2/dataSources/updateSourceNodeConnection did not work for SQL script nodes in the master flow of a Model
• Fixed an issue where validateMasterFlow did not show an error when the model is a direct query
• API3 (still in beta) and its related client SDKs has been adjusted further to make the new API system more stable and easier to user

Miscellaneous

• Fixed an issue where an error message erroneously appeared during the upgrade of the second server in a multi-installation setup, despite the upgrade being successful
• Fixed an issue where a Kubernetes deployment of Pyramid allowed a hyphen in the DB name which was not accepted by the Pyramid installer
• Fixed an issue where installing Pyramid with a SQL 2012 repository had failed
• Fixed an issue where embedding content using Angular 17 had failed
• Fixed an issue where clicking the expand icon in a dashboard didn't open the discovery in full-screen view in the mobile application
• Fixed an issue where maps failed to load within embedded content under specific circumstances 
• Fixed incorrect Hebrew translation of attribute Type "State"
• When running an LLM query, Pyramid will now show a clear message in case the request is too large for the language model to handle 
• Upgraded Help
• Replaced several vulnerable 3rd party libraries

Pyramid 2023.11, a service pack for Pyramid 2023, has been released. It includes new and upgraded features  - with a big focus on AI-related functionality - as well as numerous fixes.

Software

• The main installer files can be downloaded from the Customer Portal. 
• Docker containers have been upgraded for Kubernetes deployments.

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 Upgrades

Watch a 2 minute Demo of our Chatbot AI-Designer for Present and Publish. Read Details in our Help Pages

 Items Fixed

Model

• Fixed an issue that caused the page to become unresponsive when making changes in the SQL query and Python Script editors
• Fixed an issue where a Variable returned a server error when List was selected in the Variable Settings
• Fixed an issue where a Filter, that is based on a List Sting Variable, did not work
• Fixed an issue where the Preview failed in a data flow where the source is SAS Datasets
• Fixed an issue where changing multi-measure display names did not stick
• Fixed an issue where importing an Excel into an existing data flow did not map columns correctly compared to the source file
• Fixed a "No Authorization" error when previewing variable on a Snowflake source
• Fixed an issue that caused a Model to be renamed
• Fixed a blank screen issue when switching to the Data Model tab
• Fixed an issue where a Union failed if the two string columns had different length
• Fixed an issue where a Schedule failed for a Model with multiple Set Variables
• Fixed an issue where users could not edit files uploaded to a Multi Files source
• Fixed an issue where the time intelligence for Fiscal Year erroneously displayed incorrect Quarters and years.
• Updated the NetSuite driver in the Marketplace
• Fixed an issue where a user couldn't process a model when one of the roles was a Model Only role 

Discover

      Queries:

• Fixed an issue where a Context Min/Max function on a Date column returned incorrect values
• Fixed an issue where adding a Filter to a report resulted in a "Failed to Parse Query" error
• Fixed an issue where a Custom Sort Order was not saved after running the query
• Fixed an issue where the List Builder returned wrong members in OLAP
• Fixed an issue where a report stopped responding after using the List Builder in OLAP
• Fixed an issue where exporting the results of the Show Details action in a OLAP report was failing
• Fixed an issue where a report failed to open with a "Request Error - can't run the given query" error
• Fixed an issue where a Show Detail/Cube action failed when connected to an OLAP cube using a service account

      Visuals:

• Fixed an issue where the bar chart color changed when switching between measures using a List
• Fixed an issue where blank labels appeared in the grid
• Fixed an issue where a "dimension attribute was not found" error appeared after adding a hierarchy to a report
• Fixed an issue where Wrap Text in a Tabular Grid generated extra space
• Fixed a blank screen issue that occurred when changing a value in a numeric filter
• Changed the fill pattern of bar charts with Diagonal Stripes from dashed lines to solid lines
• Fixed an issue where Business Logic pop-ups occasionally failed to disappear upon hovering off them in the tree
• Fixed an issue where Bookmarks were being reset when using slicer with 'First' or 'Last' Member
• Fixed an issue where Subtotals appeared for attributes that were unselected in the Totals Panel
• Fixed an issue where setting a large font for a slicer didn't extend the slicer visual box
• Fixed an issue where map visualization labels were not correctly aligned
• Fixed an issue where custom map shapes were not properly highlighted upon clicking
• Fixed an issue setting custom values for Label Font Size in the Formatting panel
• Fixed an issue where the correct options were not displayed when right-clicking a List in a Discovery and selecting "Create Formula"
• Fixed an issue where incorrect values appeared for data labels after resizing the Range Slider on a 100% stacked bar chart
• Fixed a Column/Bar chart issue where the data labels' background color affected the entire bar/chart 

Present

• Fixed an issue where text was cut off in a Matrix table
• Fixed an issue where Data Interactions from a visual to a dynamic text didn't work
• Fixed an issue where a Dynamic Text didn't change when dicing on its query
• Fixed an issue where a Dynamic Text stopped working after editing it
• Added an indication for the currently selected Text Alignment state
• Fixed a pre-defined slicer issue that was preventing a Presentation from running
• Fixed  a blank screen issue occurring after copying and pasting content from a closed source presentation to another
• Better handling of incorrect URL parameters in a report that was opened using a Jump to Content action
• Fixed an issue where a present failed to open with a "Request Error - There was an error opening the file" error

Tabulate

• Fixed an issue where applying the "Comma Style" formatting to a negative value resulted in the appearance of two minus signs in a publication and a present
• Fixed a blank screen issue after using VLOOKUP between two different sheets

Publish

• Fixed an issue where a scheduled publication with a page repeater was printing the same page
• Fixed a Trigger issue that caused schedules to fail

Formulate

• Fixed an issue where clicking on "Explain Code" in the PQL Editor failed with "Request Error - Server Error Occurred" error message
• Fixed an issue where an If statement within a list did not return the expected value
• Fixed an issue where a formulation failed with a "Compilation of calculation failed: null" error
• Fixed an issue where the Result Preview did not appear for a Custom List that was based on a Hierarchy
• Fixed an issue where a formulation stopped responding after hovering over text in Script Mode

Content Management

• Fixed an issue in which Analyze Structure encountered a "Model not found" error, despite the model not being utilized in the item on which the Analyze Structure operation was executed
• Fixed an issue where a Viewer user could not open a folder after import
• Fixed an issue where Workgroup Content appeared for an Enterprise Admin although the option was disabled for the tenant
• Fixed an issue where the Data Source Changer failed for a Domain Admin
• Fixed an issue where a formula became inaccessible after a rename
• Fixed a Domain Admins content saving issue 

Printing/Export

• Fixed column Order and Sort issues in a tabular grid that was exported to CSV
• Fixed an issue where the Excel sheets of an exported Present appeared in the wrong order after slide rename
• Fixed an issue where some items were misaligned in a PDF print
• Fixed a number formatting issue in Excel
• Fixed a print failure issue when Pyramid is installed on Windows 2012
• Fixed an issue where a print to Excel failed with a "The maximum number of Cell Styles was exceeded" error
• Fixed an issue where some of the slicers were missing when printing to PDF or HTML using "Print Slicers"
• Fixed an issue where decimal values were lost when exported to Excel
• Fixed an issue where a report with a specific calculation failed to print to Excel
• Fixed a formatting discrepancy between a Present printed from runtime and one printed from the Subscription
• Fixed an issue where the right boarder of a grid in a Tabulate did not appear in the print
• Fixed an issue where Text in the Cover Page was missing in the print
• Fixed a discrepancy in font sizes between Pyramid and printed PDFs
• Fixed an issue where an illustration was printed to a PDF with a wrong color
• Fixed an issue where Linkback from PDF did not open the report with the correct filters selections

Admin

• Corrected inaccuracies in the Audit Trail Details
• Fixed an Attribute Security issue where a dimension still appeared in a Discovery report even if all dimension attributes where hidden
• Fixed an issue where the User Group Cache task wasn't running at the configured time
• Fixed an issue where the Pulse option did not appear for an Amazon redshift data source

Other

• Fixed an issue where no content appeared under the Group and Public folder in the mobile app if the app language was Hebrew
• Fixed an issue where embed content could not be accessed with a basic user
• Various online help improvements
• Fixed an issue where the runtime and task services did not start after an upgrade
• Fixed an issue were Kubernetes Deployment could not be initialized if there was no internet connection 
• Fixed an issue where a Task Summary for a cancelled ETL showed error 5400 instead of a clear message
• Removed verification for users' phone numbers 

Pyramid 2020.30  - a service pack for Pyramid  2020 - has been released. It includes a large collection of fixes. A separate service pack (2023.10) for Pyramid 2023 has been released. 

Last "2020" Release

Release 2020.30 is the last official release for "Pyramid 2020." Customers still on the 2020 version should be in the process of evaluating and testing "Pyramid 2023" so the next upgrade is seamless and issue free.

After deploying 2020.30, customers must upgrade to version 2023.10 or later.

Software

• The main installer files can be downloaded from the Customer Portal. 
• There is no containerized version of 2020.30.

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.

Cautions

Pyramid 2020.30 includes changes to existing capabilities. It builds on other changes made since the last major release (2020.20). Please consult the notes for all versions from 2020.20 onwards on this forum to understand the impact on your deployment.

As such, Pyramid recommends that the new release be tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

Items Fixed

Model

• Fixed an issue where using BigQuery as a destination was not possible when set to utilize a service account
• Fixed an issue where an Azure Databricks source did not show the list of databases
• Fixed an issue where the properties panel for Multi Files sources failed to refresh upon navigating through various Multi Files sources
• Fixed an issue where using a column with a data type of “interval day(0) to second(0)” in a Custom Query, resulted in a blank screen
• Fixed an issue where the "Time to keep model processing logs" setting in a schedule was set by default to Always instead of System Default
• Fixed an issue where a column data type was erroneously set to Date instead of DateTime

Discover

    Queries

• Fixed an issue where a Discovery that was using a Parent-Child hierarchy did not retrieve data as expected
• Fixed an issue where a "The PQL function 'EXIST' is not supported" error message appeared after using cascading filters
• Fixed an issue where using Focus on a member in a grid returned no results
• Fixed an issue where custom ordering calculations with parameters no longer allowed parameters to impact the results

    Visuals:

• Fixed an issue saving small decimal values in the Conditional formatting band fields
• Fixed an issue where Conditional Formatting Data bars did not appear for negative values when using the % Of Max algorithm
• Fixed incorrect order of values in the Legend when using the Hebrew UI language
• Fixed an issue where long member names in Hebrew were cut off from the right instead of from the left
• Fixed an issue where text in a grid was wrapped although Wrap Text was off
• Fixed an issue where labels were cut off in a Tornado chart
• Fixed an issue where adding certain dimensions and measures to a report resulted in a blank screen

Present

• Fixed an issue where swapping an attribute with a hierarchy in a Present resulted in an error
• Fixed an issue where the Reset button in runtime did not refresh the data as expected
• Fixed an issue where an Illustration, based on a measure with applied Overlay, was not properly filtered in a Present
• Fixed a presentation-related issue leading to out-of-memory errors in the InMemory server
• Fixed an issue where clicking on a bubble map did not update the visuals when interaction was set
• Fixed an issue where selecting "All" in a cascading filter caused a query to fail

Publish/Subscriptions

• Fixed an issue where a report with a dynamic date filter did not update based on the filter as expected
• Fixed an issue where Publications and Subscriptions didn't run until they were resaved
• After importing a publication and using Replace All, the schedule became inactive; however, it continued to run
• Fixed an issue where the Page Repeater was printing the same page

Formulate

• Fixed an issue when using a BW source where a list that used a global parameter in a Contains filter had failed
• Fixed an issue where a formula didn't return the caption of a hierarchy current member
• Fixed an issue where a comment in script mode caused the formulation to fail

Illustrate

• Fixed an issue where a duplicated illustration did not run

Content Management

• Fixed an issue where items could not be deleted or purged
• Fixed an issue where using Cut and then Replace on a different folder, did not remove the content from the source folder
• Fixed an issue where the contents of workgroup folders were not visible to viewers
• Fixed an issue where replacing a model definition that was owned by a different user had failed
• Fixed an issue where content that was moved/copied did not get the correct roles
• Fixed an issue where replacing a Model timed out and failed
• Fixed an issue where a Viewer user was able to access a folder but could not access its child folders
• Fixed an issue where Discoveries did not work as expected after being overwritten using the API
• Fixed an issue where folders appeared in a reversed alphabetical order
• Improved layout of the "Delete Contentions on Shared Item" panel
• Fixed an issue where using Cut & Paste & Replace from Private Content to Public Content did not add roles to the content

Printing/Export

• Fixed an issue where a Dynamic Text in a Presentation was printed incorrectly
• Fixed an issue where legend colors were incorrect on a printed publication
• Fixed an issue where a Matrix Grid with a large number of visuals did not print correctly in Present
• Fixed an issue where a measure that is formatted as Currency did not show the currency symbol when printing to Excel
• Fixed an issue where exporting a discovery consisting solely of measures to Excel resulted in a format that was not compatible with pandas in Python
• Fixed an issue where, if the caption of a measure was modified, printing from embed displayed the original caption instead of the updated one
• Fixed an issue where a measure list didn't print to CSV/EXCEL when in a raw/tabular grid

Admin

• Fixed an issue where the System Schedule failed to open
• Fixed an issue where the Task Manager did not show error messages
• Fixed an issue where new Provisioning jobs could not be created
• Fixed an issue where Additional Parameters were not sent properly on a Snowflake connection
• Fixed an issue where Weka files didn't get deleted automatically
• Corrected inaccuracies in the Audit Trail Details

API

• Fixed an issue where /API2/content/getFolderItems did not bring back deleted items
• API2/content/createNewFolder will now automatically apply a role to the folder if created in Workgroup content

Mobile

• Fixed an error when using a Jump action on the iPad

Other

• Fixed an issue where adding services on upgrade, the added services did not start
• Improved login performance
• Online help improvements
• When deploying Kubernetes, the metrics server is now only accessible internally
• Fixed an issue that was causing PROM errors to appear in the system logs 

Pyramid 2023.10 has been released. As a 'minor' release for the 'Archimedes' version of Pyramid, it includes a collection of fixes and over 85 new and enhanced capabilities. Over 80% of the features are based on suggestions from customers and ideas in the Product Ideas forum.

Software

• The main installer files can be downloaded from the Customer Portal. 
• Docker containers have been upgraded for Kubernetes deployments.

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.

Special Directive for Oracle Database Repositories

If you have an older installation of Pyramid (prior to version 2020.28) or one that has been upgraded subsequently from a pre-2020.28 version, the adjustment described here needs to be applied BEFORE UPGRADING to 2023.10. 

Cautions

New Features

Over 85 New Features were added in 2023.10. Click here to see the feature listing.

Fixed Issues

Numerous issues were address in 2023.10. Click here to see the fix listing.

Pyramid 2023.01 (Service Pack 1 for 2023.00) has been released. It includes a collection of fixes and multiple new capabilities.

Software

• The main installer files can be downloaded from the Customer Portal. 
• Docker containers have been upgraded for Kubernetes deployments.

2023.01 is a service pack for Pyramid 2023. A separate service pack (2020.29) for Pyramid 2020 has also been released. Both address similar bugs (where relevant), but new features are only available in 2023.01.

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

Pyramid 2023.01 includes changes to existing capabilities. As such, Pyramid recommends that the new release be tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

New Features

There has been a tranche of new capabilities and features added in 2023.01 - with two significant new capabilities. Many other features are based on suggestions from customers via the forum (linked below) or from other feedback. 

Multi-Lingual Semantic Models

New options have been added to let designers create multi-lingual data/semantic models. This includes options to use ChatGPT for auto-translation of metadata structures.

Multi-lingual models will allow different users to view the same analytic content in different languages, different numeric format styles and different date styles - without needing to create multiple versions of the content or model.

Pre-Query Slicers/Filters*

A new capability has been added to set specific slicers (data filters) as 'pre-query slicers'. This will prompt users to make selections on these items before opening a Discover report or Present dashboard.

*This capability is in beta so customers can test it out as part of the official release. However, it should not be used on production content until the next release.

Other Features

• New connectors for SAP Datasphere and SAP HANA Cloud (beta)
• New option to enable direct query on custom data sources (added through custom connectors)
• Update support for Power BI Premium Workspaces to handle Multi Factor Authentication
• New 'service account' authentication options for Google BigQuery
• New "Wait" node in master flow to handle flow pauses
• New ability to search slicers with a list of multiple items (without using the existing List Builder)
• New option to print slicers in Present dashboards
• New "Next" and "Previous" slide Jump Actions in Present
• New option to tag users (with '@') when writing comments in conversations and workflows
• New ability to show total data labels for Stacked Charts
• New ability to create/add custom reference lines on a chart
• New option to choose the delimiter character for CSV exports
• Improved mechanics for changing the owner of scheduled items when the original user is deleted
• New 'gridline' show/hide option in Tabulate
• Improved handling of Parent-child hierarchies and unary operators with report Actions.
• New support for Oracle 8 Linux operating systems

Items Fixed

Model

• Fixed an issue where the left side of existing Joins was missing and set to Select in the dropdown
• Fixed an issue where the scroll bars were flashing in the Model Editor depending on the browser zoom level
• Fixed an issue where the data flow failed to run when using an Access file from a shared file source and multi-select
• Fixed a blank screen issue that appeared when changing tabs after processing a model
• Fixed an issue in aggregate tables where users couldn't select a measure in the target column when the source column was an integer type
• Fixed an issue where the Type setting in the Convert Columns node was changed to the default setting
• Fixed an issue where a Custom Query didn't show any of the tables when using an Access source and shared file
• Fixed a Model Mapping issue that caused a report that was opened with Analyze Further to be filtered incorrectly
• Fixed an issue where a model with a Hebrew database name created a new DB in every process if Create New Database was enabled
• Fixed an issue where after creating a custom HTTP Request Field in a JSON file source using Advanced Expression, the value did not save
• Fixed an issue where after converting a column from double to string, the column was formatted incorrectly
• Fixed an issue where tables did not appear in the data flow when using an Athena data source
• Fixed an issue where renaming a column that has the same name as another column, could rename both columns
• Fixed an issue where the Preview failed when using a Variable in a custom SQL
• Fixed an issue where it was not possible to inject a variable into a model through Calculated Column

Discover

    Queries

• Fixed an issue where a report based on SAP BW that was using From To parameters had failed with an MDX error
• Fixed an issue where a report that was opened from an Action when using a Parent-Child hierarchy was filtered incorrectly
• Fixed an issue where Actions > Show Details produced a 'clause is out of range...DRILLTHROUGH MAXROWS 500000...' error
• Fixed an issue where an ODBC connection showed as a data source in Discovery
• Fixed an issue where after adding or removing items in the dropzones, the list of items in the dropzone jumped to the top
• Fixed an issue where after jumping to a Content Item when both the source and target reports had the same items on rows and columns and Include Context was enabled in the Action setting, the target report was filtered incorrectly
• Fixed an issue where an Except function with a NULL element failed compilation
• Fixed an issue where an error message appeared when trying to sort using a Parent-Child Hierarchy
• Fixed an issue where a Last Child measure didn't return the correct value
• Fixed an issue handling Boolean data in an IMDB formulation

    Visuals

• Fixed an issue where after renaming measures using properties, the change did not save
• Fixed an issue where the Dicing menu was cut off after the first 40 dimensions
• Fixed an issue where lines did not show under the member names in an Accounting grid
• Fixed an issue where using Copy Row on a Tabular or Raw grid did not work as expected
• Fixed an issue where data labels in a chart did not appear when using custom scale bounds
• Fixed an issue where the Table Handles setting overwrote the Border setting
• Fixed an issue that was causing the X-axis labels to be misaligned with the column's position in a columns chart
• Fixed an issue where the Language setting was not retained in a Discovery after migrating it to a different environment
• Fixed an issue where the Business Logic folder button was missing in a Discovery
• Fixed an issue where the Actions option did not appear in the context menu of a visual for Viewer
• Fixed an issue where using a large font size in a Filter caused the last item in the filter to be cut off

Present

• Fixed an issue where Highlight interaction into a mini tab did not work after switching tabs
• Fixed an issue where a mini tab action did not work when there were multiple mini tabs in the slide
• Fixed an issue where clicking the “Workflow for Report” button changed the look of the report
• Fixed an issue where the ChatBot did not respond in Present until it was invoked in Discover
• Fixed an issue where a presentation that contains filters with All selected had failed to load
• Fixed an issue where Data Interaction between reports in mini tabs couldn't be used after resetting the slide
• Fixed an issue where slicers were missing from a Present that was imported from a pie file
• Fixed an issue where cascading filters that were created in a Present could incorrectly appear empty

Tabulate

• Fixed an issue where a Named Range in an Excel import did not work as expected
• Fixed an issue where after importing an Excel, the font in the Tabulate was different than the Excel font
• Fixed an issue where an Excel file that was exported from Tabulate only had static values in the cells instead of formulas
• Fixed an issue where slicing a report with date calculated member by date returned empty cells

Publish/Subscriptions

• Fixed an issue where legend items had different colors in the print
• Fixed an issue where subscription emails sometimes didn't have the content attached
• Fixed an issue where an error message appeared when trying to view the summary of a publication schedule that was stopped after a Report Trigger evaluation
• Fixed an issue where some elements sometimes didn't appear in a scheduled publication output
• Fixed an issue where report trigger names appeared as ??? when the triggers were based on a discovery that had  a name in Hebrew

Formulate

• Added UserProxyAccount2 function under Identity functions  

Illustrate

• Fixed an issue where Grid Rows were misaligned in Dynamic Text box when there was a scroll bar for the columns
• Fixed an issue where very long text added to Shapes tooltips caused a blank screen
• Fixed an issue where changing an object size caused the position setting to reset

Content Management

• Fixed an issue where saving a discovery report caused the client to become unresponsive
• Fixed an issue where after importing an Excel file to a Tabulate, the Tabulate couldn't be saved
• Fixed an issue where it was not possible to access the Private folder of another user using a direct link
• Fixed an issue where searching for a user and then clicking on the user's private content in the search results caused the client to freeze
• Fixed an issue where Hebrew model names appeared as ??? In the data source changer

Printing/Export

• Fixed a print from embed issue that was causing the te_schedule db table to grow in size
• Fixed an issue where printing a presentation to Excel with a NoSuchElementException" error

Admin

• Fixed an issue where an error message appeared after clicking on Services > Server Instances
• Fixed an issue where after adding an Athena connector, the runtime engine required a restart for the driver to work
• Fixed an issue where the Tenant list was not sorted alphabetically
• Fixed an issue where the System Logs did not log the username of a user that tried to access an endpoint that doesn't exist
• Added an option to not log 404 errors in the System Logs
• Added a new "Use Default Measure" checkbox to resolve a performance issue that might occur when using "Characteristic Structures" in BW
• Fixed an issue where the Connection to PBI Workspace failed with a '400 Bad Request' error

API

• Fixed an issue where /API2/content/getFolderItems didn't return the result description
• Fixed an issue where API2/content/findContentItem didn't return the result tenantID
• Fixed an issue where /API2/access/updateUserOpenId didn't update the user's roles

Other

• Fixed an issue where the installer presented an error when trying to use an existing SQL RDS DB
• Fixed an issue where reusing an existing DB showed a "upgradeContent failed" error
• Fixed an issue in Discover Tutorial 1 where it was not always possible to drop a measure in the dropzones
• Fixed an issue where the Help menu did not clear after clicking out of it
• Fixed an issue where the Pulse service failed to start with a "java.lang.NullPointerException: Cannot invoke "String.isEmpty()" because "segment" is null" error
• Fixed an issue where the IMDB stopped working with a "Caused by: Failed to write table: PyramidException: Not Authenticated or Connected" error
• Fixed an issue where dotnet was not installed when Installing Pyramid 2023.00.361 on Oracle Linux 7
• Online help improvements
• Fixed Duplicate SQL Statements on Login
• Fixed an issue where Embedding did not work when using Windows Authentication

Security

Resolution of the latest critical and high vulnerabilities found in third party components.

Pyramid 2020.29 (Service Pack 8 for 2020.20) has been released. It includes a collection of fixes for issues.

Software

• The main installer files can be downloaded from the Customer Portal. 
• Docker containers have been upgraded for Kubernetes deployments.

2020.29 is a service pack for Pyramid 2020. A separate service pack (2023.01) for Pyramid 2023 has been released. Both address similar bugs (where relevant), but new features are available in 2023.01 only.

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

Pyramid 2020.29 includes changes to existing capabilities. It builds on other changes made since the last major release (2020.20). Please consult the notes for all versions from 2020.20 onwards on this forum to understand the impact on your deployment.

As such, Pyramid recommends that the new release be tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

Items Fixed

Model

• Fixed an issue where the left side of existing Joins was missing and set to Select in the dropdown
• Fixed a Model Mapping issue that caused a report that was opened with Analyze Further to be filtered incorrectly
• Fixed an issue where a model with a Hebrew database name created a new DB in every process if Create New Database was enabled
• Fixed an issue where a Join between an integer column to a decimal column showed an empty Relationship dropdown
• Fixed an issue where after creating a custom HTTP Request Field in a JSON file source using Advanced Expression, the value did not save
• Fixed an issue where after converting a column from double to string/biginteger, the column was formatted incorrectly
• Fixed an issue where tables did not appear in the data flow when using an Athena data source
• Fixed an issue where renaming a column that has the same name as another column, could rename both columns

Discover

    Queries

• Fixed an issue where a report based on SAP BW that was using From To parameters had failed with an MDX error
• Fixed an issue where a report that was opened from an Action when using a Parent-Child hierarchy was filtered incorrectly
• Fixed an issue where Actions > Show Details produced a 'clause is out of range...DRILLTHROUGH MAXROWS 500000...' error
• Fixed an issue where an ODBC connection showed as a data source in Discovery
• Fixed an issue where after jumping to a Content Item when both the source and target reports had the same items on rows and columns and Include Context was enabled in the Action setting, the target report was filtered incorrectly
• Fixed an issue where an Except function with a NULL element failed compilation
• Fixed an issue where an error message appeared when trying to sort using a Parent-Child Hierarchy
• Fixed an issue where a Last Child measure didn't return the correct value

    Visuals

• Fixed an issue where after renaming measures using properties, the change did not save
• Fixed an issue where lines did not show under the member names in an Accounting grid
• Fixed an issue where using Copy Row on a Tabular or Raw grid did not work as expected
• Fixed an issue where the Table Handles setting overwrote the Border setting
• Fixed an issue that was causing the X-axis labels to be misaligned with the column's position in a columns chart
• Fixed an issue where the Language setting was not retained in a Discovery after migrating it to a different environment
• Fixed an issue where the Business Logic folder button was missing in a Discovery
• Fixed an issue where using a large font size in a Filter caused the last item in the filter to be cut off

Present

• Fixed an issue where Highlight interaction into a mini tab did not work after switching tabs
• Fixed an issue where a mini tab action did not work when there were multiple mini tabs in the slide
• Fixed an issue a Present with mini tabs froze after interacting with the visuals in the mini tabs and resetting the query
• Fixed an issue where clicking the “Workflow for Report” button changed the look of the report
• Fixed an issue where Data Interaction between reports in mini tabs couldn't be used after resetting the slide
• Fixed an issue where slicers were missing from a Present that was imported from a pie file
• Fixed an issue where cascading filters that were created in a Present could incorrectly appear empty

Publish/Subscriptions

• Fixed an issue where legend items had different colors in the print
• Fixed an issue where some elements sometimes didn't appear in a scheduled publication output
• Fixed an issue where report trigger names appeared as ??? when the trigger was based on a discovery that had a name in Hebrew

Formulate

• Added UserProxyAccount2 under Identity functions

Illustrate

• Fixed an issue where Grid Rows were misaligned in Dynamic Text box when there was a scroll bar for the columns
• Fixed an issue where very long text added to Shapes tooltips caused a blank screen

Content Management

•  Fixed an issue where saving a discovery report caused the client to become unresponsive
• Fixed an issue where it was not possible to access the Private folder of another user using a direct link
• Fixed an issue where searching for a user and then clicking on the user's private content in the search results caused the client to freeze
• Fixed an issue where Hebrew model names appeared as ??? In the data source changer

Printing/Export

• Fixed a print from embed issue that was causing the te_schedule db table to grow in size
• Fixed an issue where printing a presentation to Excel with a NoSuchElementException" error

Admin

• Fixed an issue where after adding an Athena connector, the runtime engine required a restart for the driver to work
• Fixed an issue where the System Logs did not log the username of a user that tried to access an endpoint that doesn't exist
• Fixed an issue where after changing a user from Pro to Viewer, the user kept the limitations of the Pro profile he had assigned
• Added a new "Use Default Measure" checkbox to resolve a performance issue that might occur when using "Characteristic Structures" in BW
• Fixed an issue where a Connection to PBI Workspace failed with a '400 Bad Request' error

API

• Fixed an issue where /API2/content/getFolderItems didn't return the result description
• Fixed an issue where API2/content/findContentItem didn't return the result tenantID
• Fixed an issue where /API2/access/updateUserOpenId didn't update the user's roles

Other

• Fixed an issue in Discover Tutorial 1 where it was not always possible to drop a measure in the dropzones
• Fixed an issue where the Master Router kept changing in an environment with two routers
• Fixed an issue where the Reuse DB option with old version DB had failed during an installation on Linux
• Fixed an issue where the IMDB stopped working with a "Caused by: Failed to write table: PyramidException: Not Authenticated or Connected" error
• Online help improvements
• Fixed Duplicate SQL Statements on Login
• Fixed an issue where Embedding did not work when using Windows Authentication

Pyramid 2020.28 (Service Pack 8 for 2020.20) has been released. It includes a large collection of fixes for bugs and issues.

2020.28 vs Pyramid 2023

Pyramid 2023, the new major version of the Pyramid platform was released last week. It includes many new capabilities and features. It also includes numerous bug fixes for issues found in previous releases.

2020.28 is a service pack for the previous major version, Pyramid 2020. It captures many of the same bug fixes for issues found in previous releases (where relevant). However, 2020.28 obviously does NOT include any of the new capabilities. 

Therefore, customers wishing to upgrade their existing Pyramid instances to resolve issues can use either 2020.28 or 2023.00. However, 2020.28 will be the better choice for those customers wishing to upgrade without introducing the new functional changes and application upgrades of Pyramid 2023, until they have had a chance to test it.

There will be further service packs for Pyramid 2020 till the end of calendar year 2023 covering issues found in the platform. However, their focus will be on critical items only.

Software

• The main installer files can be downloaded from the Customer Portal. 
• Docker containers have been upgraded for Kubernetes deployments.

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

Pyramid 2020.28 includes changes to existing capabilities. It builds on other changes made since the last major release (2020.20). Please consult the notes for all versions from 2020.20 onwards on this forum to understand the impact on your deployment.

As such, Pyramid recommends testing the new release on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

Items fixed

Model

• Fixed a visual issue where relationships disappeared after processing a model
• Fixed an issue where the Model failed to retrieve the table list of an Oracle data source
• Added "Show More" and "Copy to Clipboard" buttons to error messages that appear in the SQL Editor
• Fixed an issue in the master flow where links between nodes in the For Each loop got removed after moving them
• Fixed an issue where a For Each loop stopped running after 1000 iterations
• Fixed an issue that was causing a hierarchy order to change
• Fixed a "Cannot read properties" error when connecting to Microsoft Access data source
• Fixed an issue where it was not possible to run a Custom Query on a Microsoft Access File
• Fixed an issue where a Python script node error did not present a clear error message: AttributeError: 'NoneType' object has no attribute 'shape' changed to "outputDF is not a data frame"
• Fixed an issue where an Azure Blob source, only some of the files appeared in the Select a File dropdown
• Fixed an issue where Pyramid tried creating unique indexes when processing a direct query with Azure Synapse
• Fixed a mapping error when using Unpivot when the UI language is set to Hebrew
• Fixed an issue where elements that were dragged into a large data flow appeared in the wrong location when using the Hebrew UI language
• Fixed an issue where Table Preview in the data flow on a BigQuery DB was using select *
• Fixed an IRDB paging issue that caused a specific query to return inconsistent results
• Fixed an issue where processing a model based on BigQuery, which was using OAuth had failed with an "OAuth2Credentials instance does not support refreshing the access token" error
• Fixed a "Table does not exist" error when running a data model that writes to BigQuery
• Fixed an issue where incorrect roles were assigned to a new/imported model

Discover

    Queries

• Fixed an issue where  a query failed when using two Parent Child hierarchies and an AVG formula in a report
• Fixed an issue where a Search in a global parameter filter did not work
• Fixed an issue where a report appeared blank after a change to a combined elements filter
• Quick sort by values is now disabled when the cross-axis is empty
• Fixed an issue where using Change Caption on a BW attribute caused the measure format to change
• Fixed multiple cache issues
• Fixed an MDX error when using an MTD calculation on SAP BW
• Fixed an issue where Grand Totals were calculated incorrectly in an OLAP cube
• Fixed an issue where a discover failed to run with a "failed run SQL query in model source" error when loaded

    Visuals

• Fixed an issue where a line chart was cut off when the chart had a zero value and Auto Scale Bounds
• Fixed an issue where the Custom Y-axis Scale bounds did not allow negative values
• Fixed an issue where a report did not show results when moving between visuals unless Autorun was on
• Fixed an issue where some X-Axis labels were cut off
• Fixed an issue where axis values appeared with a scientific notation
• Fixed an issue that was causing the browser to crash when switching between Discovery tabs
• Fixed an issue where the Dimension Panel and Data Source information did not load in a Discovery report
• Fixed an issue where a Viewer user in Analyze Further could not add a Longitude measure into the Map Location dropzone
• Fixed a slicer issue that was causing a blank screen when clicking analyze further
• Added a new "Always start from 0" option in the Scale Bounds, allowing to hide negative values

Present

• Fixed a cascading filter issue which was causing the interacted content to fail after selecting all items in the filter
• Fixed an issue where adding multi-select tree filters from the same hierarchy to a Present caused the filters to keep loading
• Fixed an issue where targets could not be added to a tiled presentation
• Fixed an issue where a report in Analyze Further could not be modified
• Fixed an issue where a parameter that was dragged from a discover to a present could be set as a tree slicer
• Fixed an issue where a direct link to a Present opened the wrong present when using OpenID while in Incognito mode
• Fixed an issue where a filter did not run when running the presentation
• Fixed an Interaction issue from a grid to a mini tab
• Fixed an issue where changing the initial selection of a calculation that used a global parameter caused an error
• Fixed an issue where the Dynamic Text did not update on a Cover Page
• Fixed an issue where Present Mini tabs failed to load after clicking on undo/reset
• Fixed an issue where a Present based on a SQL data source was timing out after an upgrade to 2020.27
• Fixed an issue where multiple grid rows were highlighted after clicking on a single item on rows
• Fixed an issue where grid colors in mini tabs disappeared after moving between tabs

Publish/Subscriptions

• Fixed an issue where a change to the subscription time of a Presentation caused its filter selection to reset to the default value
• Added paging to the Schedule Manager for Viewer Users
• Fixed an issue where schedules stopped running due to a time zone change
• Fixed an issue where a subscription was printed with an incorrect filter selection
• Fixed an issue where bold text in a Publication was not applied to a printed PowerPoint output
• Fixed an issue where deleted filter caused a scheduled job to fail

Formulate

• Fixed an issue where a format string behaved differently after an upgrade
• Fixed a blank screen issue when editing a parameter

Illustrate

• Fixed an issue where a dynamic illustration was updated incorrectly based on a filter selection

Content Management

• Fixed an issue where a message saying "There was an error opening the file" appeared when trying to run or edit a Present
• Fixed an issue where the Search results returned deleted content for a Viewer user
• Fixed an issue where a user couldn't create folders under Workgroup content
• Fixed an issue where a user couldn't delete/purge items
• Fixed an issue where data sources marked as Favorites did not appear in the Favorites panel

Printing/Export

• Fixed an issue where exporting a Publication to PowerPoint had cut-off columns of the grid when using Scale to fit
• Fixed an issue where a pdf export was blank after exporting a map in discovery and selecting the No Scale option
• Fixed an issue where exporting to CSV did not work for a Tabular gird with Sort enabled
• Fixed an issue where a print to CSV contained the filter selection of the report
• Fixed an issue where a shape used as a background of a grid appeared on top of it in a print
• Fixed an issue where a drill-through action export contained more records than expected
• Fixed an issue where printing a tiled presentation with an illustration to a PDF produced a blank print
• Fixed an issue where zero values in a grid did not appear in an Excel export
• Fixed a formatting issue in Excel with content that contained multiple charts
• Fixed an issue where a Unicode character that appeared in an Excel print prevented creating a calculation within the Excel
• Fixed an issue where a hyperlink from a publication\presentation did not work in Word
• Fixed an issue where the order of elements in a grid was different between runtime and printing

Admin

• Fixed an issue where the "Reset Password Every XX Months" when using Database Authentication did not work as expected
• Fixed an issue where a SQL Connection parameter caused a connection error
• Fixed an issue where a Mongo DB connection did not work through Pulse
• Fixed an issue where NULL server name values got added to the db after an upgrade and caused an error when trying to view the databases in the Admin Console
• Fixed a Multitenancy issue where a domain admin could not view a data source on a different tenant
• Fixed an issue where an admin couldn't set up the auth method to Windows auth alternative account for SQL server
• Fixed an issue where changing Database List Technique did not reflect in the UI
• Fixed an issue where making bulk changes to the role security in the Data Source Manager did not take the selection in the Tenant Name filter into account
• Fixed a SQL data source connection issue where Pyramid did not use the custom port in the Port field
• Fixed an issue where the Pyramid ad groups failed to sync when using an Oracle repository
• Fixed an Azure Synapse connectivity issue after the 2020.27 upgrade
• Fixed an issue where testing a Databricks connection failed with a missing JDBC connector error
• Fixed an issue where an error 500 occurred when setting up the Oauth data source with incorrect details
• Fixed an issue where errors appeared in the system logs each time a user who didn't have access to the internet logged in
• Added a new "Enable characteristic structures" checkbox in the SAP BW server setting to fix an issue where BW measures appeared as attributes
• Fixed an issue where if Provisioning was disabled, Pyramid still tried to sync the AD groups set up in Provisioning jobs based on the "AD sync time interval" setting or when Run Now was clicked in the System Schedule
• Fixed an issue where Pyramid always used Sync Method 1 when clicking on Run Now in the System Schedule
• Fixed an issue where the System Info did not show accurate RAM info
• Added the option to manually enter a project name into the Big Query data source connection settings
• Added support for the "af-south-1" region for Amazon Athena
• Fixed an issue where a "Snapshot isolation" error appeared after uploading a new license

API

• Fixed an issue where purging a folder using the API didn't purge all the subfolders
• Fixed an issue where Pyramid showed an empty Proxy Account 2 after using /createUserSaml and adding a proxy2 value
• Fixed an issue where /access/getUser showed the principle name as the proxy account
• Improved performance of findcontentItem

Mobile

• Fixed an issue where the iPhone PyramidMobileAuth header had no value when logging in through SAML
• Fixed an issue where a preset that was opened with a Direct Link on an iPhone didn't resize correctly after rotating the screen
• Fixed an issue where the mobile application used the English UI language, although Hebrew was selected
• Fixed an issue where interactions didn't work as expected in a dashboard that was opened with a direct link on a mobile device
• Fixed an issue where a filter was unresponsive in a Present on the mobile app
• A new Android app version has been published

Other

• Fixed an issue where a Present appeared with the desktop layout when running on a tablet
• Fixed an issue where the upper toolbar of the iPhone was overlying the Present
• Fixed an issue where the size of bubbles on a map was inconsistent between a report and a report snapshot in a conversation
• Fixed an issue where after upgrading to Pyramid 2020.27, users couldn't log in via OpenID when using a proxy
• Fixed an issue where Snowflake OAuth failed to insert a token into the database or read it
• Fixed an OpenID log-in issue where it was not possible to log in due to a missing / in the redirect URL
• Fixed an issue where OpenID failed to authenticate when an array was sent in the OAuth Token
• Fixed an OpenID log-in issue after upgrading to 2020.27
• Fixed an issue where Pyramid was unreachable after restarting the routers
• Fixed an installation failure issue when using Oracle 19c as a repository
• The Pyramid Maintenance Tool now works on Linux

Pyramid 2023  - codenamed "Archimedes" - is the next major release of the Pyramid Decision Intelligence platform. It includes over 80 new named features together with numerous functional upgrades, unnamed features, and fixes: all designed to make Pyramid the leading Decision & Business Intelligence Platform in the market  - driving confident insights and decisions around complex business problems and ultimately producing results.

New Version Details

Visit the official release page for Pyramid 2023 for details on the key new functions and capabilities.

• The version includes over 60 specific customer requested features collected from the forum and other venues. A listing of all the implemented product ideas driven from this forum is available here.
• A complete detailed list of the new and upgraded named capabilities can be found on the version key features listing page - which includes explanations and links to blogs and demo videos on the most significant new functions. 
• A separate listing of bug fixes in the version can be found here.

Software

The installer files for Pyramid 2023 can be downloaded from the Pyramid Customer Portal. Help for upgrade installations can be found here.

• 2023 containers for Kubernetes-based deployments have also been released on Docker and can be downloaded for deployment. 
• Updates to the Embed APIs for new and upgraded 2023 capabilities have also been posted to NPM.

Ongoing Support for Pyramid 2020

🗉 A new service pack (2020.28) for the previous major version ("Pyramid 2020") has been released. It contains fixes for customer issues resolved in 2023 that are relevant to 2020.

2020.28 will allow customers to remain with the previous version until they have had time to test and deploy 2023. New service packs for 2020, covering critical bugs, will continue until the end of 2023. 

Details on 2020.28 can be found here.

Release Notifications

Upgrade Warning

Support for Microsoft Internet Explorer  11 in 2023

As of Pyramid 2023, support for Microsoft Internet Explorer 11 is deprecated. Customers should use modern HTML5 browsers to consume Pyramid, including Chrome, Edge, Firefox, Opera, and Safari. 

Licensing Changes in 2023

Pyramid 2023 now has several new options that can be licensed separately. This includes:

• The Tabulate and Solve apps
• "Analyst" and "Basic" user types
• The "Named Embedding" option
• Multi-tenancy

Contact sales for details on these new options and capabilities.

Multi-tenancy Licensing Adjustment

• If you do not use multiple tenants, then you do not need to do anything. 

• If you use multiple tenants, request a new replacement license key that enables the capability in a Pyramid 2023 instance. Until you apply the new key to the upgraded 2023 instance, your existing multi-tenant structure will remain operational, but you cannot add new tenants or adjust tenant-level settings.
• There will be no additional charge for existing customers needing the new multi-tenancy license. 

You can download the LTP2 installer from the LTP resources directory here.

Please also consult the LTP2 mini guide, accessible in the same location, which has been updated to include a description of the new features added since the LTP1 release and how to install the new version.

If you encountered or reported issues in the LTP1 release, please retest with LTP2 to confirm the issues have been addressed and update your report ticket accordingly at https://betabugs.pyramidanalytics.com. Please also report to this site any additional errors or problems you may find.

The LTP2release will require a new Pyramid licence file which again can be downloaded from the resources directory. It is valid for 45 days from yesterday.

Regards,

Ian Macdonald

Team Lead – Product Management

Pyramid 2020.27 (Service Pack 7 for 2020.20) has been released. It includes a collection of fixes for bugs and issues and several new capabilities related to data sources.

Software

• The main installer files can be downloaded from the Customer Portal. 
• Docker containers have been upgraded for Kubernetes deployments.

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

Pyramid 2020.27 includes changes to existing capabilities. It builds on other changes made since the last major release (2020.20). Please consult the notes for all versions from 2020.20 onwards on this forum to understand the impact on your deployment.

As such, Pyramid recommends that the new release be tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

New features

Data Source Access

• SSO by User for Azure AD and Snowflake: When authenticating Pyramid users through Azure Active Directory, OAuth user credentials can now be passed automatically to SnowFlake, enabling Single Sign On.
• New OAuth options for database authentication: When connecting to OAuth-authorized data sources, a specific user's credentials can now be passed through to leverage the user security of the target data source. 
• Further control of Failed Schedule email distribution: An option to limit the distribution of emails generated by failed schedules. It can now be optionally turned off for all Admins. The owner of the Schedule will continue to be notified of failures.
• Additional Proxy2 account information: To provide for seamless connection across certain different data sources, an additional Proxy Name option has been provided so that two of these sources may be used in conjunction. This includes Snowflake, Microsoft SQLServer,  Microsoft SQLServer Analysis Services OLAP and Tabular, SAP HANA, and SAP BW. 
• User API update for Proxy2: Support to manage the new Proxy2 option when assigning users through the API.

Data Connectors

• New ClickHouse connector: A new connector for ClickHouse, an open-source column-oriented DBMS for online analytical processing. This connector supports both data ingestion and Direct Query. 
• Optimization of NVARCHAR indexes for MS SQLServer: Pyramid now matches the data type of text parameters passed to VARCHAR data fields in the database to leverage any in-place indexes.
• Parent-child cross query optimization: Query processing has been updated to isolate Parent-Child hierarchies from Measures where those Measures are unrelated to the Parent-Child dimension.
• New options for SSL encrypted connections: The connection options for a selection of data sources have been extended to include encryption settings. The data sources concerned are Exasol, Snowflake, Redshift, Google BigQuery, MS SQL Server, Oracle, and  PostgreSQL.

Visuals

• Added a new "Copy Value" option from the context menu of visuals in Discovery and Present, allowing the copying of grid row and column labels into the clipboard.

Items fixed

Model

• Fixed an issue where Work Week created by Time Intelligence showed an incorrect value
• Fixed an issue where changing the display name of a column in a model using the Data Catalog did not work
• Fixed an issue where a Non-admin Professional could not connect to SharePoint Lists
• Fixed a case sensitivity issue where a Permission Denied message appeared when trying to create a new database with a name that is the same as an existing DB name but with a different case capitalization
• Fixed an issue that was causing long processing time for the direct query to Oracle
• Fixed an issue where an Excel file that was added from a URL did not show any tables
• Fixed an issue where column headers didn't change the order in the preview after reordering columns
• Fixed an issue where DateFormat failed for an Oracle date value
• Fixed an issue where a user didn't have access to a SharePoint DB but was still able to view it as a Source
• Fixed an issue that was causing heuristics to disappear when the 'Auto Relationship' type was changed

Discover

    Queries

• Fixed an issue where Eliminations in BW did not work as expected
• Fixed an issue where a parameter in a SAP BW Query contained an incorrect operator type
• Fixed an issue where using a table that was created as a Custom Query on a Direct Query Oracle model fails in Discovery
• Fixed a scenario where a query ran automatically, although AutoRun was off
• Fixed a member security issue that caused a "There was an error running this query" error when running a report
• Several optimizations for query performance:
  • better handling of current member/previous member queries
  • smarter join construction
  • better handling of security filters

    Visuals

• Fixed an issue where a KPI appears as a red chip when an Enterprise Admin opens a report from the Private Content of a different user
• Fixed an issue where data labels were appearing incorrectly in a Column/Bar chart with negative values
• Fixed an issue where changing the Y-Axis Digit format in the Formatting Panel for a Stacked Chart did not work
• Fixed an issue where changing the Hex color of a row to a color that already exists changes the color to white
• Fixed an issue where Cube Actions did not appear in the Action menu of a Map chart
• Fixed an issue where selecting any of the measures on the stacked bar only selected the first bottom one
• Fixed an issue where a long URL in a grid increased the grid cell height
• Fixed an issue where a tooltip of a line chart incorrectly showed data of the first item on the X axis
• Fixed an issue where clicking on a specific value on the X axis did not highlight the relevant bar in a Bar Chart
• Fixed an issue where double-clicking to add any Action under the Jump action in the Action Panel caused an error
• Fixed an issue where changing the Color formatting of the first measure in a '100% stacked bar chart didn't work as expected
• Fixed an issue where long member names in Actions were truncated
• Fixed an issue where map data appeared in the wrong location when Windows Scale & Layout was set to 150%
• Removed the 10 billion value limitation for scale bounds in a chart

Present

• Fixed an issue where a dropdown in the "Define Model Parameter" window had blocked the search field when the screen resolution was set to 1280x720
• Fixed an incorrect tooltip that was appearing when hovering over the "Background color" button in a Publication
• Fixed an issue that was causing a browser crash while editing a dashboard
• Fixed an issue where maximizing a report that was opened from an Action caused the report slicers selections to revert to default
• Fixed an issue where using Analyze further from a Presentation URL, the report opened in the Dark Interface
• Fixed an issue where double-clicking a Jump to slide action caused interaction issues
• Fixed an issue where copying/pasting slicers between Presentations and deleting the source Presentation broke the slicer in the destination
• Fixed an issue where a named set disappeared from the "Jump to Tab" section in the Action panel
• Fixed an issue where a tooltip did not display in the correct position
• Fixed an issue where a Jump to Tab action to the Default tab had failed
• Fixed a cross-model mapping issue that was causing errors in a presentation
• Fixed an issue where items that were placed in the Content master page of a Present and were set to “bring to front”, covered the items placed in the slides when printing
• Fixed an issue where clicking an item on a chart didn't highlight the correct item in certain scenarios
• Fixed an issue where a Date Calendar slicer wasn't injected into a click Action, causing the target Date slicer to load endlessly 
• Fixed an issue where the Navigation Tabs lost their formatting after changing the font to bold
• Fixed an issue where a report that was opened by a Jump to Content Item action was filtered incorrectly
• Fixed an issue where a presentation that was opened directly into runtime failed to render an element when using a BW data source with predefined parameters
• Fixed an issue that was causing the cross-model mapping validation to fail, although the model mapping was correct and working

Publish/Subscriptions

• Fixed an issue where a subscription did not run for the first Monday of the first week of the month
• Fixed an issue where a scheduled publication output to PPT/PDF had the file name appearing on the top left corner of the output of every page
• Added the option to prevent failed schedule alerts to be sent out to all admins
• Fixed an issue where Advanced Settings was unavailable for existing schedules
• Fixed an issue where placeholders in publications were causing duplicate items to appear in the TOC
• Fixed an issue where placeholders did not appear correctly in the TOC
• Fixed an issue where text borders did not appear when exporting Publications to PowerPoint
• Fixed an issue where the 'Merge Common Cells' option didn't work for a Subscription that was created from the CMS

Formulate

• Fixed an issue where the NumberBillions, NumberMillions, and NumberThousands formats in a Formula were using a single quote instead of a double quote

Content Management

•  Fixed an issue where a Domain Admin was unable to access older versions of content in Versioning
• Fixed an issue where Maintain Folder Structure did not work as expected when importing a Discovery pie file which uses calculations in nested folders
• Fixed an issue that was causing users' folders in Team Member Content to be duplicated
• Fixed an issue where an interaction in a Present changed from Auto Destination to a parameter after copying a folder with the present from a Public folder to another tenant's public folder
• Fixed an issue where a user was unable to save content
• Fixed an issue where a Viewer user couldn't access a public folder via a direct link
• Fixed an issue where clicking on Propagate roles in a public folder had failed with an error "Request Error - Can't run select query…"
• Added an alert message for cases where a calculation in a folder could get duplicated on import when using the replace option

Printing/Export

• Fixed an issue where printing a Discovery to Excel failed with a '"String.isEmpty()" because "elementTitle" is null' error
• Fixed an issue where changing the range of a Range Slider in a Present and printing it printed the default range

Admin

• Removed the test user name, from the connection string configuration to SAP BW, for a clearer UI experience
• Fixed the Impersonate functionality
• Fixed an issue where Filter Table Name in Attribute Security didn't work after renaming the table in the Model
• Fixed an issue where after changing a username in AD and running  provisioning, the ad_account in Pyramid did not change
• Fixed an issue where a user that had a Profile that allows Model only got a blank screen after login
• Fixed an issue where existing snapshot entries in the Task Manager changed to a "Cancelled" status after disabling Image Snapshots
• Fixed an issue where email configuration had failed an IllegalBlockSizeException error
• Added a new editable Proxy Account field under Edit User
• Improved password security when using Custom Connectors
• Fixed an issue where a DB was not deleted after clicking the delete button
• Fixed an issue where Propagate Roles failed with a "databaseNode" is null error

API

• Fixed an issue where API2/dataSources/getAllConnectionStrings failed when there were more than 2100 models on the server
• Fixed an issue where /API2/access/getUser returned an incorrect last login time
• Fixed an issue where /API2/access/getUserLastLogin did not work
• Fixed An issue where /API2/query/getParameterElements returned an error
• Fixed an issue where /API2/content/findContentItem showed all folders that have the content instead of only the specified folder

Other

• Upgraded the Apache Common Text version to 1.10
• Fixed an issue where the Master Router could not find an Active RTE when RTE port got changed
• Fixed incorrect root_folder_type in the transactionView
• Fixed an issue where in a direct query from a SQL server source, Pyramid converted the varchar column type to nvarchar
• Fixed an incorrect syntax for NumberBillions, NumberMillions, and NumberThousands in the online help
• Fixed a German localization error for hierarchy level type
• Online help improvements

Software

• The main installer files can be downloaded from the Customer Portal. 
• Docker containers have been upgraded for Kubernetes deployments.

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

Pyramid 2020.26 includes changes to existing capabilities. It builds on other changes made since the last major release (2020.20). Please consult the notes for all versions from 2020.20 onwards on this forum to understand the impact on your deployment.

As such, Pyramid recommends that the new release be tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

Upgrades

• The processing of Active Directory User Group synchronization has been updated for improved performance. New settings to control this operation have been added to the admin console.
• The processing of metadata structures from SAP HANA data sources has been refactored for faster results on slow-performing HANA implementations.
• Improved status tracking for tasks in the admin console.
• New model-related APIs were added for managing model security and hierarchy overlays.
• A new accessibility guide was added to help, including a new version of the self-assessed "Accessibility Conformance Report" for 2022. 

Items fixed

Model

• Fixed an issue where using Auto Detect in an R node had failed
• Fixed an issue where a long text datatype from MySQL was converted to a string
• Fixed an issue where it was not possible to use an Excel file in an Azure Blob data source
• Fixed an issue where the timestamp in the model Progress tab did not match Local Server Time when using an Oracle repository
• Fixed an issue that caused some links to be removed from the data flow after replacing the source files
• Fixed an issue where Date/Time fields from SharePoint lists did not populate in the data model

Discover

• Queries

  • Fixed an issue where users could not use the Elimination Wizard to bring back a member that was eliminated by right-clicking it in the grid and selecting Member Selection > Eliminate
  • Fixed an issue where a report that was copied from Workgroup to Public failed to run after upgrading to 2020.25
  • Fixed an issue where calculated measures in SSAS were sorted incorrectly in a report
  • Fixed a blank screen issue after adding a second filter in the Filter Wizard
  • Fixed an issue where NA appeared in a grid when using +- in a Unary operator column
  • Fixed an issue where the unzip process of a SAP BW query did not complete
  • Fixed an issue where the "The following parameter has no input" message appeared when adding a parameter used in a cascade logic into a drop zone
  • Fixed an issue where a Parent Child Hierarchy was used in a SQL query, although it was not added to the report, and there was no measure

• Visuals

  • Fixed an issue where KPIs did not show the Target label when the Target label and Value label had the same value
  • Fixed an issue where clicking on a link icon in a Grid did not open the link in a specific scenario
  • Fixed an issue where a Query Error message appeared in a report when using a Parent-Child hierarchy that had a value that didn't appear in the Child column
  • Fixed an issue where clicking on the Components tab after opening a Discovery caused the report to crash when Auto Run was disabled
  • Fixed an issue where a wide grid did not have a horizontal scroll bar on Firefox

Present

• Fixed an issue where the Slicer text color was changed from white to grey after an upgrade
• Fixed an issue where it was not possible to use the interaction picker to see interactions of an image located under a dynamic element
• Fixed an issue where Highlight interaction did not work for discovers that have the same attribute as slicers
• Fixed an issue where a jump to slide action had failed with a "PQL Syntax error: no viable alternative at input" error
• Fixed an issue where a Dynamic Text in the content page of a Present caused an error message to appear in the Print & Export summary window, although the content printed correctly
• Fixed an issue where selecting Me and Descendants from the context menu of a multi-select tree filter resulted in an error on the screen, although the filter selection was applied
• Fixed an issue where an element failed to render in a Present that was opened from a URL
• Fixed an issue where if data interaction was enabled between two items, it was impossible to perform a reset
• Fixed an issue where a Present could not be opened after changing the data source to one with different member names and running Analyze Structure
• Fixed a Tree slicer issue that was causing slowness when opening a present and moving between slides
• Fixed an issue where a tree filter that was used in more than one slide didn't work as expected in other slides if the initial selection was set to "first member"
• Fixed unexpected filter behavior when selecting all items in a filter based on a BW source
• Fixed an issue where the Display option & Show Granularity settings in a Calendar filter did not save
• Fixed an issue where a Jump to Content Item action failed when jumping to a report with a parameter

Publish/Subscriptions

• Fixed an issue where Ignore Styling for a subscribed report did not work
• Fixed an issue where some data was missing and cut off from a Flow Visual Flat Grid that is using Wrap Text in a publication
• Fixed an issue where Show title and merge common cells did not work in subscriptions
• Fixed an issue where a publication output was filtered incorrectly after making a filter selection in a scheduled publication based on a Hebrew Tabular Model
• Fixed an issue where Hebrew characters in a title of a publication email appeared as question marks
• Fixed an issue where /n appeared in empty lines on the cover page of a publication that was printed to a PDF
• Fixed an issue where dynamic distribution via email with Hebrew member names had failed
• Fixed an issue where turning off Bulletin Board in a Schedule did not remove it from the Bulletin Board list

Formulate

• Fixed an issue where nested "If" statements returned inconsistent results
• Fixed an issue where AddDays() failed with a "Compilation of calculation failed" error

Content Management

• Fixed an issue where Caption and Format properties 'For Report' were not saved when importing to another environment or after upgrade in the same environment
• Fixed an issue where, when migrating a folder while "bring related content" is off, nested calculations from other folders and one-off calculations were not being exported
• Fixed an issue where the Recent items did not show all recent content items as expected
• Fixed an issue where Analyze Structure showed incorrect items in the Alternative list
• Fixed an issue where opening items in the bulletin board had failed with a "Can't run select query…" error when using an Oracle repository

Printing/Export

• Fixed an issue where a print to Excel failed in a report where the same measures appear in the Values and Color drop-zones
• Fixed an issue where a diced report that was printed from Embed was filtered incorrectly

Admin

• Fixed an issue where Impersonate was not functional after upgrading to 2020.25
• Fixed an issue where after a user was created for an OpenID-enabled environment, it was not possible to update its username
• Fixed an issue where checking the "Disable the Show Details action" checkbox for a model was not saved
• Fixed an issue where the Role search was case sensitive
• Fixed an issue where admins could not change the time interval of a user group cache schedule when provisioning was not set up
• Removed BW properties from the Level Overlay list in Model Settings
• Fixed an issue where the OLAP Language setting in User Defaults did not apply to new reports
• Fixed an issue where the Active Directory Group Caching task ran for too long without timing out
• Fixed an issue where a blank screen appeared on the Web Service page when using an Oracle DB
• Fixed an issue where a Domain Administrator could not enable disabled users
• Fixed an issue where the username column was Null in the Transaction Logs when exporting it to Excel

API

• Fixed an issue where adding member security to a model using Rest API caused the model security UI to crash
• Fixed an issue where /API2/access/getLicenseCount returned a response with a bad format
• Fixed an issue where an unclear error message appeared when running the Data Source Changer using the API, and the connection string did not exist
• Fixed an issue where /API2/dataSources/addHierarchySecurityToModel did not work as expected
• Fixed an issue where disabling users with /api2/access/toggleEnableUser did not release the license seat

Mobile

• Issues with iOS16 for the iPhone have been addressed. A new version of the iPhone mobile app will be available for download from the app store.

Other

• Fixed an issue that was causing the Runtime service to not process queries following a service restart
• Fixed a Custom Workflow issue where the onSave event was not trigged when clicking on Apply
• Fixed an issue where after a new installation, registering a new user failed on the New Trial page
• Fixed an issue where users got an error message after logging in if the license was expired
• Made some online help improvements
• Fixed an issue that was causing the iOS app to crash when connecting

Software

• The main installer files can be downloaded from the Customer Portal. 
• Docker containers have been upgraded for Kubernetes deployments.

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

Pyramid 2020.25 includes changes to existing capabilities. It builds on other changes made since the last major release (2020.20). Please consult the notes for all versions from 2020.20 onwards on this forum to understand the impact on your deployment.

As such, Pyramid recommends that the new release be tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

New features

• Support for Linux Distributions: As of this version, Ubuntu 18 and 20, Debian 11, Centos 7, Red Hat 7 and 8, Oracle 7 and Amazon 2 are the supported Linux Distros for running Pyramid. Ubuntu 16, Debian 8 and Debian 9 are no longer supported. (Centos 8 itself is also now deprecated).
• Oracle NetSuite connector: A new connector to Oracle NetSuite has been added. This supports both the extraction of data from NetSuite for further processing in Model Data Flows and also Direct Query of NetSuite data.
• Auto add/remove columns in Model: During a reprocessing job, Models can now synchronize with underlying data tables by automatically adding or removing columns from model tables. As underlying metadata changes, this permits the synchronization of the model to the source database. Options for which tables to synchronize and how to aggregate new measures are also provided. 
• Show Details:  A new option has been added in the Administration Console to enable or disable the "Show Details" capability for Microsoft SQL Server Analysis Services OLAP and Tabular  cubes and models.
• MS SSAS Tabular - Support for Attribute (Column) Security: The latest release of SQL Server Analysis Services Tabular engine can now support Attribute (Column) Security by user on its Semantic Models. Pyramid now allows admins to reflect this security in the models presented to users using an optional switch in the Administration Console.
• Certification Tracker: User certifications from the Learning Hub LMS system (for those customers with an LMS subscription) are now shown in the application:
  • A new column in the User management section in the Administration console displays the number and level of Learning Hub certificates that each user has earned.
  • The User's certification will show up in the personal details panel.
• Separate Subscribe and Print option in run time settings: The Subscribe option can now be independently set in Run Time Settings for Discover and Present.
• Kubernetes Configurator: A new, upgraded approach to creating more scalable Kubernetes-based Pyramid clusters has been deployed through the "Kubernetes Configurator" tool. 
• Saved Slicer Selections for Present Subscriptions: It is now possible to select and save slicer selections when creating a subscription to Present storyboards.

Items fixed

Model

• Fixed a column sizing issue in Model, which was causing long member names to be cut off in the report
• Fixed an issue where a Model file with a direct query had the table selection changed to All after import
• Blocked the options to allow multiple relationships between 2 tables in the modeling stage
• Fixed an issue where a Model based on Pyramid Content failed after an upgrade from 2020.18

Discover

• Queries

  • Fixed an issue where a measure formatting change in Discovery was not saved
  • Fixed an issue where using Set Element Order on aggregated formulations had failed
  • Fixed an issue where Actions failed to include context when the source report contains a Date Part
  • Fixed an issue where a grid showed no values when using an aggregate with "currentmember"
  • Fixed an issue where a report with a custom order and a null element had failed to open
  • Fixed an issue where using 'Set Element Order' on a measure in a BW report caused a blank screen
  • Fixed an issue where a report that is based on a tabular model with Row-level security had failed to open
  • Removed the option to create Context Calculations in Analyze Further
  • Fixed an issue where Pyramid was running unnecessary order queries in reports based on Azure Tabular
  • Fixed an issue where using a complicated search term in Member Search resulted in a blank screen
  • Fixed an issue where the benchmark popup in discovery did not work for non-admin users
  • Fixed an issue where after saving a format string to a measure, it was not applied to a duplicate of the report created after the format change
  • Fixed an issue where an empty grid with totals on and a cumulative measure failed with a "A general error occurred" message
  • Fixed an issue where the minus sign did not appear in Grand Totals
  • Fixed an issue where adding a List to a multi-select slicer and selecting all members
  • Blocked the option to select 'Show Details' on Totals
  • Fixed an issue where creating a measure from the context menu when the search elements were opened caused Pyramid to hang
  • Fixed an issue where 'Show Details' did not filter the details based on the report filter selection
  • Fixed an issue where Eliminations was removing too many cells
  • Fixed an issue where 'Show Details' failed when using multiple selections in a slicer
  • Fixed a connection pool issue with Redshift, which was causing queries to timeout
  • Fixed an issue where an All member label appeared as Null in a grid based on BW
  • Fixed an issue where Rolling Average showed the correct average only for the first member in rows

• Visuals

  • Fixed an issue where a Stacked Area chart showed White areas when there was no value
  • Fixed an issue where the tooltip didn't always show when hovering a line chart with a range slide
  • Fixed an issue where small values did not appear in a Waterfall chart
  • Fixed an issue where the Y-axis indicators could not be removed
  • Fixed an issue where the column grand total header was cut off
  • Improved readability of gauge labels
  • Fixed an issue where Sunburst Chart Eliminated members that could not be shown in the visual
  • Fixed an issue where a Filter dropdown was opened upwards and got cut off

Present

• Fixed an issue where clicking a legend item in a line chart did not highlight the relevant item
• Fixed an issue where an interaction changed to Parameter Interaction after a Deep Paste of a Presentation
• Fixed an issue where a presentation failed to open with Cannot invoke \"java.lang.Integer.intValue()\" because \"index\" is null
• Fixed an issue where Analyze Further did not work after making deselection in a filter
• Fixed an issue where a Present with model mapping was not filtered correctly when slicer selection was set to All with deselections
• Fixed an issue where Analyze Further on a Present with model mapping opened the report with red chips
• Fixed an issue where running a presentation with a direct link had failed with "Something went wrong" on a Tablet
• Fixed an issue where a disabled filter did not get re-disabled after clicking on Reset in case the user made a selection without first enabling it
• Fixed an issue where "Remember user's last selection" in a filter did not work as expected in a Present that was opened using a direct link
• Fixed an issue where a filter that was disabled by default reverted back to being disabled after selecting All
• Fixed an issue where a deleted slide appeared in a Present as a blank slide
• Fixed an issue where Jump to URL did not inject the filter selections when the filter initial selection was set to 'Last member'
• Fixed an issue where a filter caption in a report that was opened by a 'Jump to Content' action was not translated as expected
• Fixed an issue where an element was not injected into an existing filter
• Fixed an issue where cascading filters in a Present did not work as expected
• Improved slicer performance
• Fixed an issue where Conditional Formatting appeared incorrectly in a Present that contained multiple reports with an identical CM
• Fixed an issue where a Present slicer caption was changed from white to grey after upgrading from 2020.18

Publish/Subscriptions

• Fixed an issue where subscribing to a Present from runtime used the default filter sections
• Fixed an issue where a chart in a scheduled publication displayed different colors from the original discovery
• Fixed an issue that was causing duplicate subscriptions to be created
• Fixed an issue where editing a Schedule that had an End Date showed the default Value and not the configured End Date

Formulate

• Fixed an issue where the UserPrincipleName() function returned the Proxy account on SAML authentication

Illustrate

• Fixed an issue where some settings were not saved in an Illustration that was made sharable

Content Management

• Fixed an issue where the Data Source Changer showed the Technical Name of the model in the From dropdown for SAP BW
• Fixed an issue where a change in the Format String of a measure was not carried over if the report was copied

Printing/Export

• Fixed an issue where a Dynamic Text appeared unformatted in a PDF print
• Fixed an issue where lines were cut off in a grid that was printed to PDF with Scale to Fit
• Fixed an issue where Publications and Presentation were printed with page numbers in the excel sheet names

Admin

• Fixed an issue where after changing the name of a model in the Source Manager, Discovery will still show with the previous name
• Fixed an issue where renaming a model to an already existing name failed with a general error
• Fixed an issue where SharePoint data source connections failed with "PyramidException: Failed the authentication process to the user account."
• Fixed an issue where the Filter Task Description in the Task Manager did not work as expected
• Fixed an issue where it was not possible to set an initial user password after changing from DB to SAML authentication
• Fixed an issue where the System Logs export had failed
• Added the option to automatically cleanup ETL progress from repository/general/temp
• Removed some privileges from Domain Admins for improved security
• Fixed an issue where the User search did not search in the Last Name field
• Fixed an issue where the Summaries Panel took a long time to load in multi-server environments with a large number of servers
• Fixed an issue where the 'Stop All' Button on the Task manager menu canceled the subscriptions instead of stopping them
• Fixed an issue where a hierarchy that was marked in the model as "security" did not show up in the PQL editor under member security
• Fixed an issue where sorting the Database list in the Data Source Manager by "Created On" did not work

Security

• Fixed an issue where impersonating a user when using DB auth had failed with a 500 server error
• Fixed an issue where logging into Pyramid using SAML had failed when coming from myapplications.microsoft.com

API

• Fixed an issue where API2/access/updateUserOpenId failed to create an enterprise admin user
• Fixed an issue where API2/content/addTag allowed to create the same tag multiple times
• Fixed an issue where API2/content/getAllTags returns only the tag ID but should have also shown the tag name
• Fixed an issue where API2/access/getAllProfilesByTenantId brings back all profiles from ALL tenants returned profiles from all tenants
• Fixed an issue that was causing an 'api.models.request.RequestShellOrigin.ordinal()' error to appear multiple times in the system logs

Other

• Fixed memory leaks that were causing a browser crash in certain scenarios
• Fixed an issue where tooltips did not appear in the Function ribbon for a Viewer user in Analyze Further
• Fixed an issue where Pulse did not reconnect after Pyramid went down and required a manual restart
• Made some online help improvements
• Improved error message for when a satellite fails to start
• Fixed an issue that was causing a "Snapshot Isolation" error to appear in the System Logs
• Fixed an issue where inline tutorials failed when changing speed and quality
• Fixed an issue where NodeJS couldn't install Pyramid embed package for Angular on NPM 8
• Improved System Alerts sensitivity

Software

• The main installer files can be downloaded from the Customer Portal. 
• Docker containers have been upgraded for Kubernetes deployments.

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

Pyramid 2020.24 includes changes to existing capabilities. It builds on other changes made since the last major release (2020.20). Please consult the notes for all versions from 2020.20 onwards on this forum to understand the impact on your deployment.

As such, Pyramid recommends that the new release be tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

Adjustments

Data Connectors

As of 2020.24, five data connectors have been removed from the standard installation for various reasons (licensing/paywall). Customers who already use these connectors (or plan to use them) need to download them and add them as custom connectors. (Pyramid's connector marketplace offers quick access to the downloads). 

Details for this simple process can be found in the online help and additional information in this blog.

The affected connectors are:

• Apache Drill
• Apache Hive
• MongoDb BI 
• Netezza
• Neo4J BI 

Request Failovers

As of this version, customers will have the option to choose how the request failovers will be handled by the router service. This includes the option to block failover handling, full redirect, or selective redirects.  

Details for this can be found in the online help. 

Fixes / Changes

Model

• Fixed an issue where using an Existing ML Model in a data flow had failed
• Fixed an issue where a schedule failed with an "ETL Process throws an error - Can't run insert query UPDATE content_tbl_database set process_date" error
• Fixed an issue where a Parent-Child hierarchy did not work for an Oracle direct query

Discover

• Queries:
  • Added optimization to avoid order queries on custom dimension names in SSAS
  • Fixed an issue where the Sub Query mode setting under User Defaults > OLAP was applied to SQL based reports as well
  • Fixed an issue where a Query Error appeared after setting the Execution Mode to Optimized or Optimized Compressed in a BW report
  • Fixed an issue where a report did not use the selected Totals Function when its initial run
  • Fixed an issue where Include Context in an Action did not work when a Date Calendar filter was used in the source report
  • Fixed an issue where a filter with an empty value did not work as expected
  • Fixed an issue where Dynamic Caption did not show the expected caption after refreshing the data or re-running the query
  • Fixed an issue where a Tree filter had failed when searching for a comma
  • Fixed an issue where a tree filter search kept loading and did not return results
  • Fixed an issue where a report failed if a column was used in the grid both as a distinct-count measure and a regular attribute
  • Fixed an issue where a tabular model failed to open with a "The resultset of a query to external data source has exceeded the maximum allowed size…" error
  • Fixed an issue related to filtering a report that contains small decimal values
  • Optimized the Business Logic button (Fx button) load time
• Visuals:
  • Fixed an issue where a Forecast line was not dotted
  • Fixed an issue where the X-axis was removed from a trellised chart
  • Fixed an issue where the Format option was missing from the Y-axis in the Formatting Panel for a Scatter Chart
  • Fixed an issue where the values of the Size legend were cut off
  • Fixed an issue where clicking the Undo button caused a blank screen in a specific scenario
  • Fixed an issue where the grid disappeared when after changing a discovery from a "Matrix Grid" to Raw Results
  • Fixed an issue where the Row Area Size in the Formatting Panel did not work as expected
  • Fixed an issue where Grid hierarchical data member did not display from the 7th level and up, if the rows background color was removed
  • Fixed an issue where clicking on Undo after changing colors in conditional formatting had failed with a "Cannot read properties of null (reading 'memberMap')" error

Present

• Fixed an issue where the wrong context menu appeared when right-clicking a visual
• Fixed an issue where a visual change in a report was not reflected in a Present that was using this report
• Fixed an issue where highlight interaction stopped working after clicking the reset button in a slide with disabled slicers
• Fixed an issue where the Action Panel did not show the Slicer items when configuring an action from Calendar or Tree slicer into a Mini Tab
• Fixed an issue where cube last processed in present showed UTC time and not the local time
• Fixed an issue where Advanced Actions in Mini Tabs got overwritten when using multiple Mini Tabs
• Fixed an issue where undoing a change required multiple clicks on the Undo button in a specific scenario
• Fixed an issue where data labels disappeared after changing visual and clicking on Undo

Publish/Subscriptions

• Fixed an issue where non-admin users did not have the ability to distribute publications/alerts/subscriptions via email
• Fixed a tooltip localization issue in the Interaction Manger
• Fixed an issue where a scheduled publication ran on the wrong day in a specific scenario
• Fixed an issue where a page in a publication could not be deleted

Formulate

• Fixed an issue where a formulation based on dimension property in BW returned an incorrect result
• Fixed an issue where using Custom Validation and a regular expression as Input Validation did not save
• Fixed an issue where formatting a value as hh:mm:ss did not work as expected

• Fixed an issue where NonEmpty in list returned all the members and not only members with data when the model is using a full join

Illustrate

• Fixed an issue where Dynamic Text was picking up the wrong field

• Fixed an issue where changing the font type and color in the Tooltip Designer caused a blank screen

Content Management

• Fixed an issue where content description did not appear after adding it and then re-opening the Description window
• Fixed an issue where a Present failed to open with a 'duplicate key' error after migrate/import using Overwrite
• Fixed an issue where Propagate on a folder that has no Roles did not work as expected
• Fixed an issue where incorrect roles were added to content in a specific scenario
• Fixed an issue where migrating/importing content with Replace Files did not work for a Present that was located in its own folder
• Fixed an issue where migrating/importing content with Replace Files did not work for a Present that was located in its own folder
• Fixed an issue where Team member Content for administrators was not visible when Pyramid had only the one Default tenant configured
• Fixed an issue where Analyze Structure fails for a report with a measure-parameter that is set to default By Selection
• A message will appear when attempting to import content from a newer version to an older version indicating that it is unsupported
• Fixed an issue where some content that was exported did not appear in the import

Printing/Export

• Fixed an issue where printing a large report to Excel had failed
• Fixed an issue where a one-off Dynamic text did not appear in a Publication print
• Fixed an issue where printing failed with a "Can't export empty excel sheet" error
• Fixed an issue where printing a present with Sections only printed the default section
• Fixed an issue where a page number could not be printed in a Discovery when printing to PowerPoint

Admin

• Fixed an issue where the Geospatial test only checked for connectivity and not for the existence of the DB
• Fixed an issue where it was not possible to turn off multi-pass auth for Tabular/OLAP data sources
• Fixed an issue where an AD user could not be added to Pyramid in a specific scenario
• Fixed an issue where snapshots caused an error to appear in the logs when 'Use NetBIOS account names' was enabled
• Fixed an issue where a non-admin user received a permission denied error when executing a model
• Fixed an issue where LDAP users that had quotation marks in their names caused user groups sync to fail
• Fixed an issue where some transaction records were missing from the Transaction Logs
• Fixed an issue where a Provisioning job ran more than once causing user duplication
• In Query Limits, added the Enable Retries option to enable/disable Export, Print, and Publication retries after a timeout
• improved the AD group user sync process to Pyramid roles. If there is a "bad" user in the AD group, it will be skipped and logged and the rest of the users will then be synced
• Added new options under 'Services' > 'General Settings' for a better control on how the runtime engine behaves
• Improved group sync mechanism

Other

• Fixed an issue where Embed did not work on older versions of Angular 9
• Fixed an issue switching between tabs when using Tabs Navigation in an embedded Present
• Improved German localization
• Fixed an issue where the Linux installer failed with a "No such file or directory" error
• Fixed an issue that was causing a "Can't find default localization key" error in the logs
• Added missing data source drivers to the Kubernetes installation
• Fixe an upgrade issue where an error message appeared after a successful upgrade
• Made several content corrections in the online help
• Fixed an issue where the 'updateUserSaml\DB\OpenID' didn't have the profiled parameter
• Fixed an issue where 'API2/access/createUsersOpenId' had failed
• Fixed an issue where 'API/authenticateUserEmbedOPENID' expected the values of the map to be in an array and failed when sending a string
• For SAP BW, added ability via the database to control the number of concurrent "conversations" allowed by Jco as per https://launchpad.support.sap.com/?sap-support-headless=true#/notes/0002601423

Software

• The main installer files can be downloaded from the Customer Portal. 
• Docker containers have been upgraded for Kubernetes deployments.

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

Pyramid 2020.23 includes changes to existing capabilities. It also involves an upgrade in DotNet (for Windows hosted machines).

Pyramid recommends that the new release be tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

Features

Click here to read a fuller description for some of the new features.

• New Semi-Additive Measures: First Child and Last Child in Model (beta) – First child and last child aggregations have been added to the semantic modeling Measure Type options.

• Support for SAP BW Double Structures in BEx Queries (beta) – Supports the derivation of measures from the key figure and characteristic structure combination defined in SAP BW Bex Queries.
• New Ribbon Tooltips – Tooltips are available for all ribbon buttons with links to advanced help where applicable.
• Model / Alert task cleaner – The task cleaner cleans model and data alert logs for a specified period of time.
• New Page Size default – Default page sizes can be set per tenant for publications.
• New Mobile Info button – Clicking on the info button displays content information for mobile users
• Chart Gallery – Provides predefined chart styles for cartesian charts
• New Workday schedule option (beta) – Allows reports to be scheduled according to the workdays of a month
• New switch in Profiles to enable or disable Auto-Discover
• New REST APIs for authentication and updating data model flows

Fixes / Changes

Model

• Fixed an issue where checkboxes were greyed out when setting security in an in-memory model definition
• Fixed an issue where a domain admin with a hidden role from a non-default tenant was unable to create an IMDB database
• Fixed an issue where creating a model with a Hebrew Model Name had failed
• Fixed an issue where a RedShift data source returned a maximum of 10,000 rows
• Fixed an issue where the DateTime type did not pass through the Unpivot component
• Fixed an issue where using a data source connected to Pulse in a dataflow had failed
• Fixed an issue where refreshing columns in a dataflow had failed
• Fixed an issue where a Permission Denied error appears when processing a model
• Fixed an issue where adding additional tables to an existing SQL script resulted in unexpected behavior
• Fixed an issue where adding a table in Oracle Direct Query did not show varchar(3200) columns
• A clearer message will appear when trying to run a schedule after less than the minimum of 2 minutes from the previous execution
• Fixed an issue where emails were not sent when using a Variable and a dynamic email list

Discover

• Fixed an issue where copy Content using 'Copy Raw Data' was throwing an error
• Fixed an issue where map tooltips did not work as expected on small screens
• Fixed an issue where changing a profile to manual query execution caused the Discover Tutorial to fail
• Fixed a blank screen issue when running a URL action from a report containing a Date filter and based on an Oracle DB
• Fixed an issue where Copy Raw Data had failed for big report
• Fixed an issue where after changing a model name, the old model name still showed in the report metadata
• Fixed an issue where an error pop up in a report due to a dynamic caption issue
• Fixed an issue where changing a report title did not work if the new title had a quotation mark
• Fixed an issue where a Tree filter failed on a report converted from BI Office
• Fixed an issue where adding a List to filters caused the report to show 'Not Enough Information'
• Fixed an issue where setting a Format String that is configured to show a negative percentage in brackets did not work as expected
• Fixed an issue where the Custom Order on a hierarchy is removed after one of the items is expanded
• Fixed an issue where the List Builder did not find items beyond the number of items configured in the 'Elements Tree Size Limit' setting
• Fixed an issue where Copy Raw Data did not copy the correct formats when Model Formats was enabled
• Fixed a cascading slicers issue where if All was selected and then some items were deselected, the query was not filtered correctly
• Fixed an issue where the Forecast button did not work if a forecast was created before and then deleted
• Fixed an issue where a user was able to rename a measure although he did not have the permission to do so
• Fixed an issue where an expanded parent-child hierarchy in a grid could not be collapsed
• Fixed an issue opening a report that was using Model Formats and non-aggregate totals
• Fixed an issue where Copy Raw Data did when there was no value to data point in a specific usage
   
• Queries:
  • Fixed an issue where Smart Discovery had failed with a "The model couldn't find item…" error
  • Fixed an issue with cumulative totals where if there was a cell with no value, it was blank where it should have shown the previous value
  • Fixed an issue where a Filter failed in an Exasol report
  • Optimized the way Pyramid filters by statistical markers
• Visuals:
  • Fixed an issue when a report with a map chart was imported, initially, in the Legend area, it had 3 bands and after the import showed only 2 bands
  • Fixed an issue with map charts where the 'Topology' map wasn't visible when 'Shapes' was selected
  • Fixed an issue where the Y-Axis Line could only be set as a full number
  • Fixed an issue where a dot appeared as the thousands separator in the first Y-axis label instead of a comma
  • Fixed an issue where Bar Chart X-Axis labels were not centered
  • Fixed an issue where the X-Axis label Direction setting did not work
  • Fixed an issue where the Scale Bounds setting was not available for the X-Axis in Scatter Charts
  • Fixed an issue where a KPI status indicator did not work after reopening the report

Present

• Fixed an issue where interactions from cascading slicers were throwing an error
• Error when subscribing from present
• Fixed an issue where a grey space appeared after changing fonts of a Dynamic Text
• Fixed an issue where a 'Jump To Content Item' action did not work when a member had a square bracket in its name
• Fixed an issue where parameters interaction dialog was missing
• Fixed a blank screen issue occurring when content was using a default theme different than the main tenant's default theme
• Fixed an issue where an error message appeared after selecting Analyze Further
• Fixed an issue where opening a presentation failed with an undefined error
• Fixed an issue where disabling a filter that has All selected had failed
• Fixed an issue where a filter Disable button appears when hovering over the filter while the filter title is hidden
• Fixed an issue where creating an Advanced Slicer had failed after making free selections and a level selection
• Fixed an issue where Dynamic Text and Asset usages were not cleared after the items were removed from the Present
• Fixed an issue where a background color configured under Slicer Styles in 2020.18 was missing from 2020.22
• Fixed an issue where the URL created by a filter interacting into a Web Asset wasn't encoded in the first load
• Fixed an issue where Jump To Content Item created an incorrect URL
• Removed the slide name from Tiled Presentations
• Fixed an issue where a filter failed with an Enumeration Error after Analyze Further
• Fixed an issue where #ModelProcessedDate did not update
• Fixed an issue where red invalid chips appeared as valid after clicking Undo
• Fixed an issue where Dynamic Captions of Formulations have failed
• Fixed an issue where a Present that is using reports with SAP parameters have failed to open
• Fixed an issue where a parameter was not injected into a discovery report after using 'Analyze Further'
• Fixed an issue where an Action to item over BW did not work
• Fixed an issue where a change made in an unlinked content was not reflected in the Preset
• Fixed an issue where the initial value of a slicer was not injected through URL parameters if "Remember User last selection" was enabled
• Fixed an issue where a filter based on a set had failed due to interaction issues with another filter
• Users can no longer rename formulations in Analyze Further

Publish/Subscriptions

• Fixed an issue where subscribing to a present was throwing an error
• Fixed an issue where filters in a Presentation did not apply when printing via a subscription
• Fixed an issue where schedule execution times were missing from the Job Execution list
• Fixed an issue where a Flow Visual was printed in an incorrect order
• Fixed an issue where the Triggered Launch functionality was missing from older schedules
• Fixed an issue where some dynamic text components that are based on the same query failed to print

Formulate

• Fixed an issue where Enterprise Admins could not edit formulations that were copied/imported between different tenants
• Fixed an issue where using "//" to comment out text in a script caused the script to fail
• Fixed an issue where the context menu did not appear when right-clicking an existing formulation in the Formulate app
• Fixed an issue where a gauge secondary label showed the formulation name as well
• Fixed an issue where it was possible to create two calculations with the same name by renaming an existing calculation
• Fixed an aggregation issue related to using NextMember

Illustrate 

• Fixed an issue where an error message appeared after dropping an image on the canvas

Content Management

• Fixed an issue where a Black screen was thrown after performing 'Save As' on content converted from BI Office
• Fixed an issue where Analyze Structure detected a broken measure but did not show the measure name
• Content descriptions now limited to 4000 characters

Printing/Export

• Fixed an issue where exporting a presentation containing various themes, produced inconsistent color results
• Fixed an issue where printing a publication that has BW content with parameters had failed
• Fixed a text overlap issue in a Present that was printed to PowerPoint and Word
• Fixed an issue where Selected Slides did not print correctly in a Presentation
• Fixed an issue where a report with a parameter failed to export to Excel
• Fixed an issue where a Present printed to a PDF was filtered differently than how the Present was filtered
• Fixed an issue where printing to Excel failed with a "Can't export empty excel file" error

Admin

• Fixed an issue with exporting Audit Logs
• Fixed an issue where DB user licenses were not released after switching from DB to SAML authentication
• Fixed an issue when the app was using DB users and users were imported from a CSV file, the impersonate user profile disappeared
• Fixed an issue where exporting the System Logs failed with an IndexOutOfBounds exception
• Fixed an issue where Custom Maps did not show in the admin when using the Spanish UI language
• Fixed an issue where a domain user could not change a user's license between Pro and Viewer
• Fixed an issue where a role added to an admin did not appear in the Assigned Roles list
• Fixed an issue where a custom font did not work for non-admin users, when not secured by tenant
• Changed diagnostic router, agent Communication to true
• Fixed an issue where provisioning was adding duplicate users
• Fixed an issue where trying to add user email to a conversation (in German) wasn’t working

Security

• Fixed an issue in the Proxy Account field when using a DB authentication
• Fixed an issue where Impersonate User was sometimes failing
• Fixed Password Complexity checks
• Made security improvements to embedded error messages
• Upgraded various libraries with vulnerabilities

API

• Fixed an issue where Duplicate users were added when importing users via the API with a different user name, but with the same SID
• Fixed an issue in the 'findContentItem' API, bringing back empty results when the 'searchMatchType' was set to 'equals'
• Fixed an issue in the 'dataSources/importModel' API, showing success but not creating the model and throwing an exception in the logs
• Fixed an issue where 'updateTargetNodeConnection' API failed when the DB didn't exist

Application / Miscellaneous

• Fixed an issue with Pyramid redirect URL, for login and log out pages
• Fixed an issue in an embedded grid, were using a global line-height style broke the grid headers alignment
• Fixed an issue where upgrade scripts failed due to a report description field being longer than 4000
• The Chromium cache folder is now emptied after a Task Engine restart

Documentation

• Upgrades to help with improved integration with the application. Includes a few new how-to videos as well.
• Fixed an issue where Tutorials have failed when using non-default workspace layout

Log4J Mitigation

Version 2020.22 includes upgrades to the Log4J library (2.17.0) and fixes for affected JDBC drivers from other vendors. For more information and details on the mitigation, please click here. The blog also includes guidance for mitigating the problem in earlier versions of Pyramid. 

Software

• The main installer files can be downloaded from the Customer Portal. 
• Docker containers have been upgraded for Kubernetes deployments.

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

Pyramid 2020.22 includes changes to existing capabilities.

Pyramid recommends that the new release be tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

Fixes / Changes

Discover

• Fixed an issue where Conditional Formatting failed in case a formulation that included a parameter was used as a band limit
• Fixed an issue where after changing the Dimensions Tree Mode to Optimized, the properties disappeared
• Fixed an issue where the context menu was missing from Text Gauges
• Fixed an issue where Conditional Formatting with Fixed Banding changed values after saving
• Fixed an issue where Y-axis labels got cut off
• Fixed an issue where using Member Search to select a member on a hierarchy has added the hierarchy as a Tree filter
• Fixed an issue where using an asterisk in the Elements Search field did not work as expected
• Fixed an issue where a report was showing incorrect values when Sub Query was enabled and a filter had a non-aggregatable hierarchy with multiple selections
• Fixed an issue where it was not possible to add an item to the Columns drop zone of a Raw grid report that was opened from Analyze Further

Present

• Fixed an issue where changing the Text Color from the ribbon did not affect the slicer
• Fixed an issue where making a filter selection in Analyze Further failed with a Query Error
• Fixed an issue where it was not possible to enable 'Hide Empty hierarchy Members' in a filter

Publish/Subscriptions

• Fixed an issue where it was not possible to subscribe to a Presentation if it had a multi-select filter with All set as default
• Fixed an issue where a publication schedule failed if a slicer has an empty first value
• Fixed an issue where after replacing a publication using Import and Replace All, the schedule seemed inactive but still ran
• Fixed an issue where some subscription schedules had changed to run daily

Formulate

• Fixed an issue where using a PQL set function on a custom list returned an error
• Fixed an issue where an endless spinner appeared when trying to create a parameter

Admin

• Fixed an issue where changing the Inherent Roles on Copy/Paste setting in User Defaults fails with a Save error
• Fixed an issue where after filtering the Task Manager list by Last 1 Day, the Start Date and End Date show Invalid Date
• Fixed an issue where the Apply button was greyed out after enabling the 'Use NetBIOS account names for MS OLAP (Domain \ Username)' setting
• Fixed an issue where it wasn't possible to switch licenses for users if their phone number had a space in it

APIs

• Fixed an issue where "/API2/dataSources/updateTargetNodeConnection" returned "400 BAD request"
• Fixed an issue where "/API2/access/getAllNonPrivateRolesByTenant" wasn't returning results

Installer

• Fixed an issue where the installer failed when the DB password had a '?' sign

Mobile

• Fixed an issue where it was not possible to change filters in a discovery when using the iPhone app

Other

• Upgraded Log4j to v2.17 and made other security improvements
• New help videos and Online Help improvements
• Fixed an issue where the GC was not running on Linux

Software

• The main installer files can be downloaded from the Customer Portal. 
• Docker containers have been upgraded for Kubernetes deployments.

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

Pyramid 2020.21 includes changes to existing capabilities.

Pyramid recommends that the new release be tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

Features

• New member level security support for securing Parent-child hierarchy elements
• New (beta) option to use the default value of parameters in SAP BW and HANA data sources for publications
• Minor improvements to the Custom Workflow APIs
• New support for the Calendar Slice interface on mobile devices
• New "Circles" KPI and gauge style
• Improvements to the right-click "List" menus in Discover

Fixes / Changes

Discover

• Fixed an issue where the Information icon did not work after adding a quick filter
• Fixed an issue where the Indicator in a grid was cut off when the cell data was aligned to the middle or to the right
• Fixed an issue where changing the Label Format of measures was not applied unless the Format String was changed as well
• Fixed an issue where BW default parameters did not update correctly
• Fixed an issue where changing a filter from a Multi-Select Dropdown to a Multi-Select Tree changed the Initial Selection back to the default setting
• Increased the Row Area Fixed Size maximum setting from 500px to 1000px
• Fixed an issue where the chart padding changed after upgrading to 2020.20
• Fixed an issue where Font type and size selections were missing from a report after upgrading to 2020.20
• Fixed an issue where indicators showed incorrect arrow direction and colors after upgrading to 2020.20
• Fixed an issue where a SQL query was not canceled when closing the browser
• Fixed an issue where a Formulation in a measure list that was used as a Filter caused the filter to not load
• Fixed an issue where the same measure appeared twice in a tooltip when using an Area Chart
• Fixed an issue where incorrect colors appeared in a chart with a parameter on the Color dropzone
• Fixed an issue where measures are missing from the Formatting panel when editing Shapes
• Fixed an issue where Scope Isolation appeared in the query although it was disabled

Present

• Fixed an issue where a Panel title was cut off and did not use all available space when the buttons were hidden
• Added a tooltip to the Map Hierarchies dropdown in the Model Mapping panel
• Fixed an issue where the saved slicer selection overrode the selected slicer value when moving between slides
• Fixed an issue where a report with custom measure names in either a Present or a Publication showed the original measure names when running the Present or printing the Publication
• Fixed an issue where after adding two grids with different border widths to a Present/Publication, the border width style of the second grid overrode the first grid's border width style
• Fixed an issue where a Global Parameter could not be used to control Mini Tabs
• Fixed an issue where the Fill color of a Matrix Table ignored transparency
• Improved error message when Explain is unable to return any data
• Fixed an issue where Discovery reports did not populate consistently in Presentations
• Fixed an issue where clicking on a slide tab restored the slide components to their default values
• Fixed an issue where clicking a component using the Interaction Picker showed more interactions than expected

Publish/Subscriptions

• Fixed an issue where printing content resulted in duplicated files in both the main Pyramid folder and the general folder on the server

Formulate

• Fixed an issue where a formulation with a .lag() produced an error
• Fixed an issue where it wasn't possible to access the Functional Selections of formulate items when using a List View

Illustrate

• Fixed an issue where it was not possible to format a Dynamic Text as Bold
• Fixed incorrect text alignment in a text box when both Hebrew and English are used in the same sentence

Content Management

• Fixed an issue where a report that was opened in Maintenance Mode could not be saved
• Fixed an issue where importing a report with one-offs using Replace broke the original report
• Fixed an issue where a report failed to open with a "The following parameter has no input" error
• Fixed an issue where after trying to delete a folder with a report that is being used in a present, the folder will be deleted even if the user canceled the Delete Contentions on Shared Items panel

Printing/Export

• Added support for Custom Data when printing from embedded content
• Fixed several issues where printing to Excel had failed
• Fixed an issue where printing a grid with nothing in the Columns dropzone had failed
• Fixed an issue where printing a grid with only measures had failed
• Fixed an issue where the columns in a Raw Data Grid that was exported to a CSV appear in a different order than in Pyramid
• Fixed an issue where a Present that was printed to Excel produced an empty Excel file
• Fixed an issue where printing 'Current slide' in a Present didn't print the correct slide

Admin

• Fixed an issue where adding an MSOLAP data source using a global account had failed
• Fixed an issue where it was not possible to enable or disable the Proactive Garbage Collection and Proactive Rendered Collection
• The Restart Server option under the Summaries Panel was renamed to a more accurate Restart Service

APIs

• Fixed an issue where /API2/access/getAllRolesByUser did not bring back the roles assigned via AD groups
• Fixed an issue where /API2/access/updateTenantsSeats did not work unless both Pro and Viewer users were specified
• Fixed an issue where /API2/content/importContent did not return importDscMap when importing content that was exported with a folder
• Updated the Help for /API2/content/importContent
• Updated the Help for /API2/access/createUserSaml
• Fixed an issue where /API/auth/authenticateUserOPENID did not work as expected

Security

• Fixed an issue where Pyramid did not log a failed login attempt of a user who logged in using SAML and does not exist in Pyramid
• Made several security improvements to internal API calls

Installer

• Fixed a DB script issue that caused an upgrade to fail
• Fixed an issue where the installer failed with an "Error copying file" message
• Fixed an upgrade issue when using Azure SQL as a repository

Mobile

• Fixed an issue where the Date filter did not show properly on the mobile application
• Fixed an issue where a Dynamic Text did not refresh on load in the mobile application

Other

• Fixed an issue where Kubernetes upgrade had failed when SSL encryption was used to connect to the DB
• Fixed an issue where the Garbage Collector did not run on Kubernetes installations and on Linux machines
• Fixed an issue where upgrading to 2020.20 failed with an "Invalid column name 'execution_area'" error
• Fixed an issue where a "Cannot read properties of null (reading 'offsetWidth')" error appeared when having multiple content items opened

Version 2020.20 is the main release of Pyramid for 2021. It includes over 100 new named features together with numerous functional upgrades, unnamed features  and fixes - all designed to make Pyramid the leading Decision Intelligence Platform that drives confident decisions, and produces results.

Version Details

• Visit the official release page. 
  • The version includes over 90 specific customer requested features collected from the forum and other venues.
  • A more detailed list of all the new and upgraded capabilities can be found on the key features listing page - which includes brief explanations and multiple demo videos.
• A separate listing of bug fixes is available here.

Software

• The installer files can be downloaded from the Pyramid Customer Portal.
  • Containers for Kubernetes-based deployments have also been released on Docker and can be downloaded for deployment. 
  • Updates to the Embed APIs have also been posted to NPM.
• Help for upgrade installations can be found here.

Cautions

Pyramid 2020.20 is a major upgrade to previous versions of the platform. It contains numerous upgrades, adjustments and fixes to existing capabilities. As such, Pyramid strongly recommends that the new release is tested on a duplicate version of your existing content database repository before any production upgrades are applied.

The mechanism for licensing SAP BW and HANA connectors has changed. If you use these data sources, please contact your sales executive before upgrading your installation.

Apart from brand new capabilities, the areas that are most affected include:

• Settings and appearance of Slicers
• Visualization formatting interfaces and tools have been upgraded
• Conditional Formatting tools and options (including the behavior or the color and indicator drop zones)
• Grid Visualizations (and support for wrapping) 
• Custom Visual APIs
• Interaction tools in Present
• Excel Exports
• Data Flow operations (with new node-to-node connectivity and mapping)
• "App Tab" UI and functions
• Embedded content and features
• Conversations and interoperation with new Custom Workflows
• Ribbons

Note: If you are upgrading 2018.x, the changes may be more significant.

Software

The main installer files can be downloaded from the Pyramid Customer Portal.  Docker containers have been upgraded for Kubernetes deployments.

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

Pyramid 2020.18 includes changes to existing capabilities.

As such, Pyramid recommends that the new release is tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

Fixes / Changes

UI

• Fixed display issues found when using the Chrome 91 browser update

Model

• Fixed several issues related to duplicated tables
• Fixed an issue where creating a model based on an Excel file had failed

Discover

• Fixed an issue where the themes dropdown could not be opened if the browser zoom level was set to a value lower than 100%
• Fixed an issue where a member appeared outside of a hierarchy in an OLAP cube
• Fixed an issue where a Filter was removed when moving between Matrix grid and Tabular/Raw
• Fixed an issue where adding an indicator to a column of a grid indented all other columns
• Fixed an issue where an ODATA link returned the formatted value of the column
• Fixed an issue where a query is not filtered by a filter that is ordered by column
• Fixed an issue where members of a ragged hierarchy did not appear
• Fixed an issue where a Not Enough Information message incorrectly appeared in a report that was using Combined Elements
• Fixed an issue where SAP BW content did not show Breadcrumbs for Discover objects
• Fixed an issue where a bar color in a bar chart did not change based on the item in the Color drop zone
• Fixed an issue where map tooltips showed incorrect data when using cumulative functions
• Fixed an issue where an attribute could only be added to the drop zones after a metadata refresh
• Sankey chart tooltip now shows source on top and target on the bottom
• Fixed a Stacked Column chart issue where a measure that was added to the secondary axis did not appear in a separate column
• Fixed an issue where 'show empties' on Rows or Columns wasn't working in a specific scenario
• Fixed an issue that was causing some grid cells to appear empty when using OLAP

Present

• Fixed an issue where a blank page opened after selecting All in a filter and jumping to a content item
• Fixed an issue where a query was not filtered correctly after changing a filter type
• Fixed an issue where a Place Holder showed the value of a disabled filter it was interacting with
• Fixed an issue where a blank screen appeared after clicking on Advanced Settings for a broken filter
• Fixed an issue where the Initial Selection setting in a filter did not save
• Fixed an issue where it was not possible to change slides due to a query that returned "Not Enough Information"
• Fixed an issue where Jump to Content Item from a Pop Up did not work
• Fixed an issue where a filter interaction did not work after selecting all and unselecting a few members
• Fixed an issue where disabled mapped filters interacted with the visual on the first run of the presentation
• Fixed an issue where an embedded tiled presentation appeared blank
• Fixed an issue where Quick Sort did not work as expected
• Improved load time for dashboard runtimes when there are numerous slicers

Publish/Subscriptions

• Fixed an issue where a Subscription that was created in the Content Management was formatted incorrectly
• Fixed an issue where data was filtered incorrectly in a print of a publication
• Fixed an issue where blank components appeared in a publication print

Formulate

• Fixed an issue where a member selection was lost when editing a formula
• Fixed an issue where Dynamic Captions in a KPI did not appear in the KPI's Secondary Label
• Fixed a text alignment issue with Hebrew Dynamic Captions in KPIs
• Fixed an issue where a comment in the MDX of a formulation returned inconsistent results
• Fixed an issue where a calculation that contained an IF statement returned an incorrect result
• Fixed an issue where a calculation with a parameter within a 'strToMember' has failed
• Four new functions added: DatasetRowRange, DatasetColumnRange, Indexof Max, IndexofMin

Illustrate

• Fixed an issue where turning off a dynamic property of an illustration did not disable its queries

Content Management

• Fixed an issue where subfolders did not appear in a folder that was copied from Private to Public
• Fixed an issue where the Search returned unexpected results
• Fixed an issue that was causing a snapshot refresh to fail
• Fixed an issue where copy a dashboard then Deep Paste and replace created duplicated items
• Fixed an issue where the Versioning option did not appear when the browser zoom level was set to 90%

Printing/Export

• Fixed an issue where a measure number format in a grid was changed in an Excel print
• Fixed an issue where IMG URLs in a grid were printed blank
• Fixed an Excel print issue of a report that is based on an OLAP cube where the cube language is set to Czech 

Admin

• Fixed an issue where a change in the UPN of an AD account could not be updated in Pyramid
• Fixed an issue where copying a data source with a long name had failed
• Fixed an issue where filtering the model schedules by Name caused an error
• Fixed an issue where the log did not trim according to the configured timespan
• Fixed an issue where a Provisioning job stopped if there was an issue adding one of the users

APIs

• Fixed an issue where the createDataServe and create tenant APIs accepted non UUID values
• Fixed an issue where the getAllUsersByTenant API returned all users in all tenants when Cross Tenant User Roles was enabled
• Fixed an issue where a folder in a workgroup couldn't be found using content/findContentItem after granting role access to it
• Fixed an issue where, after adding roles to workgroup content using addRoleToItem, the UI Roles icon was no longer greyed out
• Fixed an issue where custom data did not update for a user when logging in again with different customer data
• Fixed an issue where API2/tasks/getSchedulesForUsers failed when using PostgreSQL as a repository
• Fixed an issue where API2/access/getLicenseCount returned the total number of free licenses
• Fixed an issue where API2/dataSources/addRoleToItemAndBubbleUp failed
• Fixed an issue where API2/access/createUsersDb did not return the user Ids in the order in which they were created
• Improved XSS security handling on various admin functions.

Other

• Cube actions that open pop-ups were removed from the Actions menu in embedded content
• Fixed an issue that was causing a "Cannot read property 'then' of undefined" error message to appear randomly
• Fixed an issue where tasks appeared to not start or not clear out in the Spooler
• Fixed a German localization issue in Subscriptions
• Fixed an issue where a conversation link led to the start page
• Fixed various broken tutorials.

Importantly, it includes the last preview release of the Kubernetes version before it is officially RTM'ed. 

Software

The main installer files can be downloaded from the Pyramid Customer Portal. 

• The EMBED APIs in NPM is upgraded and is available for update.
• Docker containers have been upgraded for Kubernetes deployments.

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

Pyramid 2020.17 includes several key changes to existing capabilities.

As such, Pyramid recommends that the new release is tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

New Features

Admin

• New persistent storage options: SFTP, FTP, NFS
• New REST API authentication options for SAML

Kubernetes

• Scaling models for Run time Services, AI services, Task Services
• Faster switching and handling of requests between services
• New persistent storage options: SFTP, FTP, NFS

Fixes

Model

• Fixed an issue where a Model failed to process after renaming a column with multiple measures

Discover

• Fixed an issue where Copy Raw Data failed on a report with a parameter
• Fixed an issue where right clicking a broken (red) chip in a report caused a blank screen
• Fixed an issue where a unneeded scroll bar appeared in a grid after swapping dimensions

Present

• Fixed an issue where the Create Date text field showed an incorrect date in runtime

Subscriptions

• Fixed an issue where a report subscription did not update based on a dynamic selection in a filter

Formulate

• Fixed an issue where editing a KPI failed with a "Type Error: Cannot read property" error
• Fixed an issue of inconsistent results of a Range list in an environment with multiple Runtime engines

Other

• Fixed an issue where the data source did not change after using the data source changer API
• Fixed an issue logging into Pyramid using IE
• Fixed a broken link in the Model tutorial
• Fixed a broken link to the French online help

Software

The main installer files can be downloaded from the Pyramid Customer Portal. 

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

Pyramid 2020.16 includes numerous changes to existing capabilities.
As such, Pyramid recommends that the new release is tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

New Features

• A new 'Embed Snippet' code generator tool has been added to help developers create content snippets for native JavaScript, React, and Angular.
• Users can now print content from Discover and Present items natively embedded inside other host applications.
• A new 'active' memory manager has been added to reduce the memory usage for servers.
• Upgraded the data connection for SalesForce - allowing customers to configure the setup with their own API keys.
• New REST APIs for getting notification indicators.

Fixes

Model

• Fixed an issue where manually added indexes didn't get created when Auto Index was off
• Fixed an issue where adding/removing specific columns in a direct query model did not work
• Fixed an issue where it was not possible to create a model based on Salesforce
• Fixed an issue where invoking a stored procedure that involved the usage of local temporary tables failed
• Fixed an issue where a table got duplicated when saving or processing the model
• Fixed an issue where Logical Regression did not refresh the score after processing the model
• Fixed an issue that caused incorrect values to appear in a model based on an Oracle data source in a specific scenario

Discover

• Fixed an issue where a report failed to run if the user didn't have permissions to a specific measure that was used in it
• Fixed an issue where the 'Fx' function did not appear for new Discoveries
• Fixed an issue where the List Builder did not select members that had a space as the first character
• Fixed an issue where the Axis Label was cut off on the Y-axis
• Fixed Alignment issues in a KPI when using the Hebrew UI language
• Improved stability when using the Lasso functionality in a chart with a large number of bars

Present

• Fixed an issue where Pyramid became unresponsive after jumping to a content item and making a filter selection
• Fixed an issue where Cross Model Mapping failed after navigating between slides
• Fixed an issue where an interaction to a place holder and a dynamic text did not work on the initial load of the slide
• Fixed an issue where the report filters did not appear in a pop up that was opened by an Action
• Fixed an issue where the Undo, Redo and Print options did not appear in a report that was opened in a pop-up
• Fixed an issue where a filter failed with an Enumeration Failed error

Subscriptions

• Fixed an issue where, in case the user and server are in different time zones, the correct time zone and start date appeared only after a refresh
• Fixed an issue where an email was sent by a subscription-only if the Email tab was clicked in the subscription setting

Publish

• Fixed an issue where a blank screen appeared after clicking on the Distribution tab in a Schedule
• Fixed an issue where an additional page was added to a scheduled publication printout
• Fixed an issue where a publication filter didn't apply to a discovery object if it was added multiple times
• Optimization added to help prevent a publication print to fail due to a large theme
• Fixed an issue where a text in a publication that was exported to Word appeared at the background

Formulate

• Fixed a caching issue with the Except function
• Fixed an issue where LastChild returned an incorrect member in IMDB

Content Management

• Fixed an issue where the Tenant Team Member Content Explorer only showed users with lower case usernames
• Fixed an issue where a Viewer user was unable to open a folder that had Roles from several tenants
• Fixed an issue the data source of a Filter was changed after export/import

Printing/Export

• Fixed an issue where exporting a report with Top Grand Totals to Excel did not export the Row Header

Conversation

• Fixed an issue where a Conversation email was sent with a broken hyperlink when the Pyramid UI language was German
• Fixed an issue where the Conversation icon did not open the chat window for a viewer in Analyze Further

Admin

• Fixed an issue where the Apply button did not appear when uploading a new license while using a low screen resolution
• Fixed an issue where adding a user failed with a blank screen
• Fixed an issue where Provisioning failed with a "The Incoming request has too many parameters" error
• Fixed an issue where disabling a large number of users in bulk failed

Other

• Fixed a layout issue in the Classic and Reverse Analytics workspaces when using Firefox
• Fixed Discovery Tutorial 1 which failed at step 8
• Fixed a caching issue that caused a direct URL link to not work correctly
• Fixed a SQL query issue that caused the getScheduleExecutionStatus API to fail

Software

The main installer files can be downloaded from the Pyramid Customer Portal.

• The EMBED APIs in NPM is upgraded and is available for update.
• Docker containers have been upgraded for Kubernetes deployments.

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

Pyramid 2020.15 includes numerous key upgrades and fixes to existing capabilities.
As such, Pyramid strongly recommends that the new release is tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

Further, a database repository backup should be made before upgrading any production systems and repositories.

New Features

Model

• Added new IBM DB2 for AS400 connector.
• Upgraded connection options for Microsoft Multidimensional (OLAP) and Tabular data sources in the Admin Console allowing HTTP access to Analysis Services using MSMDPUMP.dll. It also includes a new "Use Multi Pass Authentication" option to better control on how Pyramid authenticates to these data sources
• Added a new  ODBC 'Direct Query' connector - allowing users to query ODBC sources directly. (Note this will only work on ODBC data sources that are fully ANSI SQL compliant).

Discover

• Upgraded accounting grid styles to support background colors.

Content Management

• New hover-over tooltips in the content explorer showing meta data
• New content view options for "Viewers"

Fixes

Security

• Security updates and upgrades to the internal encryption framework
• New additional security measures to harden the web-based client

Model

• Fixed an issue where trying to use the Market “Basket Analysis – R” node in a flow resulted in an error
• Fixed an issue where existing publication schedules did not appear in a Master Flow "Pyramid Event"
• Fixed an issue where an error message appeared after trying to access a data flow from the master flow
• Fixed an issue where a blank screen appeared after running an Execute Process node with Load Error disabled in the master flow
• Fixed an issue where non admin users were unable to see the Salesforce db when using salesforce as a source
• Fixed an issue where a Full Outer Join which has <= or >= in the Relation setting have caused an error in Discovery
• Fixed an issue where uploading multi text files failed with a "Column type are not the same" error
• When working with a PostgreSQL data source, Pyramid will now be able to automatically detect Materialized Views
• Fixed an issue where a model that is based on a Pyramid source did not update correctly after a process

Discover

• Queries:
  • Fixed an issue where Totals showed incorrect values
  • Fixed an issue where adding totals to a report resulted in a timeout
  • Fixed an issue where using a Lag function for a data point in a formulation failed when using a Date Calendar filter
  • Fixed an issue where a change to a hierarchy caption was not reflected in Row and Column headers of a grid
  • Fixed an issue where a parameter of a date attribute caused an error when placed in Combined Elements
  • Fixed an issue where parameter selections reverted to default after adding a Forecast
• Visuals:
  • Removed the options to change the Country and Water color when using a Blank map type
  • Fixed an issue where columns are not scrolling correctly in a grid when using the Hebrew UI language

Present

• Fixed an issue where a "null" was added to the URL of a Jump to URL action
• Fixed an issue where Quick Sort in a Present did not work correctly when a measure list parameter was used
• Fixed an issue where Jump to URL did not work when an '&' was used in the UniqueNames() delimiter text
• Fixed an issue where a small grid did not render after making a filter selection
• Fixed an issue where a cursor and the tooltip were not aligned correctly in a chart when using scale up & down
• Fixed an issue where slicer save settings from Discovery were retained when using the slicer as Date Calendar in a present
• Fixed an issue where a present could not be opened after import
• Fixed an issue where slicers in a Present did not cascade as correctly
• Fixed an issue were a blank screen appeared after closing a Click Action pop up while it was still loading
• Fixed an issue where the Chat Bot and Smart Insights options did not appear in the Runtime Options for existing content
• Fixed an issue where creating an interaction between a filter and a grid failed with a Null Pointer Exception
• Fixed an issue where, in a specific scenario, a presentation caused the runtime service to crash
• Fixed an issue where Date Calendar filter was cut off in small screens
• Fixed an issue where a Date Calendar filter which has no members caused the Presentation to fail

Publish

• Fixed an issue where the Table of Content did not work with flow visuals

Formulate

• Fixed a List issue where selecting all members in an attribute showed the All member as selected but did not include it in the list
• Fixed an issue where adding a member with "<" or ">" in its name to a Standard List node caused it to disappear

Content Management

• Fixed an issue which caused the process of restoring deleted content to fail
• Fixed an issue where Analyze Structure incorrectly indicated a report problem
• Fixed an issue where an imported calculation failed in case its data source was down while running the Data Source Changer on it

Printing/Export

• Fixed an issue where a grid Column Header did not scale correctly when using Scale to Fit
• Fixed an issue where a line chart that is based on certain custom calculations failed to print to Excel

Conversation

• Fixed an issue where the Conversation button did not work for a Viewer user
• Removed the Conversation option which was incorrectly showing in content that was opened through a direct link
• Fixed an issue where some Slovenian characters did not appear correctly in a conversation

Admin

• Fixed an issue where clicking the Test button in the SMTP setting kept prompting the user for a password
• Fixed an issue where the options to email the enterprise and domain admins did not work for the Device ID Check in the mobile settings
• Fixed Theme issue where the Report Color setting affected the inherited font color

Embed

• Fixes applied to the Angular library for embedding (hosted on NPM).

Other

• Improved the way queries are cleared from the Pyramid Windows Connector (DNC) memory
• Fixed an issue where the direct link to the item [DL] did not appear as default in an Alert message body
• Fixed an issue where some temp files didn't get deleted
• Fixed an issue where the Agent and File Server services didn't start after an install

Software

The main installer files can be downloaded from the Pyramid Customer Portal.

• The EMBED APIs for React and Angular in NPM have upgraded and is available for update.
• Docker containers have been upgraded for Kubernetes deployments.

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

Pyramid 2020.14 includes numerous key upgrades and fixes to existing capabilities.
As such, Pyramid strongly recommends that the new release is tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

New Features

• Funnel charts - multi-measure support added
• New option in SAP BW Parameter selection to user 'master data' as opposed to 'Info Provider' data only.
• Upgraded the Embed APIs for React and Angular frameworks
• This version includes changes for 'Preview 2' for Kubernetes deployment of Pyramid.

Fixes

Model

• Fixed an issue to enable a model to open the flow with the summarize node
• Fixed an issue where the ODBC data source failed to connect to Pervasive SQL
• Fixed an issue with the OData date fields
• Fixed an issue when connecting to Synapse DB, Azure SQL Data Warehouse, it was trying to connect to the master DB
• Fixed an issue where using Unpivot resulted in unexpected behavior in Discovery
• Added the ability to set escape character as a delimiter when connecting to a text data source

Discover

• Queries:
  • Fixed an issue where using the "Exact" filter with text global parameter threw an error
  • Fixed an issue related to sorting in a specific scenario
  • Handled errors better when using an invalid forecast script
  • Added support for Median Aggregation on redshift data source
• Visuals:
  • Fixed an issue where hovering an area chart  showed only the first data point in the tooltip
  • Fixed Incorrect position of columns when using a chart with both a Column and Area chart
  • Fixed an issue where Hebrew Column headers were shown mirrored  in a Tabular grid when using the Hebrew UI language
  • Fixed grid alignment issue when using nested attributes while using the Hebrew UI language

Present

• Fixed an issue where an interaction between a filter and a visual did not work in the initial load of the slide
• Fixed an issue where a folder that contains Parameters only showed as empty in the Content panel
• Fixed an issue where a JavaScript jump action did not work when the present was accessed via a direct link

Publish

• Fixed an issue where Dynamic Distribution did not work when publishing to the Bulletin board

Content Management

• Improved performance when saving content
• Fixed an issue that was causing the Structure Analyzer not to work properly.

Embed

• Blocked the 'Analyze Further' shown in embed for a viewer licensed users

Admin

• Fixed an issue occurring when trying to use auto-provisioning
• Fixed an issue where schedules didn't appear on the Schedules menu in the admin console

Other

• Fixed an issue with the Add User API

Software

The main installer files can be downloaded  from the Pyramid Customer Portal.

• Upgraded native mobile apps for Android and iOS will be released in the next few days and made available in the relevant app stores.
• The EMBED APIs in NPM is upgraded and is available for update.
• Docker containers have been upgraded for Kubernetes deployments.

An upgraded version of the BI Office Converter will be released within the next several days.

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

Pyramid 2020.13 includes numerous key upgrades and fixes to existing capabilities.
As such, Pyramid strongly recommends that the new release is tested on a duplicate version of an existing content database repository before any production upgrades are applied. 

The following notable deprecations have also been made:

• The user creation APIs have been upgraded and the old APIs have been deprecated.
• Support for Ubuntu 17 has been deprecated - because the OS itself is out of support.

Fixes

Click here to see the list of fixes made in this version.

New Features

• Key features are in bold.
• Several new features are being released as betas or preview releases only.
• Click the stars to see help and videos ★

Software

• The installer files can be downloaded from the Pyramid Customer Portal.
• Help for upgrades can be found here.
• Help on how to test an upgrade before deployment can be found here.
• An upgraded BI Office converter (1.1.5.6) has been released.

Cautions

Pyramid 2020.12 includes upgrades and fixes to existing capabilities.
As such, Pyramid strongly recommends that the new release is tested on a duplicate version of an existing content database repository before any production upgrades are applied.

New features

Model

• Added an option to change the default destination date/time/date-time format, due to an issue where seconds were not displayed in Date-time members
• New options in the relationship diagram to more easily see join lines. Also, improved graphics for join types and join directions (between dimension and fact tables).

Bulletin board

• Added an option for admins to see all run scheduled models

Visuals

• Added new Chord diagram in Custom Visual Marketplace

Discover / Query

• New PQL functions:
  • Switch, NotEqual, Tostring , DateToTimestamp, TimestampToDate
• Discovery Lite ribbon - Added button to show/hide the grid lines

Admin

• Added an option for admins to purge all deleted items by date, user(s) etc
• Added new option to connect to SAP BW Message Server (Beta)

Infrastructure

• Upgraded jQuery libraries to 3.5.1
• Online help upgraded. 
• New embed code examples loaded to GitHub.

Items fixed

Model

• Improved error handling in the master flow logic
• Fixed an issue where Shallow Neural-Network Model Node didn't work when Pyramid run on Linux
• Fixed an issue that occurred when running a certain query that contained an array on AWS Athena
• Fixed an issue when using duplicated Python scripts where created columns had the same column ID
• It's now possible to add a server in the SQL Script node of the Master Flow

Discover

• Fixed an issue where a report get stuck when you change the filter
• Fixed an issue wherein RTL changing the grid column width wasn't working
• Fixed an issue where a hidden field from the model was visible in the discovery
• Fixed an issue where the app was hanging after eliminating a formulation from a report that was opened with a link or an action
• Fixed a black screen issue caused when changing from a Date slicer to a dropdown slicer and opening the advanced options
• Fixed an issue where incorrect level icons appeared for levels of a non-aggregated hierarchy in the dimensions tree
• Fixed an issue where the Apply button was missing from the Define Model Parameters window when creating a new Discover and using a low-resolution screen
• Fixed an issue where there was no indication of the currently selected grid Alignment setting
• Fixed an issue where the Member Search on a Drill Path Hierarchy had failed

Queries

• Fixed an issue when adding a date filter that contained a large number of members
• Fixed an issue where a report with N of N failed with a "Can't run the given query" error when the query returned no results
• Fixed a sorting issue related to OLAP order type
• Fixed an issue where Named sets in an ordered query were missing the subset elements

Charts

• Fixed an issue where the Bubble Map Chart placed Cities wrong
• Fixed an issue where a slicer selection contained a NULL value and caused the connected chart to fail, resulting in a Black screen
• Fixed an issue where the "Start New Conversation" did not appear for particular bars in a column chart
• Fixed an issue where the error "Cannot read property 'datapoint' of undefined" was appearing when a regression line was used

Present

• Fixed an issue when Jump to slide wasn't working when the slicer had 'All' selected
• Fixed an issue when Jump to a content item failed when the source query had filters with 'All' selections (scripted custom set)
• Fixed a Black screen issue that occurred when using a cube action in a presentation
• Fixed an issue where a Theme change is not applied to a present in the first run
• Fixed an issue where Interactions stopped working following the upgrade to 2020.11.025
• Fixed an issue where interaction was throwing an error related to parameter
• Fixed an issue in the cross highlight interactions (single click interaction)
• Fixed an issue in the advanced cross model SQL hierarchy where the first and last characters of the members were truncated
• Fixed an issue where Measure Parameters were not displayed with their correct name in the grid

Publish

• Fixed an issue with the Table of content vertical alignment
• Fixed an issue where a publication failed to run after deleting its report trigger

Formulate

• Fixed an issue where the measure name in a formulation Preview was Incorrect
• Fixed an issue where a refresh was required in order to see a calculation that was just made shareable

Illustrate

• Fixed an issue when selecting multiple info-graphics with the CTRL key caused all other elements to be deselected

Content Management

• Removed the Save option in a report opened by 'Analyze Further' when using a direct link
• Fixed an issue where saving a report in Analyze Further had failed
• Fixed an issue where content snapshots got deleted after paste

Printing/Export

• Fixed an issue where export to Excel failed if a page contained a chart

Admin

• Fixed an issue where Settings > Cache size could not be set to zero
• Fixed an issue where after adding a mobile device manually, the save option wasn't enabled
• Added the missing region eu-west-2 (London) when using Amazon Athena data source
• Fixed an issue where preforming Analyze Structure on an item didn't get logged in the Audit Trail
• Added a scroll bar to the Scripting Environments edit panel

Other

• Fixed an issue where In the Bulletin Board, 'Read' Model jobs and publication jobs remained marked as 'Unread'
• Added Support for "CMD + Click" when running Pyramid in a Mac
• Several fixes to the Tutorials
• Fixed an issue where Python failed to upgrade when upgrading the product

Software

• The installer files can be downloaded from the Pyramid Customer Portal.
• Help for upgrades can be found here.
• Help on how to test an upgrade before deployment can be found here.

• Upgraded Tablet & Phone applications have also been released on the Android and iOS app stores (version 7.01).
• An upgraded BI Office converter will be released shortly.

Cautions

Pyramid 2020.11 includes numerous upgrades and fixes to existing capabilities. As such, Pyramid strongly recommends that the new release is tested on a duplicate version of an existing content database repository before any production upgrades are applied.

New features

• Added Tornado charts to the visuals.
• Upgraded logic for hierarchical, Top-Down and flat totaling.
• Added new quick filters  -equals and not equals.
• Added support for SAP predefined parameters in the scheduling and publications.
• Add a new search from the folders.
• Removed complex technical messages from error boxes. Details can now be searched by an admin using Search Error by ID.
• Version 7 of the mobile phone app was released for both Android and iOS to support SAML and Azure Proxy authentication.

Items fixed

Model

• Fixed an issue where unchecked tables in the model where showing up in discoveries
• In Python, Increased the default size of the string columns of the scripting nodes
• Fixed an authentication issue when trying to connect to a SharePoint office 365 sub-site
• Fixed an issue where Edit ETL schedule was throwing an exception
• Increased the maximum file upload size from 200Mb to 2Gb
• Fixed an issue where import model file on oracle failed
• Fixed an issue where the 'Summaries' node wasn't working on 'Average' column
• Fixed a 'Black Screen' issue when in the model tab and selecting the 'Save as' option

Discover

• Fixed an issue where the 'Ask a Question' feature was enabled while the NLQ setting was disabled
• Fixed an issue where Totals were formatted incorrectly
• Fixed an issue changing grid column width when using the Hebrew UI
• Fixed a blank screen issue when editing roles that were applied to a custom overlay
• Fixed an issue where a one-off calculation (created using the context menu) was deselected after a Save As
• Fixed an issue where it was not possible to search within the input parameters drop-down when using SAP BW
• Visual improvements in the Define Model Parameters window
• Fixed an issue where a date slicer didn't work after refreshing metadata
• Fixed an issue where the technical name of a SAP BW model did not appear in the model list

  • Queries:

    • Fixed an issue where a BW report crashed after opening it
    • Added support in Operators for BW Parameters
    • Fixed an issue where a report with a tree slicer crashed for a Viewer user
    • Fixed a query issue in a specific scenario when in flat mode and 'Optimized Compressed' is selected
    • Fixed an issue where the All member could have had an incorrect caption
    • Fixed a query error with a BW query in Flat mode in a specific query
    • Fixed BW - Database names

  • Charts:

    • Fixed an issue in gauges, where reversed bands didn't work in arcs
    • Fixed an issue in the Scatter Chart: Axes options / 'Start from Zero'
    • Fixed an error "Cannot read property 'value Title'" related to gauges after upgrading to 2020.10
    • Fixed an auto-scaling issue on a chart that has negative values

Present

• Fixed an issue where Present filters were not loading after upgrading to 2020.10
• Fixed an issue where a Discovery report showed Not Enough Information when jumping into it from a present
• Fixed an issue where the Legend component was added to content in Present after upgrading to 2020.10
• Fixed an issue where a Tree Slicer did not interact with a Place Holder
• Fixed a tab navigation issue
• Fixed the Filter calendar dates range which was showing wrong (to)month after reopening it (in discovery and present)
• Added functionality to the undo/redo for dragging layout elements to the canvas
• Fixed an issue where content that was removed from a slide still appeared under Used Content
• Improved cross model validation messages
• Fixed a minor visual issue when using bold text in Present Lite
• Fixed an issue where it wasn't possible to deselect an element in edit mode when clicking on a master page element

Publish

• Fixed an issue where triggers were removed from a publication after copy/paste or an import
• Minor UI improvements in the Selections section of the scheduler

Formulate

• Fixed 'Black Screen' issue in the properties panel/color panel when using an OLAP data source
• Added an option to see model parameters in Script Mode

Illustrate

• Fixed an issue where saving an illustration failed with a "One or more items have invalid properties" error
• Fixed an issue where a text that has a background color set was not highlighted when doing a search
• Fixed an issue where it was not possible to rename a dynamic function

Content Management

• Fixed a Black screen issue caused after duplicating a discovery containing a "Measure Parameter"
• Fixed an issue where an imported report was not showing any data

Printing/Export:

• Fixed an issue where a hyperlink did not work in a Publication that was printed to PDF

Admin

• Fixed an issue when trying to upload a shape file above the file upload limit, no info message shown
• Fixed an issue where a security table could not be expanded in Member Security
• Fixed an issue where provisioning wasn't adding users in a specific scenario
• Fixed an issue where an incorrect error message appeared when uploading a license with an invalid date
• Fixed an issue where an incorrect error message appeared when uploading a license with the wrong machine key
• Fixed an issue where Security & Metadata overlays did not work as expected when on a BW data source

Security

• Blocked the possibility of a persistent cross-site scripting attack via the conversations
• Added a check and a notification when installing and using a SQL user with special characters which are not supported

Other

• Numerous upgrades were made to online help
• Localization fixes and adjustments
• Clearer error message when entering an incorrect URL to the Pyramid mobile app

Version 2020.10 is a follow-up release of Pyramid this year to 2020.0. It includes over 150 new features and functional upgrades together with numerous fixes - all designed to make Pyramid’s Analytics OS the leading platform for Trusted Analytics™ that connects your teams, drives confident decisions, and produces winning results.

Details

• Visit the official release page. The 2020.10 includes over 130 specific customer requested features.
• A more detailed list of all the new and upgraded capabilities can be found on the key features listing page - which includes brief explanations and multiple demo videos.
• A separate listing of bug fixes is available here.

Software

• The installer files can be downloaded from the Pyramid Customer Portal.
  • Upgraded Tablet & Phone applications will be separately available on the Android and iOS app stores within the next week or so.
  • The BI Office converter will NOT operate with this release. An upgrade for this tool will be released within the next few weeks that is compatible with 2020.10.
• Help for upgrade installations can be found here.
• Help on a new option to test an upgrade before deployment can be found here.

Cautions

Pyramid 2020.10 includes numerous upgrades and fixes to existing capabilities. As such, Pyramid strongly recommends that the new release is tested on a duplicate version of an existing content database repository before any production upgrades are applied.

Areas that are most affected since 2020.0 includes:

• KPIs and Gauges changes have been made to rendering and settings.
• Embedding API - the API has been adjusted.
• REST API - the APIs for creating and updating users have been adjusted.
• Handling of user security credentials needed for certain Data Modeling widgets.
• Handling of SAP BW and HANA variables and parameters has changed.
• Handling of the "proxy account" settings for each user - for MS SSAS.
• Baseline memory settings per service as well as these adjustments:
  • The NLQ engine has been shifted to run inside the "AI" service from the "Runtime" engine service.
  • The number of spawned satellite jobs from the Task Engine has been limited to suit server memory.

Note: If you are upgrading 2018.x, the changes may be more significant.

Software

• The installer files can be downloaded from the Pyramid Customer Portal.
• Help for upgrades can be found here.
• Help on how to test an upgrade before deployment can be found here.

Fixes

Discover

• Fixed an issue with Stacked measures pie chart
• New option for hiding Secondary Y-Axis
• Added Rolling Average context calculation.
• Fixed an issue with Dynamic Caption in Measure Set.
• Fixed an issue where custom data wasn't flowing into MDX.
• Fixed an issue with Tabular grid totals.
• Fixed an issue where a set in combined elements didn't resolve.
• Fixed an issue where forecast on a parameter was falling to execute.
• Fixed a printing error when trying to export a discovery report.
• Slicers:
  • Disabled the ability to select 'Named sets' in slicers.
  • Improved the slicer dialog so that it shows without a scrollbar.
  • Fixed the horizontal alignment for button slicer in Explorer.

Model

• Added a new Data source, IBM "Netezza".
• Fixed an issue where adding a URL file data source was falling.

Present

• Fixed an issue in the presentation related to blank measures in a chart.
• Fixed an issue with a predefined Parameter usage in Custom Elements.
• Fixed predefined parameters when cascading of cross model interactions.
• Fixed an issue where predefined parameters were not being passed from design time to runtime.
• Improved load up performance of dashboards.
• Fixed a bug when using runtime context menu actions (Focus, Hide, Dice) with cross model mappings.
• Fixed pin measures docker panel in reverse analytics workspace which was causing a Black screen.
• Fixed Docker panels height issue when placed side by side.
• Fixed asset placeholders printing, the value in the placeholder will display 'placeholder' even after interact.
• Fixed interaction from numeric slider error.
• Fixed the highlight of a measure in legend.
• Fixed refreshing dynamic text when located in the master page.
• Fixed an issue where duplicating a slide with a  shape caused an error.
• Fixed an issue where an asset text box didn't get updated when moving to runtime.

Publish

• Disabled slicers interacting with reports in edit mode.
• Fixed Errors in Publication execution (schedule or printing).

Formulate

• Fixed an issue with the dynamic caption of a formulation in the measure list.
• Fixed an issue where the Percentage of the total indicator was calculated wrong.

Content Management

• Improved logs (open/save) to identify future problems more easily.
• Fixed a security bug where a standard user with a read-only role could create reports in the 'Public' folder.
• Fixed an issue where 'fast discovery models' where corrupted in some scenarios.

Admin

• Fixed an issue where trying to add a server to the application resulted in a BSOD.

Other

• Fixed an issue with resetting the workspace.
• Fixed tutorials for when a user profile restricts some apps (Present, Model, etc.)
• Memory usage limit is now adjustable and can be configured in the config.ini file 

Cautions

This upgrade includes upgrades to existing capabilities.
As such, Pyramid strongly recommends that the new version be tested on existing content before any production upgrades are applied.  

The release should only be applied if the specific fixes are needed in your deployment.

Software

• The installer files can be downloaded from the Pyramid Customer Portal.
• Help for upgrades can be found here.
• Help on how to test an upgrade before deployment can be found here.

Fixes & Changes

• New options were added to improve the performance of deployments using Windows Authentication. (see more below)
• Increased time-outs related to certain long running processes.
• Improved the processing of certain content management operations (like copy/paste) when handling extremely large payloads.
• Fixed color settings for stacked area chart visualizations.
• Corrected problems with slicers and placeholder elements in Present and Publish.
• Improved handling of lists in MDX with new "in-line" set resolution.
• Corrected problems in MDX with handling of special characters in unique names.

Cautions

2020.04.011 includes upgrades and fixes to existing capabilities. As such, Pyramid strongly recommends that the new version be tested on existing content before any production upgrades are applied.  

Importantly, the changes made to the handling of Windows Authentication may affect your implementation if you are using this functionality. Please read this explanatory blog for more and contact Pyramid support for guidance if required.

Software

• The installer files can be downloaded from the Pyramid Customer Portal.
• Help for upgrades can be found here.
• Help on how to test an upgrade before deployment can be found here.

Fixes

Content Management

• Fixed an issue related to import/export of a model with versions
• Fixed an issue when unauthorized users were able to create reports in restricted folders
• Fixed an issue with drill through throwing an error when trying to open content that was already opened
• Fixed an issue where the publication tab closes after performing a 'save as' and replace to name that already exists
• Fixed an issue with the Structure Analyzer that was causing a failure.
• Fixed an issue with the Structure Analyzer  when the member's name was too long

Discovery

• Changed the unreadable color of the N-of-N chip name
• Fixed N-of-N chip style
• Fixed several black screen related issues in a few different scenarios
• Fixed an issue where 'Stacked Area Chart' wasn't being colored when sorted by ascending order
• Fixed the member/measure description to appear as tooltips on the grid column headers.
• Fixed an issue where the Grand total was not showing the correct results due to the way the negative numbers were formatted
• Fixed an issue when changing subtotal from “sum” to “Aggregate”
• Fixed a total issue when the same dimension attribute/hierarchy was used in more than one drop zone
• Fixed an issue where a user wasn't able to select and deselect members in a report where the hierarchy had only one level and no aggregation (no All member)
• Fixed a Black screen issue that occurred when using the 'Search Elements' function
• Fixed an issue where the Line chart was rendered continues instead of a broken line (Due to lack of data…)

Formulate

• Added an option to show measures list based on the user's choice of filters
• Fixed an issue when using a Parameter that holds a custom set ordered by Selection

Model

• Fixed a Black screen issue when clicking on a relationship between tables
• Fixed an issue where testing a table from a custom query would show an endless spinner
• Fixed an issue where Rearranging items in the master flow caused a black screen.

Present

• Improved interaction logic for content accuracy when iterating between slides.
• Fixed an issue where the dynamic text wasn't being refreshed when located on the content page.
• Fixed an issue preventing a dashboard to open in Mobile Using Direct Link
• Fixed a "circular interactions" issue on slicers
• Fixed an issue where you couldn't create an interaction between a parameter and an illustration with a dynamic text
• Fixed an issue where mapping inter cube interaction between OLAP and Tabular wasn't working properly
• Fixed an issue where the report caption settings were not copied across correctly from the discovery to the publication
• Fixed an issue where a "Date part" slicer setting could not be changed in the presentation
• Improved error handling when iterating between application languages
• Fixed an issue where context menu on miniature visuals failed to open
• Fixed an issue where a presentation failed to open due to a broken discovery in the first slide.
• "Ignore Query Cache" was added to the presentation runtime options
• Fixed an issue where the slicer wasn't loading in a specific scenario. (related to content cache)

Publication

• Fixed the truncated bar chart data labels in a publication to match the way they look in discovery

Admin

• Added a confirmation dialog when clearing model settings
• Fixed an issue with renaming themes
• Roles Security enhancements
• Fixed an issue when trying to propagate roles on a folder
• Fixed an issue where the domain administrators were missing or where unable
  to select roles in the source manager
• Added spinners to the feed pages
• Fixed an issue with the zero value in caching timeouts
• Added a limit to server display name length

Data sources

• Errors with connections to Hana 1.0 has been fixed
• Fixed an issue when trying to connect to an Azure Tabular Model with special characters in the password
• Concealed the plain text password that was shown in the error message when trying to connect to a Tabular model on Azure
• Added new (back-end) technique for connecting to MS OLAP and MS Tabular sources based on the latest MS OLEDB driver upgrades. This should reduce issues seen on less reliable Active Directory networks.

Miscellaneous Back-end Items

Printing

• Fixed an issue where the 'Show Title' check did not toggle correctly
• Fixed an issue when printing an empty report to Excel, printing failed

Embed

• Fixed an issue when using a direct link to an embedded presentation, the external target value only worked for the first slide.
• Fixed an issue where Pyramid embed did not override a website specific styles

Tutorials

• Enhanced Tutorials stability

Pyramid Repository

• Removed a duplicated index from Pyramid repository in table server_log_transaction and added another index to increase query performance

Server

• Fixed a potential memory leak in the Windows Connector service

Cautions

2020.04 includes upgrades to existing capabilities.
As such, Pyramid strongly recommends that the new version be tested on existing content before any production upgrades are applied.  

Software

• The installer files can be downloaded from the Pyramid Customer Portal.
• The Android mobile app was recently updated. 
• An update of the iOS mobile app will be available within the next few days.
• Help for upgrades can be found here.
• Help on how to test an upgrade before deployment can be found here.

The release is relatively small and should only be applied if these specific items are needed in your deployment.

New Features

Query Engine

• Added a new PQL function: "Coalesce"

Modeling

• Added MemSQL a cloud database as a new Data Source and Target for models.

SAP BW capabilities (beta)

• Added a new option to authenticate to SAP BW using SAP Logon Tickets
• Added new 'Info Area' trees to better organize databases and BW Info Cubes
• Added the option to limit BW data sources to just those earmarked as ‘OLE DB for OLAP’ access.
• Added a caption toggle that allows users to switch between technical and non technical dimension and measure names.

Mobile

• To simplify reverse proxy implementations for mobile, all activity will now happen within the "/mobile" web folder.

Fixes

Maps

• Fixed the Auto-zoom for ZIP/Postal Code or Address when changing slicers selections.

Content Management

• Fixed an issue where the Missing Data Wizard did not work for slicers which data source is a tabular model.
   
• Fixed an issue where the Save button was disabled after a specific scenario.

Print/Export

• Fixed a print to PDF issue when printing a report with specific content resulted in a blank PDF.

Query Engine

• Fixed a problem where the Analysis Services was case sensitive to Measures vs measures.
• Fixed an issue when aggregating weeks or months on In-memory didn't bring back any results.
• Enumeration failed MDX error with a specific member.
• Fixed an issue where a timestamp member wasn't appearing in a filtered grid due to a bug in In-memory databases.
• Fixed an issue where an exception appeared when you opened a saved discovery with KPI using bands.
• Fixed a minor copy paste issue.
• Fixed an issue causing the query to run twice. (occurs on a SQL database)
• Fixed an issue where query results could not be extracted. (occurs on a SQL database) (occurs on a SQL database)

Present

• Fixed The advanced option for cross model mapping interactions.
• Fixed an issue with a set in a slicer when selecting all the members.

Admin

• Fixed an issue where deleting In-memory models from the UI wasn't working.
• Fixed an issue with cube security.

Infrastructure

• Fixed an issue where the router was timing out while trying to return the RTE.
• Fixed an issue where the Pyramid site did not load when using an AWS load balancer.

Cautions

2020.03 includes upgrades to existing capabilities. As such, Pyramid strongly recommends that the new version be tested on existing content before any production upgrades are applied.  

Separately, a new version of the BI Office Converter was released (1.1.4.5) that is compatible with Pyramid 2020.02 for upgrading old BI Office content Pyramid 2020.

Software

• The installer files can be downloaded from the Pyramid Customer Portal.
• The Android mobile app was recently updated. 
• An update of the iOS mobile app will be available within the next few days.
• Help for upgrades can be found here.
• Help on how to test an upgrade before deployment can be found here.

Bug Fixes

A separate listing of bug fixes is available here.

New Features in 2020.02

Discover

• Major upgrade to the forecasting tools (🎞️video):
  • Forecast prediction bands are now visible in line charts
  • New ability to add the ‘historical look back’ to a forecast
  • New ability to add custom forecasting logic using Python or R in addition to the algorithms provided by Pyramid out of the box. 
  • Sample forecast logic sets with Python and R added to the marketplace
• Visualization upgrades:
  • Major upgrade to matrix grid visualization with new deep formatting options (🎞️video):
    • Ability to customize row, columns and data beyond the theme settings
    • Ability to customize formats of specific rows or columns
  • New waterfall chart settings and upgrade (🎞️video):
    • Ability to designate “end” value logic type and color
    • Ability to select the waterfall mechanism: absolute or differential logic
  • X-Axis label settings and upgrade:
    • Ability to set specific x-axis label area size
    • Ability to set x-axis label orientation
  • New line chart tool-tip (“Category tool-tip”) to make the visibility of data points in a line or area chart clearer.
  • New ‘readability’ switch to turn the automated color heuristic on or off.
• New run-time settings for Discover content launched in embedded or direct mode (via URL) - allows the customization of the context menu options.
• ‘Analyze Further’ capability added to Discover content launched in direct mode (via URL).
• Slicer styling allows customization of the way a slicer looks with new options slicer titles, foreground and background colors (🎞️video).
• New context menu options for turning on Row or Column totals.
• Added support for multilingual metadata on SAP HANA.

Present

• Slide sections can now be collapsed and expanded
• Warning messages on visual can now be suppressed (from run-time settings menu)
• ‘Analyze Further’ capability added to Present content launched in direct mode (via URL).
• New custom canvas size for presentations: allowing the fixed layout presentation to be custom sized. This is particularly useful for embedded content scenarios.
• New snapshot button to trigger an update in slide snapshots for the content manager.
• Slicer styling allows customization of the way a slicer looks with new options slicer titles, foreground and background colors (🎞️video).

Publish

• Warning messages on visual can now be suppressed
• New snapshot button to trigger an update in slide snapshots for the content manager.
• Upgrade in the PQL function editor for dynamic/scripted publication distribution (🎞️ video).

Data Model

• Major update to the Pulse server, allowing all supported data sources to be used in all data flow (ETL) operations as well as direct query.
• Addition of Greenplum and Exasol as a read and write data sources
• Upgrade in the PQL function editor for custom calculations
• New ability to preview table data directly from the table schema interface in modeling.
• New ability to designate if SAP HANA hierarchies will be treated as ‘drill path’ or regular ‘drill-down’ hierarchies (set in the admin).

Formulate

• New ability to set dynamic captions for custom measures and members (elements). Currently only for MDX sources. PQL sources will be added in near future (🎞️video).
• New interface to add derivative selection logic from element trees.

Content Management

• Links sent out in commentary emails now provide a direct link to the conversation thread.
• New Presentation launcher interface from the content manager for both viewers and pro users - allowing users to launch the presentation dashboard with a specific slide. 

Administration

• New authentication time-out options for client token vs embedded tokens vs mobile tokens.
• New ability to turn collaboration data snapshots on or off.
• New ability to designate if SAP HANA hierarchies will be treated as ‘drill path’ or regular ‘drill-down’ hierarchies (set in the admin).
• Upgrade in the PQL function editor for scripted security (🎞️ video).

APIs and Functions

• 10 new advanced PQL functions have been added; covering dynamic text and info-graphics including forecasting and outliers.
• 6 new REST API methods for retrieving user content structures.
• Upgrade in many ‘task’ API’s to allow non-administrative access to API methods.

Documentation

• Online help has been updated with an upgraded function library reference for both PQL and MDX.
• Several new tutorial videos have been added to online help.

Cautions

2020.02 includes upgrades to existing capabilities. As such, Pyramid strongly recommends that the new version be tested on existing content before any production upgrades are applied.  The area most affected is forecasting. Attention should be given to those reports with forecasting. 

New Features

• Mobile Timeout - Admins can configure session timeouts for mobile devices
• Open in Maintenance mode - Discovery reports can be opened in Maintenance Mode which can help fix issues preventing from opening the report normally
• JavaScript Actions can now be created in Discover and Present
• New semantic and common functions were added to the PQL library
• Russian is now supported
• New visual options in Discover were added: including the ability to change the grid row and column colors, customize grid borders and modify the columns in column chart padding/sizing.

A separate listing of bug fixes is available here.

Software

• The installer files can be downloaded from the Pyramid Customer Portal.
  • The various flavors of Linux are all handled from a single installation package. As such, The Ubuntu, Debian, Centos and Oracle Linux installations can be launched from the same installer.
  • Tablet & Phone applications are available on the Android and iOS app stores.
• Help for upgrade installations can be found here.
• Help on a new option to test an upgrade before deployment can be found here.

Version 2020 is the major release of Pyramid this year and includes over 150 new features and functional upgrades together with numerous fixes - all designed to make Pyramid’s Analytics OS the leading platform for enterprise customers looking for solutions that go well beyond visualization.

Details

• A listing of the headline features can be found on the official release page.
• A more detailed list of all notable features can also be found on this supporting page. The features in 2020 include over 50 specific customer requested features.
• A separate listing of bug fixes is available here.

Software

• The installer files can be downloaded from the Pyramid Customer Portal. The build version is 2020.00.055.
  • The various flavors of Linux are all now handled from a single installation package. As such, The Ubuntu, Debian, Centos and now Oracle Linux installations can be launched form the same installer.
  • Tablet & Phone applications are available on the Android and iOS app stores.
• Help for upgrade installations can be found here.
• Help on a new option to test an upgrade before deployment can be found here.

Cautions

Pyramid 2020 includes numerous upgrades to existing capabilities. As such, Pyramid strongly recommends that the new version be tested on existing content before any production upgrades are applied. Areas that are most affected include:

• Visualizations: Horizontal Bar Charts, KPIs and Gauges
• All data flows and data models, especially data flows containing Python scripts
• Slicers on extremely large hierarchies

Upgrading

Instructions and best practice guides on how to run the upgrade can be found here.  As with all upgrades to production-deployed software, Pyramid highly recommends that customers test 5.4-2 on test servers - using mission-critical content - to ensure it performs and responds as expected before deploying into production.

Features

A proxy server can now be configured in the admin console to accommodate proxy servers deployments at customer sites. The current capability enables access to Google Analytics and BigQuery via the proxy. In future releases, other data sources and capabilities that require external web access will get proxy coverage.

Bug Fixes

Query

• Fixed an issue where special characters in member names caused the query to fail when using Google BigQuery.
• Fixed an issue in PQL where using mathematical functions were throwing errors incorrectly.

Admin

• Fixed an issue where Query timeout settings for OLAP didn't work.

Presentation

• Fixed a Trend Line issue causing a slide to not show in Edit Mode.
• Fixed an issue when creating a conversation in the dashboard - the report snapshot didn't open.
• Fixed an issue with dynamic text elements that did not refresh between different slide changes when they share the same base query.

Discovery

• Fixed an issue where some users are unable to see the 'Fx' folder button in Discovery.
• Fixed an issue where eliminating a member causes a render error in a specific scenario.
• Fixed an issue where a Discovery report will show an endless spinner when loading a dimension with member names that have "•" or "♦" in the name

Printing

• Fixed several issues where an Excel export fails to export.

Other

• Greatly improved performance when creating a model based on a MySQL data source.
• Added a theme caching mechanism to improve performance.

Download

Upgrading

Instructions and best practice guides on how to run the upgrade can be found here.  As with all upgrades to production-deployed software, Pyramid highly recommends that customers test 5.4 on test servers - using mission-critical content - to ensure it performs and responds as expected before deploying into production.

New Features

Query

• Added an option to Auto-Include calculated members in OLAP (an option under query settings in discovery)

Admin

• Added a new option in multi-tenancy settings, to disabled 'write-capability' setting for domain admins and users.
• Added a spinner in the metadata library.

Functions

• Added over 20 new functions to the PQL Common library.

Discovery

• Added 'created by' and 'create date' to the information pop up.
• Added background to the 'Treemap' data labels settings.
• Added new logic for background chip in both slicers and drop zones. (It also enables a slicer to remain as such even if it has one element in it)
• Added a new switch in the 'Filter' drop zone, to enable users to select if they want the filter in the Background or on screen.
• New "Grouping" functions in the analytic context menu. Allows users to compare data between selected items (groups) and the remaining items of a query of hierarchy.

Presentation

• Added a query refresh when Run-time timer is auto cycling between slides.
• Added a spinner when Navigate to a slide and the server time takes more than 1.5 seconds

User Experience (UX)

• A spinner was added when opening content in viewer mode, and when opening content from the start page.
• Added new metadata info panels in the Discovery, Presentation (Design and run-time) and in the Publication.

Documentation

• Large upgrade to technical help covering all PQL functions and the REST API library.

Bug Fixes

Installation/upgrade

• Fixed specific date/time format issue in the installation scripts.

Query

• Behavior change:
  if you expand a user-hierarchy that has a custom order, will remove the order.
• Fixed an issue where using a list of custom measure that uses a Background Color have caused an error when using Model Colors.
• Fixed an incorrect member ordering issue when using 'Order By Attribute'.
• Fixed an issue with Measure set with cube colors.
• Fixed an error in parameter with Model Colors.
• Fixed an issue where numbers were formatted incorrectly in a report.
• Fixed an incorrect avg calculation in the in-memory database.
• Fixed an issue when using Copy Raw Data on a Tabular Gird, the content was pivoted in the excel file.
• Fixed an issue when row headers were not displayed in excel when using copy raw data.
• Fixed an issue where a slicer was hanging due to a comma in the measure name.
• Fixed an issue where the Grand total headers were being displayed in the wrong order.
• Fixed an issue where Cube calculated members were missing in the member's list. (Related to reveal elements/open tree on ragged hierarchy).
• Fixed compatibility to BI Office, where a custom member wasn’t colored in a different color.
• Fixed an issue where the Grid didn't show a custom member that was created in the cube, under the same level as the All member when using OLAP.
• Improved performance with Google Big Query data source.
• Fixed an issue where member search didn't work on non-aggregatable hierarchies.
• Optimized query result serializations.
• Fixed an issue where using "Last" filter with Exclude items checked returned null/cannot execute the query.
• Fixed OLAP query failing to run when it had a formulation with an apostrophe (') in its name.
• fixed the Minus functionality so that a calculation of "null - null" resolves to null and not 0.0 as it used to.
• Fixed an issue where expand on a calculated member in the grid was displaying 'children of' as one of the members in the elements tree.
• Fixed an issue where using combine elements in a filter caused a Null error to appear on the screen.
• Fixed an issue getting null values through the Pulse server.
• Fixed a Natural Language Query issue which was causing it to query a KPI and fail.
• Fixed an issue in viewer mode, where a slicer panel and info-card were missing.
• Fixed an issue where elements tree was showing expand option where there shouldn't be one.
• Fixed an issue with elimination in OLAP cubes.
• Fixed an issue with custom visual items tool-tip.
• Fixed an issue with actions when using Contain function.
• Fixed an issue when the elements tree is open and using collapse action.
• Fixed an issue when doing elimination with a set.
• Fixed an issue when expand doesn't remove the custom order from the query.

Presentation

• Fixed an issue where an image in a presentation looked different when opening it from the client site vs a URL.
• Fixed an issue where you couldn't print to PowerPoint because of an interaction error.
• Fixed an issue where a visual changed color and scaling when opening a presentation from a direct link.
• Fixed an issue where a text Global Parameter not working correctly in a presentation.
• Fixed an issue where Text parameter interactions weren't working well.
• Fixed an issue related only to SQL repository, when using Dynamic text with Hebrew text in the presentation the text turned to "???".
• Fixed an issue with shape maps context menu.
• Fixed an issue with dynamic text from a really big query.
• Fixed an issue in the new interaction manager, where the publisher showed render error when the interaction manager is open and a user deletes a visual.
• Fixed an issue where enabling 'Auto Interact' created a new interaction in run-time for Assets.
• Fixed an issue where a parameterized slicer opened in run-time broke.
• Fixed an issue where undo interaction to a web page asset doesn't work.
• Fixed a UI issue in the interaction manager when in RTL.

Publication

• Fixed an issue where you couldn't save publications from the admin.
• Fixed an issue with charts x-axis that wasn't displayed.
• Fixed a render error in the interaction manager, after deleting a visual.
• Fixed an issue where a schedule failed to run if it's creator user was deleted.

Model

• Fixed an issue when using SAP HANA data source, when there are two views with the same name under different folders.
• Fixed an issue with 'Direct Query Left Join'. A visual fix.
• Fixed an issue in Security Tab, where the scroll bar on roles was missing.
• Fixed an issue where roles security weren't saved after a manual change.
• Fixed an issue where roles security where overridden after a scheduled 'process model' was run.
• Improved stability when using R/python (Black screen).

Collaboration

• Fixed an issue when adding a conversation message that is larger than 501 characters.
• Fixed an issue when in Presentation slide show, start new conversation throw an exception.
• Fixed an issue with the scrollbars of the conversations panel.

Admin

• Fixed an issue with the encrypted internal network for OLAP cubes.
• Fixed an issue where upload AD users from a CSV file failed when the list contained users that were removed from AD.
• Fixed a UI issue with scrollbar in the details of job executions
• Fixed a UI issue in the edit schedule page where you couldn't see the save and apply buttons.

Visuals

• Fixed an issue where the Sunburst chart "Details" disappeared when the attribute was moved to the color drop zone.
• Fixed an issue where the second layer in the Sunburst chart wasn't showing details.
• Fixed an issue with Incorrect axis labels format when using a tabular model with the language set to Dutch.
• Fixed an issue where small numbers were displayed automatically as scientific in a grid.
• Fixed an issue where the columns that contained negative numbers in a stacked column chart, were overlapping the x-axis labels.
• Fixed an issue where data tool-tips were not visible when hovering on a shape map.
• Fixed an issue with data labels that get transparent with white background themes.
• Fixed an issue with data labels when the values are negative.

Assets

• Fixed Hebrew language support in the dynamic text.
• Fixed a typo in the error message in the asset screen.
• Fixed an issue where the dynamic text designer was rendered on top of the page save options menu.

Content Management

• Fixed an issue where typing was hanging in the content search text box when there were no results for the given search.
• Fixed an issue where after a presentation import, some of its components were not accessible for users.
• Fixed an issue with the order of the models in the recent.
• Improved content stability related to Alerts.
• Fixed an issue where the save button was disabled on a specific scenario (related to versions).
• Fixed an issue where the Structure Analyzer cannot read SAP Hana Metadata.
• Fixed an issue in the content tree, where after coping a folder then using 'Deep Paste', the original folder seemed missing on the content tree.

Printing Engine

• Fixed an issue wherein a specific scenario you couldn't print to PowerPoint.
• Fixed a localization issue, when the application language was set to Hebrew, emailed publications were displaying the grid from left to right.
• Fixed an issue with printing large query results to excel. The new logic is evaluating the results based on the machine memory. And produces a CSV file if the results are too large.
• Fixed an issue where for every excel sheet, data was being shifted down.
• When Print to Excel, the names of the tabs will be taken from the panel title or by the discovery name. the same name will also be added in the sheet first line.

Localization

• Renamed the text 'data base' to 'database' throughout the application.

Download

PQL

The new help for PQL includes an overview of the Pyramid calculation engine with links to individual topics on key functions - each with one or more examples. The help also covers details on granular, semantic and context functions as well as the common library.

REST APIs

The upgraded REST API documentation now includes plain English explanations for method parameters and outputs. Many functions also come with solid examples that show how to string together different API methods to solve automation projects.

Upgrading

Instructions and best practice guides on how to run the upgrade can be found here.  As with all upgrades to production-deployed software, Pyramid highly recommends that customers test 5.3 on test servers - using mission critical content - to ensure it performs and responds as expected before deploying into production.

Bug Fixes 

Query

• Fixed an issue where SQL queries won't cache when they have a long column and table names.
• Fixed an issue in MDX where order by labels with custom members didn't work.
• Fixed an issue where Domain Admin didn't see the 'Fx' button.
   

API

• Fixed getAuthByToken.

Added Features 

Query

• Users can now set Min/Max measure aggregations on any SQL column data type (instead of only numeric up to now).

Illustration

• Added 'formattedData(x,y)' function to dynamic text, to get the formatted value of a cell in the grid.

NLP - Natural Language Processing