Feature Listing & Notes
Pyramid’s 2025 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.
Model
| Grouping | Feature Name | Description | Benefit | Reference | Help |
|---|---|---|---|---|---|
| Master Flows | Execute ad-hoc chains | Execute all downstream steps in a data flow pipeline from selected block | Simplifies debugging and testing of master flows in the model tool | Community | |
| Data Sources | Parquet file support as data source | Added Parquet File as a data source to directly read Parquet format data into a data flow. | Parquet files are becoming a standardized technique to capture and share data in a file structure | Community | Help |
| Data Sources | Tabulate as a datasource | Tabulate spreadsheets can be used as a data source in the data flow | New pathway to capturing end user data entry into a database, using Pyramid’s internal spreadsheet user interface. Can facilitate many other use cases that require bespoke data values. | Community | Help |
| Data Sources | Table Preview | New option to preview data from the tables list | Short cut to view data means less clicking and faster previewing. | ||
| Data Flows | LLM Switch | Ability to choose the LLM provider for each LLM widget used in data flows. | Different LLMs let users optimize function, performance and cost on a per case basis | Community | Help |
| Data Flows | Sort on Multiple Columns | New sorting options to sort multiple columns in the Sort Block. | Better sorting choices to keep data flows and prep faster, simpler and smarter | Community | Help |
| Data Flows | Filter on Multiple Columns | New filtering options to filter multiple columns in the Filter Block. | Better filtering choices to keep data flows and prep faster, simpler and smarter | Help | |
| Data Flows | Column Renaming | New ability to rename columns from the column selection panel for all operations | Easier, faster and simpler way to rename columns | Community | |
| Semantic Model | Column Search | New option to search for columns in the table relationship viewer | Simplifies and accelerates the semantic model design process especially when the column list in a table is very long | ||
| Semantic Model | Upgraded handling of “Diamond” Schemas | Improved handling of diamond-shaped semantic models | |||
| Smart modeling | Data Target Search | New option to search for data target in Smart Modeling | |||
Discover
| Grouping | Feature Name | Description | Benefits | Reference | Help |
|---|---|---|---|---|---|
| Alerts | New Smart Alerts | New option to create “smart alerts” using AI to auto-detect issues with changing values over time. | More sophisticated and flexible alerting without complexity. | Help | |
| Discover Lite | Bookmarks now available to Analyst users | Added support for use of Bookmarks by analyst users of Discover Lite. | Easy and quick way to access previously saved slicer options | Community | |
| Discover Lite | Direct URL generation for Analyst Users | Added ability for analyst users to generate and copy the object URL. | Allows Analysts to share URLs of Discover views to others | Community | |
| Discover Lite | Disable autorun | New option to disable autorun in discover Lite and Analyze Further. | Improves efficiency by delaying query execution when setting multiple slicers. | Community Community |
|
| Visuals | Layered Maps | New option to draw multiple, independent coordinates in a map using ‘layers’ | Adds greater flexibility to geospatial analytics, allowing for multiple locations to be consumed in a single map at the same time. | Community | Help |
| Visuals | Map Zoom Control | New option to limit the initial zoom effect of a map | |||
| Visuals | Totals Labels | For Stacked Column and Marimekko charts, new option to add Totals Labels. | Community | ||
| Visuals | Legend match Chart order | Adjusted the Legend generation to match the order and format of the chart. | Easier and more intuitive interpretation of chart information | Community | |
| Visuals | Roundness options | New roundness settings for numerous visualizations to create a more rounded look | Modern UI’s are making greater use of rounded graphical objects | Help | |
| Visuals | Copy / Paste Raw Data to Google Sheets | New support for copying and pasting raw data from Pyramid to Google sheets. | Faster and easier transfer of analytic data smooths and accelerates business processes. | Community | Help |
| Visuals | Upgraded Lasso in maps and other visuals | Added new support for freeform lasso plus other functionality in maps and scatter plots. | Extends analytic functionality of geospatial and measure to measure comparison presentation. | Community | |
| Visuals | Multiple column resizing in grids | New option to have resize columns affect multiple columns simultaneously. | Easier and more efficient grid formatting options speeds development | Community | |
| Insights | Fairness Analysis | New option to enable automated GenBI “fairness” analysis of reports. | Identifies any bias in analyses to enhance the trustworthiness of results | Help | |
| Chatbot | Next suggestion | New “next suggestion” by GenBI and LLM’s in the Chatbot. | Guides the user to explore additional analytic pathways for quicker delivery of insights. | Help | |
| Chatbot | Model suggestions | New “model suggestion” option from GenBI engines | Derives most asked question types for the type of data you analyze in the data model. | ||
| Chatbot | New Commands | Support for “print” and “save” commands from the Chatbot | Simplifies persistence of analytic output. | ||
| Analytics | Dimension folders for Dice, Swap and Add menus | New ability to display folder structure when selecting dimensions to Swap, Add or remove dimensions from Discover view. | More efficient display of deep or wide dimensions improves usability. | Community | Help |
| Analytics | Upgraded Sorting | New options for Pro sorting, including nested sorts and “soft by, then by” options. | New power-sorting choices to achieve the exact analytic outcome required | Community | Help |
| Analytics | Keeping Sorting Context | Improved sorting mechanics for keeping sorting context when using the SWAP menu | |||
| Analytics | Quick Sort Wizard | New quick sort wizard for access to “sort by, then by” capabilities | New sorting options exposed in this uncomplicated wizard to drive key power-sorting choices easily | Community | |
| Analytics | Upgraded Filtering | New options for Pro filtering | New power-filtering choices to achieve the exact analytic outcome required | Help | |
| Querying | BW Query Shard Option | New option to shard SAP BW queries for improved performance | Extracts improved performance for multi measure BW queries | Help | |
| Querying | Query Optimization | Upgraded sub-query and optimizer for SQL based data sources | Improves processing efficiency and performance of SQL based queries | ||
| PQL | New Granular PQL functions | DayOfYear, Trim, “in” functions | Adds functionality, flexibility and ease of use in creating more sophisticated calculations | Help | |
| PQL | New Semantic PQL functions | List: ThenBy, Empty Financial: IRR, XIRR, NPV, XNPV | Adds functionality, flexibility and ease of use in creating more sophisticated calculations | Help | |
| PQL | New Common PQL functions | DayOfYear | Adds functionality, flexibility and ease of use in creating more sophisticated calculations | Help | |
Formulate
| Grouping | Feature Name | Description | Benefits | Reference | Help |
|---|---|---|---|---|---|
| Context | Changing Attribute Context | New option to allow the changing of the Attribute context of existing calculations | More flexible saving options speed development of calculations. | Community | Help |
| Script | Calculation script formatting | AI engine to auto format calculation scripts | No effort formatting speeds development and aids maintenance tasks. | ||
| Governance | New Auto Descriptor | New button to auto generate formula descriptions using GenBI during save | No effort descriptions speeds analytic tasks by making existing content easier to find. | ||
Present
| Grouping | Feature Name | Description | Benefits | Reference | Help |
|---|---|---|---|---|---|
| Runtime | Delayed Slicer execution | New option to set slicer values and then manually execute. | Speeds querying when multiple slicer are present, | Community Community |
|
| Present Lite | Direct URL for Analysts | Added ability for analyst users to generate and copy the object URL. | Widens scope of Analyst actions. | Community | |
| Layout | Mini-Tabs in Scrollable panels | New option to allow use of Mini-Tabs inside scrollable panels | More flexible dashboard development | Community | Help |
| Mobile | Adjustable tile size for mobile | New ability to set the size of mobile client template frames. | Easier and more flexible formatting of mobile based apps accelerates development of mobile based solutions. | Community | |
| Visual Interactions | Upgraded Lasso in maps and other visuals | Added new support for freeform lasso plus other functionality in maps and scatter plots. | Extends analytic functionality of geospatial and measure to measure comparison presentation. | Community | |
| Insights | Custom insight settings per user | New option to set a user’s preferred slide insight settings in ‘user defaults’ | More user control of AI generated insights | ||
| Visual Prints | Print single visuals | New option to print a single visual in a presentation, rather than the entire slide. | |||
| Formatting | Shape Shadows | New option to give shapes in Present a shadow effect | |||
Publish
| Grouping | Feature Name | Description | Benefits | Reference | Help |
|---|---|---|---|---|---|
| Slicers | Single select calendar slicers | Calendar slicers can now be used with a Publication. | Extends the use and reuse of calendar based slicers to publications | Community | |
| Slicers | Single select Tree Slicers | Tree slicers can now be used with a Publication. | Extends the use and reuse of calendar based slicers to publications | ||
| Formatting | Shape Shadows | New option to give shapes in Publish a shadow effect | |||
Illustrate
Tabulate
| Grouping | Feature Name | Description | Benefits | Reference | Help |
|---|---|---|---|---|---|
| Query | Direct Query and Dynamic selections | New option to maintain link to Discover Query when dropped into Tabulate. Enables dynamic attribute changes in Tabulate | Increases scope and flexibility of Tabulate based solutions | ||
| Spreadsheet | Find & Replace | Added Find & Replace functionality | Better congruence with existing Excel functionality | Help | |
Embedding
| Grouping | Feature Name | Description | Benefits | Reference | Help |
|---|---|---|---|---|---|
| Admin + data | Data source “Xtender” | Support for a single model and set of reports to support multiple physical databases by tenant | Greatly simplifies the delivery of Tenant based solutions with shared content | Help | |
| Printing | Improved printing experience | Greater control of printing in the light embedding experience. | More functional printing in line with existing non embedded content | Community | |
| Search | Embedded Search | New option to directly build content from the embedded hub using the chatbot. | Freeform NLQ to generate and use new content delivers extremely powerful embedded solutions | ||
| UI | Styling | New options to change the styling themes of existing content while embedding. New options also include the ability to change the “global” styles of application UI elements as well. | More flexible formatting of content allows embed developers to match UI look and feel of host application. | Help | |
Admin
| Grouping | Feature Name | Description | Benefits | Reference | Help |
|---|---|---|---|---|---|
| Admin | Admin Hub Widgets | New admin tracker widgets for the hub: LLM token counter and cluster resources monitor | Improved monitoring of the Pyramid system | ||
| User Manager | Upgraded SSO providers | New mechanics to add users from Azure AD, Google, Okta and Ping IDPs | Extends auto provisioning to additional identity providers. | ||
| User Manager | Auto-provisioning | New auto-provisioning for Azure AD, Google, Okta and Ping IDPs | Streamlined authentication for multiple identity providers speeds administration of large projects | ||
| User Manager | Group Roles | New group role mechanics for Azure AD, Google, Okta and Ping IDPs | More integration with third party user management systems simplifies user administration. | Community Community |
|
| Web Services | Virtual Directory Deployments | New option to deploy Pyramid as a virtual directory of another main site. | Simplifies the setup of security tokens and cookies when using Pyramid as an embedded application. | Help | |
Content Management
| Grouping | Feature Name | Description | Benefits | Reference | Help |
|---|---|---|---|---|---|
| Content Manager | Save to Favorites | Folder Favorites available during the save process. | Fewer clicks to save and set favorites improves ease of use. | Community | |
| Content Manager | Upgraded Quick Open | New option to get a thumbnail preview through the quick open tools | Helps identify desired content in place. | Help | |
| Content Manager | Viewer CMS control | Greater control of content manager operations for Viewer | Widens the scope for viewers in management their access to content. | Community | |
| Content Manager | Control of Default Viewer experience | New option to control the initial view for viewers through ‘user defaults’ | Helps useability by setting the start point in the Pyramid platform for individual and solution requirements. | Community | |
Other Features
| Grouping | Feature Name | Description | Benefits | Reference | Help |
|---|---|---|---|---|---|
| Client UI | Upgraded Round UI | Major upgrade to the UI for a modern “rounded” look and feel for many components. | Allows Pyramid to assume more modern look and feel in line with familiar desktop applications. | ||
| Client UI | Section 508 Compliance | Numerous changes to the “light” UI to deliver greatly enhanced Section 508 compliance | Increases accessibility to the Pyramid platform. | ||
| API | New APIs | New API call to allow access and retrieval of IMDB database sizes. | Supports management of IMDB databases from third party or embedded applications | Community | Help |
| Security | Library Upgrades | Overhaul of numerous libraries to eliminate the latest vulnerabilities, including a change to Java 21 and Dot-Net 8. | Provides additional security for the Pyramid platform | ||
| Drivers | JDBC connector upgrades | Upgraded to latest versions of numerous JDBC connectors for the most popular data sources. | Allows Pyramid to connect to and exploit more recent third party database technologies. | ||
| Kubernetes | Upgraded Performance | Upgraded operation and performance of the containerized deployment of the platform in Kubernetes | Improves performance and efficiency of Pyramid when deployed through Kubernetes. | ||
| Documentation | Upgraded Help | Upgrades to help and guides | |||