Clever Geek Handbook

Viewing OLAP Cubes

Does anyone know of any excellent open source cube browser?

Ideally, it would be something built with plain javascript.

Does it even exist?

I am planning to use it with classic asp again in SQL database.

+12


source to share


9 replies


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



With their help, you get some kind of flexible reporting tools in the most popular databases, and also includes functions for viewing OLAP cubes.

+8


source


Ditch js-hypercube for a javascript-only OLAP library. The API is pretty simple. You can deserialize json into a cube object, query for dimension names, slice the cube and sum facts. From the doc:

var data = [{"time":1331773202,"facts":{"name":"Super Mario Bros. 2","platform":"Nintendo","staring":"Mario"},"measures":{"rentals":73,"sales":9,"revenue":359.91}}, {"time":1331841602,"facts":{"name":"Metroid","platform":"Nintendo","staring":"Samus"},"measures":{"rentals":43,"sales":6,"revenue":239.94}}]; // ... etc
var cube = ps.Cube.deserialize(data, ['rentals', 'sales', 'revenue'])
console.info('Total Rentals', cube.sum().rentals);
console.info('Revenue at 6pm for Super Nintendo games', '$' + cube.slice({hour: 18, platform: 'Super Nintendo'}).sum(2).revenue);
console.info('Avg rentals per hour for games staring Mario', cube.slice({staring: 'Mario'}).avg(24, 2).rentals + ' units');


Here is an example I built using it along with backbone.js: http://jsbin.com/rejekij/edit?html,js,output

+5


source


If you're looking for something lightweight, try CubesViewer to try:

This is mostly Javascript backed up by Cubes OLAP Server.

(Disclaimer, I'm the main developer :-))

+5


source


Also take a look at PAT, which is a pentaho replacement for JPivot. (Well, they were actually community created - not the pentahos themselves!)

JPivot is a bit clumsy, although it does the job. PAT is very new, so it cannot vouch for stability and features!

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

+2


source


Adobe Flex includes a control that you can 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 webpage about OLAPDataGrid .

And here 's another link .

Flex applications can be hosted in browsers with Flash installed.

+1


source


You can check out the pivot table component at flexmonster.com. It speaks to olap cubes via xmla and, unlike olapdatagrid, does not need additional data preparation.

+1


source


if you can find SQL Server 2000 Resource Kit, there is a project inside which is a javascript cube browser. I am not sure about the licensing of this, but it is in TOOLSANDSAMPLES \ ANALYSISSVERSVININWEBCLIENT inside the Resource Kit. This resource bundle should be available in the msdn subscription downloads.

0


source


The Ranet Olap component library is open source . While it doesn't fully meet your requirements (Silverlight is required), you should check it out.

0


source


WebPivotTable is a pure javascript pivot table and pivot chart component that can be used to create csv file and all kinds of OLAP cubes like Mondrian, SSAS, iccube. Here is the demo and documents .

0


source






More articles:


All Articles