Pivot Table & Charts Component Documentation

Connecting to Pentaho Mondrian

There are two ways to connect to Pentaho Mondrian using Flexmonster Pivot Table:

  1. via XMLA – an industry standard for data access in analytical systems
  2. via Flexmonster Accelerator – special server-side utility developed by Flexmonster

If you already have configured XMLA provider it will be preferable to start with option #1. In case you do not have XMLA or you need some advanced features (increase loading speed, use credentials, etc.) – option #2 is a better choice.

Connecting to Pentaho Mondrian via XMLA

XMLA (XML for Analysis) – an industry standard for data access in analytical systems, such as OLAP and Data Mining. Please follow the steps below to configure a connection to Pentaho Mondrian via XMLA.

Step 1: Embed the component into your web page

Embedding Flexmonster Pivot is simple copy-paste procedure that takes just minutes!

  1. Copy contents of component/ folder into the web project root to your server.
  2. Copy the code below and paste it into your HTML page.
    <div id="pivotContainer">The component will appear here</div> 
    <script src="flexmonster/flexmonster.js"></script>
            "flexmonster/", "pivotContainer", "100%", "500", 
            {   /* empty report */
                licenseKey: "XXXX-XXXX-XXXX-XXXX-XXXX"
            }, true

Run your web page and see the empty table. The next step is to see your own data on the grid.

Step 2: Configure XMLA access to the cube

If you have XMLA already configured please skip this step. Otherwise, please refer to the article that explains how to configure Mondrian as an XMLA provider.

Step 3: Enable cross-origin resource sharing (CORS)

By default, browser prevents JavaScript from making requests across domain boundaries. CORS allows web applications to make cross-domain requests. Please find instructions for common Java servers below:

Step 4: Configure report with your own data

Now it’s time to configure Flexmonster Pivot Component on the web page. Let’s create a minimal report for this (replace proxyUrl, dataSourceInfo, catalog and cube parameters with your specific values):

    "flexmonster/", "pivotContainer", "100%", "500", 
        dataSourceType: "mondrian",

        /* URL to XMLA provider */
        proxyUrl: "http://olap.flexmonster.com:8080/mondrian/xmla",

        /* Data source info */
        dataSourceInfo: "MondrianFoodMart",

        /* Catalog name */
        catalog: "FoodMart",

        /* Cube name */
        cube: "Sales",

        licenseKey: "XXXX-XXXX-XXXX-XXXX-XXXX"
    }, true

Launch the web page from browser — here you go! Pivot table is embedded into your project.

Connecting to Pentaho Mondrian via Flexmonster Accelerator

Everyone who has ever worked with multidimensional databases analysis has most probably faced the problem with finding a suitable component that not only performs all required functions but also executes them fast. Flexmonster solved this problem and created Flexmonster Accelerator for Pentaho Mondrian cubes – a special server-side proxy that helps you to increase data loading speed from server to customer’s browser.

Working with OLAP cubes, a browser component is communicating with the server via XMLA protocol. It’s no secret that the XMLA protocol is heavy and exchanges a lot of excessive information. Thus, it takes too much time and memory to load and process the data.

We replaced XMLA protocol and use direct requests from the Component to a server.

In this way, we have come up with solutions to two major problems that many of those who work with big data had faced to a different extent:

  • We made big data transfer from server to browser enormously fast. Our tool allows you to transfer large multidimensional data in super easy and fast way. Reporting becomes more enjoyable and prompt for your end users.
  • We greatly reduced the load on a browser memory.

Please refer to Getting started with Accelerator guide to find step-by-step instructions.

Suggest Edit