Browsing OLAP cubes

Question

Does 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.

score 8 · Accepted Answer · answered Dec 19 '08 at 03:50

8

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.

answered Dec 19 '08 at 03:50

Alex. S.

143,260
19
55
62

Hello I am currently developing a mobile app using react native and firebase. I was told to use some data cube to precompute the queries but I have no idea what is the data cube actually. Is it some sort of multi dimensional array which help you to sort the data? Can I use the suggested links to achieve what I wanted to do? – QWERTY Jul 29 '17 at 11:14

jjmontes · Answer 2 · 2013-10-19T19:59:46.747

6

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 :-))

edited Oct 19 '13 at 19:59

answered Oct 19 '13 at 19:34

jjmontes

24,679
4
39
51

Hey I am currently developing a mobile app using react native and firebase. I was told to precompute the queries using data cube but I have no idea what is it actually or where could I implement it. Do you mind to enlighten me on it? – QWERTY Jul 29 '17 at 11:17

xn. · Answer 3 · 2017-07-31T15:15:05.507

5

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

edited Jul 31 '17 at 15:15

answered May 04 '12 at 02:58

xn.

15,776
2
30
34

Hey I tried to run the jsbin example but there is nothing shown at the output. Is it still available for now? – QWERTY Jul 30 '17 at 02:22
@DeniseTan, I've fixed the jsbin – xn. Jul 31 '17 at 15:15
Thanks so much! But allow me to ask for a few questions as I am trying to understand what is the data cube actually. From the library, is the results precomputed or compute on the fly? Also, where did you get all the data from? Let's say I am fetching json from Firebase, is it still doable? Then, let's say I have raw json now, how do I actually form a cube? – QWERTY Aug 01 '17 at 03:00

score 2 · Answer 4 · answered May 06 '09 at 12:57

2

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/

answered May 06 '09 at 12:57

Codek

5,114
3
24
38

hey, nice tip... is there any online demo??? – opensas May 07 '09 at 03:04
demo.pentaho.com/pentaho has a demo of JPivot, but not yet PAT. – Codek May 11 '09 at 12:30
2

PAT has been renamed Saiku. Its homepage: http://www.analytical-labs.com/. Demo: http://demo.analytical-labs.com/ – incidentist Apr 07 '11 at 17:18

score 1 · Answer 5 · answered Oct 07 '09 at 16:50

1

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.

answered Oct 07 '09 at 16:50

score 1 · Answer 6 · answered Sep 28 '13 at 00:17

1

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

answered Sep 28 '13 at 00:17

Sean Zhao

1,506
12
12

Very impressive, it's not open source, but it's free for public sites... – opensas Mar 06 '14 at 02:07

score 1 · Answer 7 · answered Dec 19 '08 at 03:36

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.

score 0 · Answer 8 · edited Aug 10 '16 at 13:59

0

Ranet Olap component library has open version. Although it doesn't meet your requirement completely (require Silverlight), you should check it out.

edited Aug 10 '16 at 13:59

Petr Leschenok

33
4

answered Jun 18 '12 at 07:13

Tun

1,345
13
34

That link is dead. – analytik Jul 29 '16 at 11:58

score 0 · Answer 9 · answered Dec 19 '08 at 05:15

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.

Browsing OLAP cubes

9 Answers9