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…)
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…)
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…)
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…)
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…)
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…)
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…)
Welcome back! In this post we continue comparing Flexmonster Pivot Table & Charts component to current best offerings on the market. (more…)
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…)
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.
Please check back on the Catalog and Cube fields as one of them may be leading to the non-existing resource.
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:
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…)