This project is read-only.
Project Description
OLAP Tools for XMLA data source
* MDX Syntax, MDX DOM, MDX Parser, MDX Generator
* Pivot Table on HTML5, WPF, Silverlight
* Writeback supported
* Report server

Welcome to our new official web-site Galaktikasoft

Ranet Pivot Table HTML5 is available for download


You have the opportunity to see online-demos of the products:

Ranet UI 3.7 version will support HTML5, WPF and Silverlight client. WPF-based version implemented
Learn more Ranet OLAP 3.7 WPF+Silverlight
Ranet UI 3.5 and will contain all of the features are already well known to our customers as well as many different improvements. This is a general solution. We have the technology and skills of quick porting Silverligt projects on WPF.
HTML5-version uses a common core with WPF. It supports a full-featured pivot table for OLAP data sources.
The new version Ranet UI 3.7 has passed verification and validation in the our and the projects of our clients. Sungard, our key customer, uses at once three platforms in our Projects: Silverlight, WPF, HTML5. The other key customer Software4You porting your Silverlight App to a WPF-version.

Review Ranet Pivot Table. Key Features

This version has already used by our customers in England, Germany, France, USA, India, Brasil, Australia, South Africa, Chine, Estonia, Russia, Belarus.
The version Ranet OLAP 3.1 was localized for English, Portuguese, Italian, German, Spanish, French, Chinese, Polish, Czech, Russian, Belarusian and Ukrainian languages.

The source code version Ranet OLAP 2.5 is available for download on the website. The source code version Ranet OLAP 3.1 and 3.5 can be provided free of charge upon request.
New! Some new video samples are available on YouTube channel:

You can find the price list and buy Ranet OLAP here >>

What's new in Ranet OLAP 3.1:
  • MDX Designer saves state of PivotTable when adding a new Hierarchy
  • Toolkit Chart Integration:
  • Sparkline in Pivot Grid
  • Theme Support
RL Metro Dark.png

What is Ranet OLAP?

Components library Ranet.UILibrary.OLAP is intended for creating full-featured business intelligence applications (RIA, Rich Internet Applications) based on the Microsoft SQL Server Analysis Services platform.
Components library Ranet.UILibrary.OLAP is implemented based on the most resent Web-technologies: Microsoft .NET and Microsoft Silverlight.
It can be used for displaying data from Microsoft SQL Server Analysis Services 2005/2008 using most popular Web-browsers: Mozilla Firefox, Google Chrome, Internet Explorer.

Ranet OLAP Visual Controls List

  • PIVOT GRID - control shows a summary table which is a result of running the MDX query
    • Sorting - Ascending and Descending sorting can be applied to a row area, column area, or data area in the pivot grid table
    • Members group - grouping data in the row area and column area are in the pivot grid table
    • Show Properties - It can display the property of the dimension member in the table
    • Properties, Custom Properties - show properties of the dimension member or cell, and their current values, in a special window
    • DrillThrough - shows the detailed data used for calculating the indicator value for the cell, in a special window
    • Show MDX - displays the MDX query generated as a result of design, or prepared manually by the user, in a special window
    • Writeback - Editing cube data. See also Editing data in the pivot grid
  • MDX DESIGNER - control permits creating interactive reports based on Microsoft Analysis Services OLAP cube data
    • Customer Calculation Editor - a built-in Customer Calculations Editor permits the user to create calculated members and calculated sets on his own
    • Change Filter - to modify the filter, where a list of members included in the report is determined
  • MEMBER CHOICE - control serves for selecting one or a number of cube dimension members
    • Find tab - It is a visual element used to determine the search parameters
  • LEVEL CHOICE - control is used for selecting a level in the cube hierarchy.
  • MEASURE CHOICE - control is intended for selecting a cube measure, including selection within a specific measure group
  • KPI CHOICE - control is intended for selecting a Key Performance Indicator (KPI) for the cube
  • DATE PARAMETER - control is intended for selecting a date from a cube time dimension on a calendar form
  • KPI VIEWER - control shows Key Performance Indicators (KPI) defined in the cube, and their basic values at certain time
  • DATA ACTUALITY - Cube data relevance
  • SESSIONSTATE- Session state button

Welcome to Ranet.UILibrary.OLAP project

