Pyramid v2020

See your analytic data with perfect vision

V2020 Feature Listing & Notes

Pyramid v2020 is the latest release from Pyramid Analytics. Now your users can see more of their data, and do more than they ever thought possible. In total, Pyramid v2020 packs in over 150 new enterprise-grade features and capabilities to improve the way you make data-driven decisions. Please visit our release announcement to read about the headline features, or read our blog to understand the driving philosophy of this major release..

Feature Technical DetailsWhat It Means For You
Smart Discover
Watch Demo
New tool for auto-building reports based on user selections from data. AI drives the best visual choice and layout. The point-and-click tool makes it easy for non-technical users to create data visualizations and basic analytical methods without knowing how to use complicated tools and functions.
Discover Lite
Watch Demo
New lighter version of the data discovery tools for entry-level data analysts that exposes solid tools for report building and ad-hoc analytics without all the advanced options. Entry-level analysts can design reports and queries without training and the steeper learning curve of the full Discover application. It acts as a stepping stone to more advanced data analysis in the full Discover ("Pro") tool set.
Data Preparation & Workflow ToolsMajor upgrade in Data Model for stronger, more enhanced data flows that are in line with sophisticated data preparation routines, supporting multiple data flows, logic switching, loops, and notifications.Improvements in Data Model extend the range and functionality of the data flows and associated logic. This means more modeling scenarios can be addressed, coupled with auto notification of success or failure of processes and triggering of Pyramid events such as model and Publish schedules.
Accessible SAP ERP
Watch Demo
New deep support for SAP BW as a first-class data source to complement the deep support for SAP HANA and SAP IQ. Native interactive querying of SAP BW (legacy, “On-HANA” and “4/HANA”) InfoCubes and BEX queries via MDX with support for capabilities like: advanced querying options, proper totals, client-defined/BW-executed calculations and dynamic lists (sets); full numeric formatting; ragged hierarchies and alternative hierarchy captions; multiple user languages; and BW parameters, including key-dates. Coupled with the Pyramid’s superior performance and complete analytic suite of tools, the new SAP BW engine is poised to be best-in-class. Getting useful information efficiently from SAP systems has always been a struggle. SAP’s own tools are either old or under-developed—heavily stifling the breadth and depth of the reporting and analytics on SAP. Pyramid now allows you to fully leverage your investment in SAP ERP—together with all other data initiatives in the organization—bringing a fast, modern, enterprise-grade analytics solution to the challenges SAP customers face.
Machine Learning Version ManagementCreating Machine Learning (ML) scripts in Python often relies on specific versions of libraries. The Augmented ML Server allows you to define multiple virtual environments with specific versions of Python libraries for specific activities. Maintaining multiple virtual machines for Python version management provides standard environments for specific ML projects, simplifying and managing library versions to ensure flawless execution of shared Python scripts. As Python becomes the leading platform for building ML applications, business users need a framework to operationalize both the Python logic and execution for mass deployment. The new server engine allows you to use ML in a practical way to solve real-world business problems.

General Features

Feature Technical DetailsWhat It Means For You
User Avatars Users can now import custom images or photos to personalize their login ID, as well as add their phone number. Improves understanding of who is creating what and provides contact details for additional communication channels.
Upgraded Java Pyramid has moved its code base to Java 11, using the free OpenJDK package from Oracle. As well as keeping up to date with the latest functionality and performance improvements in the Java 11 release, utilizing the OpenJDK package means there is no requirement to pay license fees to Oracle for Java application use.
New Learning Center Welcome screen enhanced with built in “Learning Center” support. Options for Smart Reporting/Dashboarding exploits the new easy-to-use features. Simplified and extended mechanisms for getting started and learning Pyramid means faster time to productivity for new users.
New Languages Italian and Portuguese. Russian will also be available in the first service pack for 2020. New Languages make it easier for end users all persuasions to better understand how the software works and reach its numerous capabilities and functions.

Discover & Queries

