browsing olap cubes

Question

dows anybody know any fine open source cube browser???

ideally it would be something built with plain javascript...

does it even exists???

I'm planing to use it with classic asp agains a sql database...

thanks a lot

Answer 1

Adobe Flex includes a control you may be able use. You can use javascript as the language (Flex supports Actionscript natively, and javascript is a subset of Actionscrpt, and can be used as well.)

Here is a web page about the OLAPDataGrid control.

And here is another link.

Flex apps can be hosted in browsers with Flash installed.

Answer 2

You can look at Pentaho Mondrian (including JPivot), or at Eclipse BIRT

With these, you get some kind of flexible reporting tools on the most popular databases, and it includes functionality to browse OLAP cubes too.

Answer 3

if you can, find the sql server 2000 Resource Kit, inside there is a project that is a javascript cube browser. i am not sure of the licensing of this, but it is located at TOOLSANDSAMPLES\ANALYSISSERVICESTHINWEBCLIENT inside the Resource Kit. This resource kit should be available in msdn subscription downloads.

Answer 4

Also take a look at PAT, which is pentaho's replacement for JPivot. (Well actually being devloped by the community - not pentaho themselves!)

JPivot is a bit clunky although does the job. PAT is very new, so can't vouch for it's stability and features!

http://code.google.com/p/pentahoanalysistool/

Answer 5

You can look at pivot table component at flexmonster.com. It speak to olap cubes via xmla and unlike olapdatagrid does't need additional data preparation.