The following list enumerates all the main bug fixes in the Pyramid 2023.10 version. 

Click here to see the listing of all new features added to 2023.10.

Fixes in Pyramid 2023.10

Model

• Fixed an issue where using BigQuery as a destination was not possible when set to utilize a service account
• Fixed an issue where a calculated column incorrectly returned a Null value
• 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 users couldn't change the column data types for Multi Files source
• Fixed an issue where users could not edit Calculated Columns in a model
• Fixed an issue where running a query in the Master Flow returned a “No authorization for performing operation” error
• 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 changing the data source on a direct model resulted in the removal of tables from the model
• Fixed an issue setting a Variable value to Null
• Improved multi-measure unique naming logic
• Fixed snapshot isolation errors when using a for loop to connect to an API in model
• Fixed an issue where the initial column in a table displayed with quotation marks when utilizing a CSV source
• Fixed an issue where a variable could not be validated without validating the entire flow
• Fixed an issue where a column data type was erroneously set to Date instead of DateTime
• Fixed an issue wherein milliseconds were inadvertently omitted when saving a DateTime column to a model destination
• Fixed an issue where strings were truncated to 80 length when creating a model using a ClickHouse source to an IMDB target
• Fixed an issue where Snowflake Date Values were showing one day before the actual date

Discover

    Queries

• Fixed an issue where a Discovery that was using a PCH did not retrieve data as expected
• Fixed an issue where a report that was opened from an action was filtered incorrectly
• Fixed an issue where Auto Discover did not work for an IMDB or MSSQL models with Time Intelligence
• Fixed an issue where a "The PQL function 'EXIST' is not supported" error message appeared after using cascading filters
• Fixed a cascading slicer time-out issue
• Fixed an issue where using Focus on a member in a grid returned no results
• Fixed an issue where an error message appeared when using an aggregated table in a report
• Fixed an issue where custom ordering calculations with parameters no longer allowed parameters to impact the results
• Fixed an issue where the YTD function in a Date Calendar filter did not return the current date
• Fixed an issue where a Last Child measure returned no results
• Fixed an issue where the Row Limit that was configured in the report did not apply as expected
• Fixed an issue that could lead to an inconsistent result limit between the initial run of the report and subsequent runs
• Fixed an issue where Multiple infraEntryPoint were generated when hovering over a member

    Visuals

• Fixed an issue saving small decimal values in the Conditional formatting band fields
• Fixed an issue where adding certain dimensions and measures to a report resulted in a blank screen
• Fixed an issue where eliminating a specific data point resulted in the removal of more than the selected item
• Fixed an issue where Sort from Analyze Further had failed
• 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 the context menu did not appear after right-clicking a grid cell with a basic user in embedded content
• 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 a blank screen appeared after right-clicking a row header in a grid
• Fixed an issue where labels were cut off in a Tornado chart
• Fixed an issue where collapsing an item in a grid did not work as expected when the query was using a parameter
• Fixed an issue where the Chart Total Labels ignored the culture settings of the underlying data source
• Implemented a new "Auto Fit Labels" formatting setting to offer improved customization options

Present

• Fixed an issue where clicking the Reset button did not remove the filter selection from a visual
• Fixed an issue where swapping an attribute with a hierarchy in a Present resulted in an error
• Fixed an issue where the context menu did not appear after right-clicking a grid when in full-screen mode
• Fixed an issue where an Illustration Tooltip that is based on a dynamic text, didn't update when the underlying discovery was filtered
• Fixed an issue where a filter kept working after the column it was based on was unselected in the model
• 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 users couldn't edit bookmarks if the content was accessed via a URL link
• 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
• Improved legend scaling
• Optimized loading time of presentations
• Fixed a situation where visuals within a slide were incorrectly filtered when the filters on the slide were disabled
• Fixed an issue where Pre Query Filters did not refresh the visual
• Fixed an issue where a "Not enough information" message appeared in a mini tab after manually switching mini tabs
• Fixed an issue where interactions appeared to be pointing to incorrect slicers when scrolling

