Geek Answers Handbook

OLAP Data Presentation Package

I manage a very large data warehouse (> 1 TB) based on MS SQL 2005. I would like to create a solution for users to present data from cubes online (web interface). They are now using Office Web components, but that’s not so good. I have no control over the reports they create. I am googled and there are some solutions like Dundas or Analyzer.

Maybe someone has experience with these (or other) packages and can share their opinions? I have some basic requirements:

  • high performance and no unnecessary queries to the OLAP server
  • the ability to store reports (for example: users create filters, select date ranges and it should be able to store them)
  • ability to export to Excel
  • Some integrated graphics engines would be nice.

Some ideas?

+4
source share
3 answers

Devexpress has a really good PivotGrid, an OLAP data mining component that can be used in ASP.NET applications:

http://www.devexpress.com/Products/NET/Controls/ASP/Pivot_Grid/

and its analogue for Winforms applications:

http://www.devexpress.com/Products/NET/Controls/WinForms/Pivot_Grid/

RadarCube is also an ASP.NET component for representing OLAP data:

http://www.radar-soft.com/products/aspnet.aspx

And here's a complete list of potential OLAP presentation tools - not that I really know them, but you can take a look!

http://www.download32.com/net-olap-software.html

Mark

+2
source

Take a look at the JPivot that Pentaho Mondrian uses.

JPivot is an open source Java tag library for connecting to cubes, open through Mondrian (Java OLAP server) or through XML / A (which I assume is used by Microsoft Analysis Services).

The JPivot control is pretty comprehensive, although it can do a little facelift. I believe the new Pentaho Analysis Tool (PAT) project is under development as a replacement for JPivot. This uses the GWT to create a more convenient user interface ( http://wiki.pentaho.com/display/COM/Pentaho+Analysis+Tool ).

I use Pentaho Mondrian with JPivot to present my multidimensional data on my intranet. I am using a ROLAP schema running on SQL Server 2000. It works fine and also supports charting using JFreechart.

Mondrian Java OLAP Server - http://mondrian.pentaho.org/

JPivot http://jpivot.sourceforge.net/ - Screenshots http://jpivot.sourceforge.net/temp-N101F1.html

It might be worth taking a look at the Eclipse BIRT. I suppose this may support some kind of crosstab control, but I never tried.

+1
source

Do you use Sharepoint? You may have found that you are already covered by the PerformancePoint / ProClarity server / components due to a recent licensing restructuring announced by Microsoft.

0
source

More articles:


All Articles