Pyramid 2020.20 Release Notes
Pyramid 2020.20, the latest release from Pyramid Analytics, introduces over 100 customer-requested features focused on enhancing Decision Intelligence, including advanced conditional formatting, automated root cause analysis with Explain, full Parent-Child hierarchy support, integration with SAP BW and Microsoft OLAP properties, customizable slicer defaults, a natural language Chat Bot in Discover, and improved control over labels, ordering, and subtotals in analytics reports.
Feature Listing & Notes
Pyramid 2020.20 is the latest release from Pyramid Analytics, bringing Decision Intelligence into focus. With over 100 new customer-requested features, this release is a significant step forward for organizations aiming to make Decision Intelligence a core part of their enterprise data strategy.
Analytics
- Conditional Formatting: Unified conditional formatting tools with a new advanced dialog editor, making it easier and more sophisticated to apply color-based highlighting to visuals.
- Explain: Automated key driver/root cause analysis for SQL-based data sources using a decision tree segment analysis engine, including new visualizations for results.
- Parent-Child Hierarchy Support: Full support for Parent-Child hierarchies in Pyramid models and SAP HANA Calculated Views, essential for financial, organizational, and geographic analytics.
- Support for SAP BW and Microsoft OLAP Properties: Ability to see and use hierarchy properties from Microsoft OLAP cubes or SAP BW InfoCubes as normal attributes, extending analytical power.
- Calendar and Tree Defaults: Set default values for Calendar and Tree Slicers, giving designers better control over report views.
- Chat Bot in Discover: Natural language Chat Bot tool now available in Discover, enabling plain English queries for non-technical users.
- Custom Labels for Forecasts and Totals: Users can configure labels for subtotals, totals, and forecast values for more accurate and shareable analysis.
- Custom Ordering of Measures: Extended custom ordering to measures and custom measures for easier metric arrangement in visuals.
- Customizable Sub-Totals: Select or deselect which attributes are used in Sub-Totals, reducing visual clutter.
- Hierarchy and Measure Overlays per Report: Set custom column and measure captions and formats per report, allowing tailored data presentation.
- Improved SAP/BW Parameters: Enhanced interface for SAP BW or HANA parameters, including calendar pickers and default value resolution.
- Microsoft Tabular "Show Details" Action: Support for "Show Details" in Microsoft Tabular models, expanding utility.
- New PQL Functions: Added HasChildren, HasDataPoint, and DefaultMember functions for more analytical flexibility.
- Non-Empty Handling in Slicers: Option to hide empty member elements in slicers without custom lists.
- Quick KPI Wizard: AI-driven wizard for rapid KPI creation via menu or dialog.
- Multi-Cross Highlighting: Allows multiple, cumulative selections for cross-highlighting in dashboards.
- New Data Source Connections: Native connectors for Neo4J, Databricks, and Apache Spark.
- Matrix Factorization Script: Python-based script for Netflix-style recommendations.
- Blank Member Names: Specify "Blank" member names for unknown elements in data models.
- Cumulative Aggregations: New aggregation type for cumulative calculations across date-time hierarchies.
- Data-driven Units and Currency Formatting: Dynamic formatting using column-based values, simplifying multi-currency data.
- Descriptions for Steps in Data Flow and Modeling: Improved metadata attachment for better data cataloging.
- Parent-Child Hierarchy Builder: Tool for defining and creating Parent-Child hierarchies in Pyramid Data Models.
- Upgraded WEKA Library: Enhanced machine learning capabilities and performance.
Usability and Efficiency
- Formatting Tools Redesign: New formatting panel and "Format Cursor" tool for easier visualization formatting.
- Copy Styles Between Reports: Copy formatting between Discover reports with a single click.
- Export to JSON and XML from Drill-through: Export drill-through results to JSON and XML formats.
- Grids with Wrapping Content: Word wrap option for grid visualizations, supporting longer text items.
- Member Color Locking: Lock color allocations for member elements across reports for consistency.
- Upgraded Total Dialogs: Streamlined dialogs for grid total settings.
- Parameter Builder Redesign: Unified creation of global and model parameters.
- Improved Access to Analyze Further: Analyze Further tool accessible even with blank queries.
- Interaction Tool in Present: Add and review interactions between dashboard elements more intuitively.
- Slicer "Detachment" Tool: Detach slicers from content in dashboards with a single click.
- Slicer Settings: Upgraded experience for changing slicer settings and options.
- Slicer Styles and Formatting: New "Modern" and "Clean" slicer styles and improved formatting interface.
- Slicer Actions: Trigger runtime actions based on slicer selections, enabling conditional display.
- Paste in Position: Paste content items in the same position across slides/pages.
- Excel Export Improvements: Enhanced formatting, layout, and color matching for Excel exports.
- Scheduler Date and Time Interface Upgrade: Improved UI for scheduling tools.
- Support for SAP BW in Schedules: SAP BW data sources supported in scheduled activities with Logon Ticket authentication.
- Data Flow Column Mapping Wizard: Manage mapped column flows between Data Flow nodes more easily.
- Data Catalog Get-and-Set Tool: Download/upload meta structure data catalog for models using JSON.
- Data Model-to-Database Checker: Tool for checking table joins and relationships in semantic models.
- Source Menu Split: Data sources menu in Data Flow categorized for easier navigation.
- Validate Joins Checker: Tool to check all table joins and relationships in a semantic model.
- Add/Edit/Remove Users in Conversations: Manage participants in conversations and workflows.
- Print and Subscription Dialog Redesign: Consistent and streamlined print/subscription dialogs.
- Upgraded "App Tab" Interface and Tools: Enhanced Pro-client App Tab interface with new features.
- Upgraded Content Search: Improved UI, new options, and faster search in content manager.
- Active Memory Statistics in Admin Dashboard: Monitor current memory consumption of each service.
- Terms of Use Link: Easy access to the latest EULA for admins.
- Upgraded Data Model Manager Interface: Improved UI for managing data models and related functions.
- Viewer Control of Filtering and Sorts: Viewers can remove filters/sorts in Discover reports.
- Favorites in Mobile App: Mark Discover reports or dashboards as favorites in the mobile app.
- New Application Languages: Added support for Simplified Chinese and Turkish.
- Updated Ribbons: All main ribbon menus upgraded with new icons.