Whats New in Ranet HTML Pivot Table 3.7.346 | Ranet OLAP
Release History

Ranet HTML Pivot Table 3.7.346

December 8, 2016


Pivot Table

  • When the area containing element attributes is enlarged the size of the window doesn't change

Pivot Table Designer

  • No opportunity to choose the dimension to drilldown by
  • When editing custom calculations, new elements are not automatically added in the calculations folder in the metadata tree
  • Reset command resets the settings without checking with the user
  • No opportunity to see initial MDX query generated according to report layout settings
  • Expression for non-empty is unavailable for editing after saving custom calculations settings
  • Bug applying percent format string to a new custom calculation
  • After changing a custom calculation (expression field), the pivot table is not update
  • Reset button executes the report when resets report settings
  • Text editor doesn't work correctly in custom calculation settings
  • Report settings are not synchronized with custom calculation settings

Excel Export

  • When the pivot table is exported to Excel the cell styles are not kept


  • Negative numbers with different amounts are shown the same on the chart
  • Fields in chart settings are not localized
  • The chart overlaps the axis when the column is changed from percent to sum

Storage Manager

  • The measure group selected by the user cannot be saved/restored

HTML General Tasks

  • When opening connection editor, an error appears in the browser log (in IE)

Pivot Table

  • If there is Sparkline value type in the cell and no cell style has been set up (regardless of the style), the value isn't shown anymore

Pivot Table Designer

  • When a new calculation is created, the cursor appears on this calculation on the list
  • A new command "Generate MDX query" resets the whole history and generates initial MDX query according to report layout settings
  • A new command "Reset MDX query transformation history" resets MDX query history of reports fields layout changes and pivot table drilldown
  • Folder and Name in custom calculations settings are stretched along the area width
  • The current option is highlighted in the drop-down menu


  • An opportunity to show values on an auxiliary axis in case values in the chart rows differ significantly
  • The user is informed if there is no drilldown opportunity on the heat map

Storage Manager

  • When deleting a report layout the user should be warned about it
  • Add an index to the report settings that would define the order in which they are sorted

This is an intermediate build Ranet OLAP Pivot Table for HTML, so we do not provide it for download from out website, but ship it to clients on demand. If you'd like to get this build please feel free to contact us.


What If Analysis in Ranet OLAP Pivot Table

Ranet OLAP Pivot Table allows users to not only analyze actual data for reporting, planning, and budgeting but also perform what-if analysis for studying different scenarios by changing values in the pivot table and seeing how they influence the cube data. This...

Integrating Ranet UI in a WinForms Application

Ranet UI 3.7 was developed for WPF and Silverlight frameworks but can also be used in Windows Forms applications. In this post, we will show how to integrate its components in a WinForms application as exemplified by integrating Dynamic Pivot Grid Control using Visual...

Overriding Ranet Pivot Table Backend Using API

Last week, we wrote how to configure the front-end of Ranet OLAP Pivot Table for HTML. Now, let’s talk about overriding the backend of the solution. Ranet OLAP Pivot Table provides API for working with the server code. WebApi controllers are an intermediate link...