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…)
Pivot table is a popular feature many can find in Microsoft Excel and use to analyze interactively large mass of facts. The robustness of this analysis type allows many to extract trends and patterns that are located inside the data. Pivot table allows you to organize and summarize this information, focus only on the most relevant data and extract the most meaningful business analysis facts.
As the office software moved into cloud with Google Docs and similar applications, a global necessity of web applications that are capable to analyse OLAP cubes has risen. Our team has prepared our own short list on other available OLAP Data Mining and cross-tab reporting tools available currently on the market. (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:
- For Pentaho Analysis Services (Mondrian) - http://220.127.116.11:8080/mondrian/xmla
- For Microsoft SQL Analysis Services - http://18.104.22.168/olap/msmdpump.dll
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…)