Browsing OLAP cubes [closed]

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.

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

It's mostly Javascript, backed up by Cubes OLAP server.

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

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

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}}]; // ... etcvar 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's an example I built using it along with backbone.js: http://jsbin.com/rejekij/edit?html,js,output