Feature Technical DetailsWhat It Means For You
Multimedia Commentary Annotations and conversations can now be enhanced by attaching and uploading documents related to the thread. In addition, audio commentary may now be recorded and played back as part of the annotation. Qualitative support for the interpretation of quantitative analytics often relies on existing documentary evidence. The ability upload supporting documents and record quick voice narratives greatly enhances the shared understanding of analytic views.
SAP Hana and BW Parameters We added robust support for predefined SAP HANA and BW parameters when connecting to those models. Seamless integration with SAP analytic engines means direct access to models with predefined filters, giving users access to models as defined by the model developer.
OLAP-Like Multi-level Hierarchies on SQL data
Watch Demo
New OLAP-like hierarchies offer an expandable hierarchy structure on all supported relational data sources, including Big Data. Most users find expandable hierarchies easier to user for querying and ad hoc analysis. It's one of the best features in analytics that is missing from most other platforms for non-OLAP engines.
Dynamic Columns Adds calculated columns to the Pyramid Model against the underlying database schema. For example, for on-the-fly time intelligence calculations against date columns, or binning against numeric or categorical columns. The ability to extend database schemas dynamically adds powerful tools to the query engine, especially when dealing with Direct Query models. This extends the capability and end user-defined query solutions dramatically and allows further coverage of analytic scenarios without rebuilding the model.
Enhanced Visualizations The data visualization library has been further extended to include geo heat maps, upgraded KPI gauge styles, and flexible trellising options for multi-charts. New geo map and KPI gauge styles further enhance the extensive data visualization library, providing business users more choice on how to analyze their data.
Enhanced Grid Formatting Grids now include scrollable rows and upgraded column and row sizing. In addition, we added the ability to shrink rows and columns, size to fit all grid elements, and customize settings. Better control of grid formatting gives a clearer display of analytic results and content, leading to better understanding.
Slicer and Filter Performance Gains We added new server-side search capability, coupled with defined limits on the number of elements to add to a slicer or filter at initialization time. In addition, we added the ability to enable Tree-based slicers to be single select only. Limiting the initial element load and server-side searches means that slicers can be scaled almost indefinitely to millions of members. This improves the performance and the functionality in dashboards. A new single-select Tree slice extends the slicer scope and functionality.
Formatting of Non- Measure Custom Members Custom members in dimensions other than measures can now be numerically formatted, aligning SQL-based models to MDX-based models. Additionally, we provided new “solve order” options for SQL-based custom members to better organize mathematical operations Full control of formatting of calculated values means more accurate representations of values in grids and other visualizations—heavily simplifying the way data is digested by business analysts. Calculation ordering ensures mathematical steps are performed in the right order for multistage calculations.
Images in Headings and Filters
Watch Demo
We added support for including images in row and column headers as well as slicers and filters. Using images to identify items in row and column headers and filter elements can make identification and selection of elements easier and quicker.
Alternate Hierarchy Captions We now support alternate hierarchy captions for MS OLAP and SAP BW data sources Many hidden properties in OLAP hierarchies hide details that help business users navigate the data presented to them. Making them interchangeable, allows business users to tap into these hidden elements.
Quick Measure Variables Create variable lists based on selected measures to simplify the data visualization view and the end user experience. This new functionality provides a simple, quick approach to make data visualizations and analysis more dynamic.
Structure Analyzer to Track Changes to Content and Models Changing data models can impact existing reports, dashboards, and publications. The Structure Analyzer option allows you to check your content against changing models and correct mismatches or re-map existing content to the new data model structure through a simple wizard-based interface. This option has been further enhanced to help users manage updates to calculations defined in Pyramid. The cost of changing data model structures on existing analytic content (or changed model structures) can be underestimated, both in terms of content re-development and lost time. The Structure Analyzer minimizes the impact of data model changes, saving time and effort. The new capabilities extend deeper now to include all calculations.
Improved User Experience New user default settings allow you to control the single-click and double-click actions (as well as gestures on mobile devices) in the user interface. The user settings can be set as standard for all users, or on an individual basis. The end user experience is further enhanced with more control on how the business user interacts with Pyramid solutions.
Custom Visual Improvements Improved controls for custom visuals provide the ability to extend the data visualization library using 3rd-party libraries. Once added, the custom visual can be used by all Pyramid users. Improved drop zone configuration options simplify the creation of custom visuals. Data visualization enhances the data analytics process. The ability to create your own data visualizations using industry-standard libraries and add to the extensive Pyramid visual library means you have more control analyzing your data.
New PQL Functions A new set of PQL functions was added to support the new SQL regular hierarchies (“hierarchical semantic”) and advanced formulations in the cross-model interactions (“action common”). New functions allow advanced data analysts and BI developers to build smarter business logic and calculations to drive better analytics and better decisions.


