Ranet OLAP Pivot Table for HTML5. How to start

Ranet Pivot Table for HTML5

System requirements

All software from the table below should be installed on the server where Ranet Pivot Table for HTML5 will be running.

EnvironmentRecommended Use

Operating systemAny version of Microsoft Windows
Platform and componentsMicrosoft .NET Framework v4
Web serverMicrosoft Internet Information Services 7.5
Web browserRecommended: Chrome 47
Alternative: Microsoft IE 11.0, Firefox 45, Opera 35, Edge 13, iOS Safari, Android Browser


Quick Start

This section describes the demo example that shows the abilities Ranet Pivot Table for HTML5. The demo example is a single page web application to be deployed on Microsoft IIS (Internet Information Services). No special skills are required to deploy the application manually. Just follow the steps below:

  1. Download the archive with the components of Ranet Pivot Table for HTML5;
  2. Use Windows Explorer to create an empty folder on the disc where the source of the IIS web app will be stored.
  3. Extract the archive into the folder created during the previous step.
  4. Open the IIS Manager console;
  5. Use the [Add Application…] command to add the application to the site. In the opened dialog window, set the following parameters:
    Element NameDescription

    AliasEnter the name that will be used to access the contents of the web app in the browser.
    Application PoolChoose the ASP.NET v4.0 Classic application pool in which the application will be running (if you created an own pool, choose it).
    Physical pathThe physical path to the application source. In the demo example, it is the path to the folder with the extracted archive.
  6. Run the web application by choosing the next options in the local menu: Manage Application -> Browse. The application starting page is index.html.
  7. After the web app has launched, specify the connection string to the OLAP MS SSAS data source. By default, the demo DB Adventure Works DW 2008R2 on the localhost server is used (the original base is stored in https://msftdbprodsamples.codeplex.com/).

This guide does not provide the detailed info on Windows, IIS, and SQL Server settings. If any issues appear, refer to the original documentation on those components.

The Pivot Table for HTML5 demo example provides the following features:

  • The opportunity of flexible report template customization (including compound filters);
  • The opportunity to create custom calculated values;
  • The opportunity to use different services (Drill Down/Up, Expand/Collapse, etc.) for data analysis in pivot tables.
  • The navigation history on pivot table data is stored while the user is working on the report;
  • Data export from pivot tables into Excel and XML files;
  • Creating unlimited amounts of pages in a single report;
  • The file storage for report parameters and special services to manage them.

The demo application has the complete functionality to create interactive analytical reports based on multidimensional OLAP data. This solution can be utilized for your data analysis purposes as an independent ready-to-use product. You can also easily integrate it into any web app as an Ad hoc Reports module for OLAP.

Ranet Pivot Table for HTML5

Ranet Pivot Table for HTML5

Write US