Pyramid Analytics

Pyramid 2023.10: Your Product Ideas Delivered

Pyramid 2023.10 introduces numerous customer-driven enhancements including visual tool-tips with dynamic mini dashboards, improved multi-select slicers, AI-assisted forecasting labels, advanced conditional formatting banding, enhanced SAP BW data handling, hierarchical sorting preservation, direct member color locking, slicer selection bookmarking, organized data source management, and enabled background chips for viewers, all aimed at improving data insight, usability, and user experience.

The following list enumerates all the new features implemented in Pyramid 2023.10. Over 80% are built off the product ideas on this forum or suggestions made by customers.

Click here to see the issues fixed in 2023.10.

Discover

  • Visual Tool-tips: Create new visual tool-tips using Discover visuals or mini Present dashboards that can be auto adjusted with the context from the primary visualization. The new Action option will replace the default built-in tool-tips. Provides users with enhanced insights into the data instantly with visual tool-tips and enables more informed decisions, quicker. Available in both Discover and Present.
  • Multi-Select option in slicers and lists: Improved capability to select multiple items in multi-select slicers using CTRL+click and SHIFT+click actions. Streamlines the user experience.
  • Forecasting Options + Dialog Update: Use of Gen-AI to auto-create the forecasting member labels that correspond to the member/s being forecasted. Easier to read forecasting results.
  • Banding Options for Steps in Conditional Formatting: New option to provide a specific color for the boundary between color bands, such as defining a color for zero in positive/negative conditional formatting.
  • SAP BW Key and Text Options: Option to show key, text, or both in columns for SAP BW sources. Enhances data organization and identification.
  • SAP BW Caption Changer: Allows changing SAP BW captions for hierarchy names.
  • Broken Hierarchical Sorting: New option to preserve sorting within hierarchy levels when using SQL data sources.
  • Improved Member Color Locking: Adjust the color directly from color locking dialog instead of formatting panel.
  • Bookmarking: Save multiple slicer selections in a Discovery for later viewing and continued exploration.
  • Improved Data Source listing experience: Group data sources into folders and sort by type or name.
  • Enabled background chips for Viewers: Viewers can access and remove background chips in Analyze Further, giving more flexibility.
  • Smart Insights added into Discover: One-click analysis and insight while working interactively with data.
  • Ribbon Updates: Reorganization/reordering of some ribbon elements within Discover for better accessibility.
  • Upgraded tool-tip UI: Homogenized all tool-tips in Discover for consistency.

Querying

  • Custom total functions per measure: Allows different totaling functions for each measure in the Discover totaling engine.
  • No totals for certain measures: Option to turn off totaling for specific Measures in a query.
  • Hierarchical treatment in Context Calculations: Incorporate hierarchical structures into the resolution of context calculations, including totals.
  • New Statistical Options: Select Standard Deviation Upper Bound, Lower Bound, or Both simultaneously in Advanced Query.
  • 21 new PQL Functions: Additional functions across granular, semantic, and common libraries.
  • Better control over non-metric query SQL generation: Switch between 'group-by' and 'distinct' style queries on queries without metrics by data model.

Visuals

  • Multi-line data labeling in certain visuals: Support for multi-line data labels within selected visuals for improved interpretation.
  • More control over Gauge Font Scaling: Option to turn responsive gauge font resizing off.
  • Value label option for grid indicators: Show alternative metric values as an indicator 'value'.
  • Upgraded legend alignment options: Includes horizontal and vertical alignment.
  • Chart title alignment and padding options: Display breadcrumbs as the chart title and improved alignment/padding.
  • Trellis axis alignment and padding options: Define horizontal or vertical orientation of a trellis axis title.
  • Data Shape Fill Options: Control the fill color of 'shapes' for relevant visuals.
  • Logarithmic Y-Axis Scales: Support for a Logarithmic scale for the Y-axis.

Content Manager

  • Conversation / Workflow upgrade to support interim thread emails: Email participants in a thread about every additional comment made.
  • Open Multiple files: Select multiple items in the content manager and open them as a group.
  • Content ID's added to all metadata tips: Content ID numbers added to numerous metadata elements throughout the app.

Present

  • Hide maximise Buttons: Option to hide the maximize button for presentations, giving designers more control.
  • Tool Tip Presentations: New Present design option for visual tooltips, optimized for purpose and size.

Formulate

  • Scripting Tool-tips and Item Click-through: See the metadata of items used in formulate scripts via hover tool-tip and CTRL+Click to open the item.
  • Improved Options for script interface: Change the font size and font style for the Formulate scripting tools.
  • Multi-lingual names and descriptions for all formulated objects: Multi-lingual support extended to all Formulate Objects.
  • Support for MSOLAP properties in List Builder: Enhancement to the Member List Builder to match against Member Properties in Analysis Services OLAP cubes.

Model

  • Added data flows widgets: JSON parser: JSON parser widget for data flows to untangle JSON blob data stored in database fields.
  • Added data flows widgets: Date-diff calculator: Widget for easier date calculations in data flows.
  • Added data flows widgets: Data Pivot: Node to pivot rows of data into columns for better table structures.
  • Data modeling option to resync model with database: Option to 'Sync Schema' of the semantic model to the related data source.
  • Added connectors for Dremio: Standardized connector for the Dremio data lakehouse management service.
  • Added connectors for Google GA4: Standardized connector for the new Google GA4 data service.
  • Added connectors for Box: Standardized connector for the Box cloud storage service.
  • Upgraded connectors for Twitter/X: Upgraded connector for Twitter/X social media platform metrics.
  • "Or" join operator: Create conditional joins using the 'OR' operator between tables in the Pyramid semantic model.
  • Upgraded options for file targets in data flow: New options available for file targets in data flow.