Feature Technical DetailsWhat It Means For You
Remove Duplicate Records Provides a new data flow tool to identify and remove duplicate records in a dataset. Quicker, easier deduplication of data directly in the data flow with two clicks.
User-Defined Year and Week Advanced time intelligence options lets user specify Year Start, Date, and Week Start Day. This lets users customize how time intelligence fields are calculated for use cases such as fiscal years and weeks beginning on specified dates.
New Model Metadata Options New ability to add metadata descriptions to all data elements in the data modeling tools. Meta descriptions are critical to sharing the knowledge of what each data element corresponds to specific business users, dislocated from the data preparation process.
New Multi-Aggregation Tools A new properties panel for measures in the data model provides additional functionality, including Variance and Standard Deviation, to define how numeric items are aggregated. The ability to define additional aggregation functions in the data model means less calculations need to be created from a user perspective, providing faster access to analytic results.
Distribution Column Flags New option to flag a table and/or its columns as “distribution” only. These will hide the columns from end-users in normal queries, only exposing them when necessary to orchestrate automated distribution in the Publish tools. Being able to include distribution emails or phone numbers inside a data model heavily simplifies the process of orchestrating automated content distribution without confusing normal users in the standard querying tools.
New Data Sources and Support for Cloud Data Objects Pyramid now supports reading of data from AWS S3 Buckets, Azure Blobs, and Microsoft SharePoint lists. Write support has been added to Vertica. With enterprises moving to a "Data Lake" architecture for storage of data for analysis, Pyramid is ideally placed to provide analytics that require access to AWS and Azure data lake storage engines. Support for writing models to Vertica increases the range, flexibility, and user options for high-speed analytic data management. The ability to read and analyze data in SharePoint lists further increases the range of solutions Pyramid can provide.

Present & Publish

Feature Technical DetailsWhat It Means For You
Cross Model Interactions Filter values derived from one model may now be used to filter content from a second model via a “model mapping” capability. This maps the dimensions, attributes, and member names from one model to the other. Multiple maps across multiple models may be created using simple choices or complete PQL driven formulations. Many models have similar values, such as Time (Year, Month, Week, Date, etc.) and Geography (Country, State, Postcode, etc.), but different attribute names. Having one filter able to affect analytic content from different models by mapping the attribute and dimension names means more sophisticated dashboards that mash-up data from multiple data sets in the same screen—making the content richer for the end-user.
Cross Highlighting / Filtering Left clicking on a grid row, column, or a chart series item will initiate interactions on that item and directly filter the content in the other analytic content that is linked by an interaction. Quicker, simpler cross-filtering from one analytic object to another is a more natural way to work and creates productivity and clarity in the linked and filtered visualizations.
Dynamic Report Production Create new report triggers in a publication to control which report data view to output. Add page triggers and combine it with the pager repeater to control which pages are included in a publication. The new report and page trigger options include both simple and advanced rules engines to define the trigger conditions. Automate the creation of standard report packs and include advanced rules to deliver exception reporting. Deploy publications in various formats (PDF, Word, PPT, HTML, Excel, etc.) to Pyramid users and non-Pyramid users via email.
Remember Me Personalization Create centralized dashboards that are accessible by multiple users and allow each user to save their last filter settings. Rather than resetting the data filter values to the default value, the last-selected value is used when the user re-opens the dashboard again—personalizing the content. A personalized dashboard experience improves the overall user experience. Create a single standard dashboard that can be personalized per user. It’s simple to create and maintain—there is no need to create multiple versions of the same dashboard to cater to individual requirements.
Table of Contents A new dynamic text field called Table of Contents may be added to Presentations and Publications, auto-generating a contents table based on the use of headings. Additionally, a Total Pages system field allows creation of “Page No.” of “Total” values for page numbering. Autogenerating a table of contents makes creating structured documents and dashboards easier and quicker. By dynamically creating a table of contents means less work and faster development. The Total Pages system field gives more control of page number systems.
Enhanced Layout Options New tools are available for adding and arranging objects. Adding a text object, for example, allows you to draw a text box directly where it is needed at the right size. Easier and more flexible placement of objects allows faster development with improved ease of use.
Copy & Paste Slides and Pages Slides in Present and Pages in Publish can now be copied and pasted between different Presentations and Publications Reuse of existing content accelerates development and deployment of presentations and publications across your organization. (Interactions are maintained on presentations.)
Dynamic Distribution of Published Reports New capabilities allow published reports to be distributed to specific users or roles in the Bulletin Board, APIs and/or via email using flat Excel or CSV files or PQL/MDX queries executed against underlying data models. Being able to burst out static analytic content becomes significantly more powerful when you can specifically direct each rendered report (with its specific data sets and visualizations)—automatically—to different recipients based on distribution lists from uploaded files or data tables in your databases.
Analyze Further A new context menu option in live presentation dashboards called “Analyze Further” allows end-users to take any analytical visual and continue analyzing it using the new “Discover Lite” interface without exiting the dashboard runtime. “Analyze Further” allows curious users to continue analyzing reports and visualizations directly within the dashboard, deepening the analytic experience while simplifying access to tools.
Save My Discoveries Content opened in the new “Analyze Further” environment can be instantly saved as a new report for future use. This functionality is extended to both Pro and Viewer licensed users. With the ability to save new data discoveries from inside Discover Lite, “Analyze Further” brings the power of ad-hoc analysis to more non-technical users from directly inside presentation dashboards—making more in-depth data analysis accessible and functional.


