Version 0.0.0 Date 23.11.2014 Changelog, Release Plan

Alamdx - 'à la MDX' - is a light-weight JavaScript client-side MDX OLAP database library designed to work in browser and Node.js. It is an extension for Alasql database.

Alamdx realizes a subset of MDX (a language for multidimensional expressions) and designed for development of browser and mobile reporting and analytical applications, online analytical processing (OLAP), multidimensional analysis and work with aggregated data.

Works in progress...

    <script src="alasql.js"></script>
    <script src="alamdx.js"></script>
    <script>
    	// Prepare the data cube
    	alasql('create table sales (fruit string, country string, qty int)');
    	alasql('insert into sales values ("Apple","Argentina",1500)');
    	alasql('insert into sales values ("Apple","Mexica",1500)');
    	alasql('insert into sales values ("Melon","Argentina",250)');
    	alasql('insert into sales values ("Melon","Mexica",250)');
    	// Execute MDX statement
    	var res = alamdx('SELECT [Measures].[qty] ON COLUMNS, [fruit] ON ROWS FROM sales');
    </string>

	require(['alamdx'], function(alamdx) {
		var alasql = alamdx.alasql;
    	alasql('create table sales (fruit string, country string, qty int)');
    	alasql('insert into sales values ("Apple","Argentina",1500)');
    	var res = alamdx('SELECT [Measures].[qty] ON COLUMNS, [fruit] ON ROWS FROM sales');
	});

	var alamdx = require('alamdx');
	var alasql = alamdx.alasql;
	alasql('create table sales (fruit string, country string, qty int)');
	alasql('insert into sales values ("Apple","Argentina",1500)');
	var res = alamdx('SELECT [Measures].[qty] ON COLUMNS, [fruit] ON ROWS FROM sales');

• WITH {} SELECT {} ON COLUMNS, {} ON ROWS FROM cube WHERE slice
• Create cube
• Create dimension
• Create calculation

(c) 2014, Andrey Gershun MIT license information