Pyramid 2020.24 (Service Pack 4 for 2020.20) has been released. It includes a sizable collection of fixes for bugs and issues and some behavioral adjustments.

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