Ranet OLAP Pivot Table | Galaktikasoft Ranet OLAP | GalaktikaSoft

Ranet OLAP

Rich functionality. High performance. Great adaptability.

Ranet OLAP Pivot Table ensures efficient work with multidimensional data.

Enjoy full power of online analytical processing for HTML5, WinForms and WPF applications.

Free Trial


Next-generation pivot table for OLAP data.
Built on HTML5, JavaScript, and AngularJS with Bootstrap support for responsive high-performance cross-platform applications


Excel-type pivot table for powerful WinForms and WPF desktop applications development.
Easy interface style creation using XAML, and high adaptability to other UI frameworks


Silverlight is leaving, very slowly but surely.
Ranet OLAP offers combined support for WPF and Silverlight platforms, and provides quick migration of Silverlight applications to WPF


Out-of-the-box functionality saves time

Thanks to the out-of-the-box features and the built-in user interface in Ranet OLAP, you can develop and deploy a complete BI-solution with interactive OLAP and data visualization features without writing a single line of code.

Interactive, drag-and-drop user interface accelerates discovery of data trends

No matter what business you are in, Ranet OLAP will allow your users to find new trends in their data. A single connection can generate tens of table variations with simple mouse clicks.

Drill Down/Up and Drill Through

The Drill Down, Drill Up, and Drill Through functions give the user the maximum possibilities for detailed data analysis.

Numerous ways to rank and sort data

With the built-in context menus in Ranet OLAP, users can sort their data in many different ways. They can sort and rank members in ascending or descending order, by caption, key or any field they select. When the user applies sorting to a field, a sort indicator displays on the field to remind them that a custom sort operation is set.

Powerful built-in data filters for fast analysis

Filtering data is an essential element of any data analysis experience. Ranet OLAP is built to ensure that every conceivable way to filter data is available by default with no configuration necessary. Simply place the control on a Silverlight form, add data, and your users are immediately able to begin drilling into their data and filtering results to show only the data that are most important to their analysis goals.

Export / Import settings, snapshots of data

Ranet OLAP features robust deployment architecture with no run-time royalties. You and your users can save and load various aspects of the view such as layouts and card configurations without ever recompiling the hosting application and at no extra costs.

Excel export allows to share analysis results

Allow your users to take the analysis they perform within your application and put it into a format that they can use. Excel exports allow them to perform additional analysis and what-if scenarios, and to share the results with people who do not have access to the data.

Easy-to-use User Interface

You can create a predefined report via configuration; define columns, rows, values, and filters to get exact data you need immediately after the Pivot Table is opened. You can easily rearrange fields and configure any report on UI using “Report Designer” area with drag-and-drop.

Conditional Formatting

Summary table Ranet OLAP allows you to display values based settings appearance of cells that are defined in the cube or MDX-query (FORMAT_STRING, BACK_COLOR, FORE_COLOR, FONT and so on). However, if necessary, the user can call the designer of cell styles and formatting to define the conditions according to their own needs. Style settings can be saved and loaded from the server when needed re-use.

Products Controls

MDX Designer

The MDX control creating interactive reports based on Microsoft Analysis Services cube data.

Pivot Grid

The Pivot Grid control shows a summary table which is a result of running the MDX query.

KPI Viewer

The KPI Viewer control shows Key Performance Indicators (KPI) defined in the cube, and their basic values at certain time.

Member choice

The Member Choice control serves for selecting one or a number of cube dimension elements.

Measure choice

This control is intended for selecting a cube measure.

KPI choice

Is intended for selecting a Key Performance Indicator for cube.


Optime uses Ranet OLAP for planning functionality in Optime3 product suite. Business planning is one of the most important management information functions, but lack of simple and reliable tools often complicates this process. Combination of Analysis Services MDX calculations flexibility and RANET MDX-based planning forms results in a highly configurable but still simple planning solution. Rein Parelo

Partner at Optime

We are using RANET OLAP as core of our 4PLAN Electric Eye. As part of the 4PLAN Controlling Solutions Family, 4PLAN Electric Eye performs ad hoc analysis with Microsoft Analysis Services. Its main focuses are flexibility, performance and ease of use. With RANET OLAP we found a user-friendly control to “drag-and-drop” high-performance MDX queries and grid-results with sophisticated pivot and drill-down functionality. Hanns-Dirk Brinkmann

General Manager, Software4You

Custom development and consulting services

Our development team has wide technical skills and experience in OLAP and BI solutions and custom made applications.

We can provide service at any or all phase of the product lifecycle, and can do so at very competitive cost.

Galaktikasoft custom solutions enable our customers to focus on their business with the assurance of a well-designed and fast to market OLAP and BI solution.

Our Clients

Have a question? Drop us a line

2 + 4 =