Visual elements that are included with the Ranet.UILibrary.OLAP library offer strong functionality and excellent design. This intuitive and easy-to-master tool does not require technical knowledge or programming skills from the user. It can meet business analysis requirements of the most demanding users.
Unlimited analytical possibilities offered by Ranet.UILibrary.OLAP library components enable the user to view the data from various angles. They help reveal business development trends that could have gone unnoticed or seemed of no importance.
The visual elements included with the Ranet.UILibrary.OLAP library permit to create interactive reports of any complexity level based on the data of the Microsoft Analysis Services OLAP cubes. Depending on the skill and professional level of the user, one can build an interactive report simply by dragging and dropping the cube metadata elements to the filter area, rows, columns of the summary table. Alternatively, it is possible to prepare a complex MDX query, using maximum capabilities of the MDX language, in order to achieve the most efficient solution for the report.

MDX Visual Designer overview

Learn more MDX Designer

The Drill Down, Drill Up, and Drill Through functions give the user the maximum possibilities for detailed data analysis:
  • Going into different data levels, from summary to detailed data (the hierarchy of the dimension determines the drill down ways);
  • Possibility to go down to the detailed data (Drill Down) by expanding the hierarchy nodes or going back to the summary data (Drill Up);
  • Analyzing the actual data behind the aggregate indicator (Drill Through);
Flexible filter configuration parameters permit data search and data filtering based on most diverse criteria. It is possible to combine criteria using AND and OR operators, various types of tests (like "contains", "equal to", "starts with") and measure or property values help to specify the search request.

Filter setup dialog

It is possible to save the configuration of reports and filters in the server rather than in the local user machine, to make them accessible from any non-office location at any time. It is possible to export or import the configurations from/to XML files, which is important as many users can use summary table configurations prepared by the experienced and skilled people. In other words, there is a path from personal use and analysis of information (as, for example, working with Microsoft Excel files) to shared use and analysis. And this promises additional business benefits.
The data export function to the Microsoft Excel format offers additional possibilities of qualitative analysis, including off-line analysis.
Access to the data in the summary table can be arranged based on access rights in the SQL Server Analysis Services. This would ensure high security level when working with data, based on the role of the user.
Features of the library provide good usability, ergonomic design and comfort in the reports: cell formatting based on the cube format settings (BackColor, ForeColor, etc.) and custom format settings, conditional font and image parameters depending on the cell values, the possibility to hide empty rows or columns, flip (rotate) axes, scale the tables, navigation through historical data.

Cell formatting in the Ranet Pivot Table
  • Use Back and Fore Color
  • Show Image
  • Show DataBar
  • Show Sparkline
For example:

Learn more Cell Styles Designer

Learn more PIVOT GRID

Library Ranet.UILibrary.OLAP includes components for visual building MDX queries, processing MDX queries, delivering the query results to the client, and showing them in the summary table and in other visual elements.
The use of Web-technologies in the design of corporate information systems reflects the modern approach to integration of data and applications. Library RanetUILibraryOLAP is implemented based on the most resent Web-technologies: Microsoft .NET and Microsoft Silverlight. It can be used for displaying data from Microsoft SQL Server Analysis Services 2005/2008/2008R2/2012 using most popular Web-browsers (Mozilla Firefox, Google Chrome, Internet Explorer).

Resources, Services, Contact Us

Go to Ranet.UILibrary.OLAP Online Demo
Login: demo
Password: demo
Installation Requirements: Silverlight 5.0
In the demo example, always use the latest version of the component. However, its source code is not available for download.

See also Galaktika BusinessMonitor
Galaktika BusinessMonitor is an integrated development enviroment (IDE) intended for building BI solutions using advanced Microsoft® tools - Silverlight 5 and SQL Server 2005/2008/2008R2/2012 (MSSQL, MSAS, MSRS). To satisfy needs in visualization of multidimentional data, we use RanetUILibraryOLAP

Before using please read Readme file:
Ranet.UILibrary.OLAP video tutorial:

Commercial license and technical support for this product is available.

See also Ranet OLAP Pivot Grid Video Course and pivot_grid_overview.pdf

Go to online demo

You can find the price list and buy Ranet OLAP here >>

Welcome to the group Ranet OLAP in LinkedIn!
Call or email at the information shown below:

US, Canada and EU
Galantis, Inc
3555 Harbor Gateway South, Suite B, Costa Mesa, CA 92626
Office: +1-206-420-3807
Fax: +1-206-420-3807
Cell: +1-714-408-3200
Ron Clevenger

FE Top Soft
Office: 375-17-294-9999, 375-17-294-9988, ext.1519
Cell: +375-29-770-2114
Anatoly Volodko

Last edited Jun 8, 2017 at 7:01 AM by Leschenok, version 273