Feature
| Technical Details | What It Means For You
|
New Asymmetric and Ragged Queries
 Watch Demo
 Read Blog | Users can now eliminate combinations of elements and measures within reports. This results in an asymmetric or “ragged” query where specific combinations are excluded from both display and total calculations. | Complicated reports designs (and model selections) are now possible through a simple point and click menu that is not normally possible, or otherwise require complex coding. |
New Calendar Slicer
 Watch Demo
 Read Blog | The Calendar Slicer for SQL data sources allows date selections based on a calendar visual and allows multiple dates selections—both range- and formula-based (YTD, etc.)—without complex setups or code. Various date-time granularity
of dates may also be used (year, month, week, date, etc.) without first creating the columns in the data model. | Users can now quickly and powerfully filter reports and dashboards using a specialized date-time slicer. An intuitive front end enables quick and easy filtering using many combinations of date selection criteria without any setup or code.
|
New Data Catalog Viewer
 Blog Part 1
 Blog Part 2 | Pyramid now provides a printable document of the data catalog behind a data model with all details of its dimensions and measures. | Automatic self-maintaining documentation and data catalogs for data models in the system provide users with up-to-date documentation on the system—making their use and understanding clearer and more transparent. |
New Shape Drop Zone
 Watch Demo
| A new Shape drop zone has been created for graphs with data points—to differentiate data points using shapes (like color and size). | The use of shapes provides an additional visual cue for users to better understand visualizations and data. |
New Add and Swap menus to complement "Dice"
 Watch Demo
| New context menu options to “add” and “swap” hierarchies on the fly directly off visuals without using drop zones or the Analyze Further functionality. | Giving users even more control over the point-and-click process of changing queries greatly expands the self-service capabilities for even non-technical users to ask the next question and “surf” their data. |
Upgraded Quick Filters
 Watch Demo | Upgraded Quick Filters now include more options for filters (by limit, by statistic and by text) as well as new options for parameterized quick filters. | Powerful, yet easy to access new quick filter options greatly enhances flexibility while making it intuitive for non-technical users. |
New formatting options: background fill gradients & patterns, outline colors and settings.
| New abilities to customize the colors and fill options of all visualizations—including gradient colors, patterns, and stroke (outlines) | New options for formatting content can make visualizations both more attractive and easier to use for many users. |
New “Current Member” Logic
 Watch Demo
| The “current member” function allows calculations to access the current data point in a report. This enables BI developers to solve more complex analytic logic scenarios and include elements with logical relationships (like parent,
child, etc.)—greatly expanding the scope of calculated solutions. | This technical feature makes it both quicker and easier for analysts to create complex calculations like rolling averages and percentage-of-parent logic. |
Upgrade Advanced Filter Wizard | The full filter wizard has been extended to support statistic, numeric, and label filter functions. Statistic functions include average and standard deviation. Numeric functions include above, below, et cetera. Labels can be filtered by text
functions including contains, “start with” and “end with.” | Powerful new filter options for queries greatly enhances flexibility and extends the analyst’s ability to discover and analyze data. |
New Drag-and-Drop Background chips | Background chips now have the functionality of other drop-zone chips and can be dragged and dropped onto other drop zones. | By giving more objects the ability to have drag and drop capabilities, users will find it easier and quicker to manipulate reports and dashboards. |
New visuals: Lollipop chart & measure pie/donut charts | New lollipop charts and multi-measure Pie and Donut Charts have been added. | Enhanced graphic and formatting options provide more flexible and visually attractive graphs and charts. |
New “Blank” maps and map labels | A new map type offers a “blank” map to show just the relevant data shapes on a map. Also included are new options to hide and show mapping data labels. | Additional map capabilities extend map functionality by providing more ways to view geospatial information. |
New text parameters and “quick” parameters | The addition of free-text parameters enables users to dynamically apply free-text to filters. Users can also now add parameters directly within the most relevant functions using a “quick parameter” wizard. | Parameters can be used to drive powerful runtime changes to both the environment and queries. Text parameters allow free-text data entry while the quick parameter wizard greatly simplifies the process of adding and using them. |
Upgraded PQL functions: MTD, QTD, WTD, YTD, ParallelPeriod, Caption, AllMembers | These updated PQL functions can now be applied to regular hierarchies on SQL data sources as well as standard attributes. | New methods for creating sophisticated, hierarchical calculations make sophisticated analytics easier and quicker to create. |
New PQL functions: Cousin, Uniquename, Levels, Level, Ordinal, Ancestor, Rank, Loop, and LoopVector | New PQL functions to expand the options of creating and using both formulas and logic in the system. | New methods for creating sophisticated, calculations. |
Added support for Named Measure Sets | Extended capabilities for Microsoft Analysis Services, allowing the use of named measure sets. | This functionality continues to make Pyramid a first-class analytic front-end for Microsoft Multidimensional and Tabular models. |
SAP BW Info-areas and technical names | New options to show SAP BW Info Areas to better organize BW models and cubes. Separately, the ability to toggle BW hierarchy and measure technical names and captions. | SAP users are used to seeing their data models organized in Area trees and to see technical names that match the internal BW designs. These features will make it easier to find and identify content from within Pyramid. |
Upgraded handling of SAP BW/HANA parameters | Additional options for saving SAP BW and HANA parameters have been added. This includes report-specific settings. | The increased support for SAP BW and HANA continues to make Pyramid a first-class analytic front-end for SAP. |