Blog | Ranet OLAP
Using Pivot Tables in SQL Server

Using Pivot Tables in SQL Server

In order to have a thriving business, one needs to be able to quickly analyze available data and use it to make the right business decisions. If you collect your business data in an SQL database, the best way to analyze it is using SQL server pivot tables. What is a...
What If Analysis in Ranet OLAP Pivot Table

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

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

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...
Frontend Customization with Ranet HTML Pivot Table

Frontend Customization with Ranet HTML Pivot Table

In one of the previous blog posts, we wrote how Ranet OLAP HTML Pivot Table can be integrated into an ASP.NET application. Now, let's see how to customize pivot table's frontend. First of all, it is important to say that there are several ways to add the Pivot Table...