Tabulate

• Fixed an issue where the browser tab froze after adding a Visual Area
• Fixed an issue where the browser froze after adding a new formula in a new sheet of an imported Excel
• Fixed a filter-related issue that was causing a failure in loading a Tabulate
• Fixed an issue where SLICERCAPTION in a tabulation showed an incorrect value in a present
• Fixed a save issue when a cell referenced a pyramid formula

Publish/Subscriptions

• Fixed an issue where a report with a dynamic date filter did not update as expected
• Fixed an issue where scheduled publications did not run intermittently
• Fixed an issue where publications and subscriptions didn't run after upgrading to 2023.01 until they were resaved
• Fixed an issue where a Schedule did not have the Add Link-back option under Output settings

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 formulations with member/parameter caption in the Dynamic Caption field had failed to run
• Fixed an issue where a formula didn't return the caption of a hierarchy current member
• Fixed an issue where the templates for the StrToMember() and StrToSet() functions in formulations based on OLAP cubes were incorrect
• Fixed an issue where CurrentMember() and other offset functions have failed for a Custom Column
• Improved performance of some formulations that use constant functions
• Fixed the issue with Number Formats templates displaying a single quote instead of double quotes when using an SQL data source
• 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 a blank screen occurred after opening a discovery from Favorites
• 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 exporting a discovery caused an RTE crash
• Fixed an issue where replacing a Model timed out and failed
• Improved layout of the "Delete Contentions on Shared Item" panel
• Fixed an issue where a Viewer user was able to access a folder but could not access its child folders
• Fixed an issue where folders appeared in a reversed alphabetical order

Printing/Export

• Fixed an issue where printing a Present with a measure parameter had failed
• Fixed a blank page issue when printing a present or publication that contained a tabulate
• Fixed an issue where legend colors were incorrect on a printed publication
• Fixed an issue where a measure list didn't print to CSV/EXCEL when in raw/tabular grid
• 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 a large grid that was exported to a PDF was not properly formatted
• 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 visual appeared blank in a PDF print of a publication
• Fixed an issue where a printable slicer that had all items selected showed a blank selection in the print

Admin

• Fixed an issue where Azure Blob Storage data sources did not appear in the Source Manager
• Fixed a geojson parsing issue which was causing custom maps imports to fail
• Fixed an issue where the Test button in the Add Data Source panel consistently displayed a Success message when utilizing "Service Account" as the Authentication Method
• Fixed an issue where SSH data sources did not show up in the Source Manager
• Added support for installation of optional features of a Python package
• 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 connecting to S3 storage
• Fixed an issue where a server statistics retrieval problem triggered an error message popup in the admin console
• Fixed an issue where a new conversation template lacked a functional link for the collaboration
• Fixed an issue where Security tables were not visible in the 'Member Security' tab under Source Manager within Model Settings
• Fixed an issue where the Server Instances screen was cut off in some resolutions
• Fixed an issue where the "Remove" button erroneously appeared when selecting an unrecognized database in the Databases tab under Data > Source Manager
• Fixed an issue where Additional Parameters were not sent properly on Snowflake connection
• Fixed an issue where additional parameters were ignored for AWS Athena connections
• Fixed an issue where Weka files didn't get deleted automatically
• Fixed an issue where connecting to an OLAP cube failed due to a Folder Overlay problem

Security

• Updates to various 3rd party libraries for vulnerabilities

API

• Fixed an issue where /API2/content/getFolderItems did not bring back deleted items

Mobile

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

Install/upgrade

• Fixed an issue which was causing the upgrade from 2020 to 2023.01 to fail
• Fixed an issue where adding services on upgrade, the added services did not start
• When deploying Kubernetes, the metrics server is now only accessible internally
• Fixed an issue where Python and R did not install on the AI server if other services were already installed

Login

• Improved login performance
• Fixed an issue that was causing the login process to fail

Other

• Online help updated
• Fixed an issue that was causing the client browser to crash after working in Pyramid for a while
• Fixed an issue that was causing PROM errors to appear in the system logs