Get Free Trial


Flexmonster Pivot Table Component and Mondrian – an Alternative to JPivot

When it comes to cost-effective deployment of BI tool, Pentaho Analysis Services Community Edition (aka Mondrian) is one of the choices, selected by many analytics, developers and business owners. The Mondrian server enables users to load large quantities of data real-time and get insight with complex analytical queries. (more…)

Big Data Analysis with Pivot Tables

Today, rapid analysis of big data is crucial for efficient business decisions. By year 2015, according to Gartner research, the companies who have implemented fast big data management and analysis will begin to win over their unprepared competitors by 20% in every available financial metric that is critical to run their businesses. (more…)

Getting Flexmonster Pivot Table Connected to Traditional Databases

FlexMonster Pivot Table Component can connect traditional databases like MS SQL, MySQL, Oracle, PostgreSQL and others very similarly as it can get connected to OLAP servers. The main underlying concept is using a simple script in PHP, C# or practically any platform that would connect database, load the data and pass it to Pivot Table as CSV. (more…)

What’s new in Winter’12 Release v1.5: Improved Diagnostics for OLAP/XMLA Connectivity

Getting the Pivot Table connected to OLAP source is critical when you need demo to be up and running in minutes. The component is able to connect Microsoft® SQL Server Analysis Services® or Pentaho® Analysis Services (Mondrian) and now you can even verify the connectivity right from the tool. (more…)

New in Winter’12 Release v1.5: Visual Values Formatting

Pivot Table provides essential tools for formatting that are user-friendly and fully Excel-like. You can now make your data even more visible and robust with updated formatting API.

The updated formatting ability has now control over font size, font face, the text color and cell background color. (more…)

What’s new in Winter’12 Release v1.5: Calculated Values in Pivot Table

Calculated fields becomes an important instrument to visualize OLAP cube data as it is required by certain business task. Sometimes values are not stored in the format that would be best visible. (more…)

What’s new in Winter’12 Release v1.5: Conditional Formatting

Flexmonster is about to release a brand new version of the Pivot Table & Charts component, version 1.5. One of the features we are proud of is ability to apply conditional formatting, right as most users used to do in Microsoft Excel.

Conditional formatting empowers ability to focus even more on the trends and information that has to bring attention. (more…)

Compare Pivot Table and Chart Components for OLAP. Part 2

Welcome back! In this post we continue comparing Flexmonster Pivot Table & Charts component to current best offerings on the market. (more…)

Compare Pivot Table and Chart Components for OLAP. Part 1

In the previous post we gave a brief look over the short list of OLAP data visualization tools and components over the market. Today we will compare the most popular offerings on the market as well as evaluate them versus critical aspects for each business decision maker.

These we consider as important aspects for business intelligence facts analysis. The list also serves as a legend for our comparison table. (more…)

Troubleshooting OLAP/XMLA Connectivity

Today we will talk about common troubles when you try to connect to OLAP cube with Pivot Table & Charts component. Feel free also to use our SQL Analysis Services Diagnostics Tool to verify the connectivity.

I get a "Invalid datasource or catalog." error.

Please check back on the Catalog and Cube fields as one of them may be leading to the non-existing resource.

I get a "Error #2032" error.

You have to verify your XMLA-enabled OLAP cube server is up and responds fine. The easiest way is to first verify the server is available by http, so you may open the direct URL up in the browser:

  • For Pentaho Analysis Services (Mondrian) -
  • For Microsoft SQL Analysis Services -


Showcase: Connect Pivot Table and Chart Components to XMLA based OLAP Cube

With the Flexmonster pivot table component you can connect to Microsoft SQL Server Analysis Services (2005, 2008) or Pentaho Analysis Services (Mondrian) as well as any other business intelligence software that supports XMLA standard.
Follow these simple steps to get your Pivot connected to XMLA-based OLAP cube: (more…)