Canvas and D3 Charts

Canvas Canvas Questions
25

Hi @bknott,

Are those fix sets of cube data points? Meaning always look up for Jul current year to Jun next year?

If so, it might be easier with just the cellsetGet() function. That way, you do not need to worry about how to formulate the structure of the Cells (table size). You just need to construct dbrRequests object. Below is an example:

var dbrRequests = [];
		
var dbrRequest = {};
dbrRequest.instance = 'dev';
dbrRequest.cube = 'System Info';
dbrRequest.cubeElements = ['Current Date', 'Comment'];
dbrRequests.push(dbrRequest);
		

dbrRequest = {};
dbrRequest.instance = 'dev';
dbrRequest.cube = 'System Info';
dbrRequest.cubeElements = ['Logging Directory', 'Comment'];
dbrRequests.push(dbrRequest);
		
$tm1Ui.cellsetGet(dbrRequests).then(function(data){
	// get the Value property of each object returned and put the contents on the $data array here 
});

If you wanted to go via MDX route, you can also check if you can put most of your elements on the COLUMN axis and just one dimension on the ROW axis. That way, you can be sure that the Cells being returned is a flat list.

–
Paul