XML for Analysis methods.
Sends a 'discover datasources' request, then performs callback.
Xmla.endpoint should be set before calling this function.
Sends a 'dbschema_catalogs' request, then performs callback.
Xmla.endpoint and Xmla.dsn should be set before calling this function.
Sends a 'dbschema_tables' request with catalog restriction, then performs callback.
Xmla.endpoint and Xmla.dsn should be set before calling this function.
Sends a 'dbschema_columns' request with catalog, schema and table restrictions, then performs callback.
Xmla.endpoint and Xmla.dsn should be set before calling this function.
Sends a query for execution.
Xmla.endpoint, Xmla.dsn and Xmla.query should be set before calling this function.
Converts data recieved from Xmla.discover into readable array. Example:
var callback = function(data); {
var arr = Xmla.discover_array(data);
alert(arr); // array of DSNs
}
Xmla.discover(callback);
Converts data recieved from Xmla.dbschema into readable array. Example:
var callback = function(data); {
var arr = Xmla.dbschema_array(data);
alert(arr); // array of catalogs
}
Xmla.dbschema(callback);
Converts data recieved from Xmla.tables into readable array. Example:
var callback = function(data); {
var arr = Xmla.tables_array(data);
alert(arr[0]); // array of table names
alert(arr[1]); // array of table schemas
}
Xmla.tables(callback);
Converts data recieved from Xmla.columns into readable array. Example:
var callback = function(data); {
var arr = Xmla.columns_array(data);
// arr is an array of objects
alert(arr[0].name); // name of first column
}
Xmla.columns(callback);
Converts data recieved from Xmla.execute into readable array. Example:
var callback = function(data); {
var arr = Xmla.execute_array(data);
var header = arr[0];
var data = arr[1];
alert(header.length); // count of columns in result
alert(data.length); // count of rows in result
}
Xmla.execute(callback);