Feature Technical DetailsWhat It Means For You
Faster Embedded Analytics We made performance improvements and reduced the embedded client footprint by 50 percent. Embedded Pyramid solutions now run even faster, with significant improvements in initial load time for large-scale applications.
Embedded Actions Pyramid Actions are now supported in embedded solutions. Full support for Pyramid Actions means additional functionality for embedded solutions, extending the range of solutions available.
Direct Dashboard Designer Option Gives embed developers a way to launch the presentation designer application for end users without going through the main interfaces of the full application. Embed developers can now launch the presentation designer application for end users without going through the main interfaces of the full application, greatly simplifying the mechanism for users to build their own content outside of the full client application.
Upgraded Discover Features Report Actions and report layouts are now fully available in embedded content to match presentation/dashboard layout options. Better layout options improve visual impact while report actions allow designers to build quick jumps to other content or websites that are context driven by the source data visualization.

Administrative / Backend

Feature Technical DetailsWhat It Means For You
Monitoring and Diagnostics New Administrator dashboard for the monitoring and diagnostics of the Pyramid installation. Better insight into the status and performance and usage of the Pyramid Server means administrators can tell at a glance where attention may be required, or view a single overview of the entire system.
Amazon RDS as Pyramid Repository Supporting Amazon RDS means the Pyramid Repository may be hosted in the cloud with support PostgreSQL, Oracle Database, and SQL Server instances. Support for Amazon RDS means greater flexibility in how Pyramid solutions may be deployed.
Enhanced Inter Process Communication & Data Security New hash security on all key operations in the application. Improved internal security features further hardens Pyramid against malicious attacks.
SMS Messaging Support Messages can now be sent and delivered using SMS texts. This can be used for alerts and notifications of scheduled events, such as successful completion of data flows and model builds. Further communication options widen the scope of Pyramid to deliver key messages and information to users wherever they may be.
Azure SSAS Tabular Support Pyramid can now connect to and analyze data stored in Azure SQL Server Analysis Services (SSAS) based models. Supporting Azure SSAS models further widens the scope of solutions that Pyramid can address.
Proxy Management New proxy setup and management tools for defining internal proxy servers for access to the internet by Pyramid Servers. Configuring Pyramid to work with internal proxy servers is now more straightforward and easier to manage.
25 New API methods 25 new API methods were added to the library to better help developers build applications with Pyramid. There is also a big increase in the number of deep examples offered in the API documentation. New APIs that will both expose and simplify programmatic operations needed by developers looking to automate numerous capabilities inside Pyramid.
Kerberos Security Manager Some data sources require Kerberos security support for server server-to-server communications, notably SAP HANA and Teradata. The new Kerberos Manager allows the configuration and management of Kerberos parameters for simplified connection to these data sources. Making sophisticated security setups easy alleviates the administrative burden of complex Kerberos security configurations, making data access easier and simpler.
Improved Materialized Content Management Upgraded materialized content manager for data sources, databases, and models. Making management of materialized databases, data sources, and models easier and simpler for administrators.


Pyramid v2020 Release Resources

Additional Resources

    • Webinar

    Pyramid v2020 Release Highlights (Oct. 3)

    Learn about the new features in Pyramid's latest release, Pyramid v2020.

    Read More
  • Introducing Pyramid v2020
    • Blog

    See your analytics with perfect vision

    With the latest release of Pyramid, analytics has become more accessible and more powerful.

    Read More