Bug in hierarchy member
When there's a hierarchy on rows/columns and drillAll is active
by ezk84
HTML
<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<form id="controls" class="controls">
<label><input type="radio" value="ordered" name="type">Ordered</label>
<label><input type="radio" value="unordered" name="type" checked>Unordered</label>
<button onclick="pivot.clear(); pivot.setReport(report); return false">Run</button>
</form>
<div id="pivot-container"></div>
CSS
.controls {
padding: 10px;
}
button {
margin-left: 10px;
}
JavaScript
let report = {
"dataSource": {
"type": "api",
"url": pivotEndpoint
},
"slice": {
"rows": [{
"uniqueName": "Origin"
}],
"columns": [{
"uniqueName": "[Measures]"
}],
"measures": [{
"uniqueName": "Unique Visits Local",
"aggregation": "average"
}],
"drills": {
"drillAll": true
}
}
};
let pivot = new Flexmonster({
container: "#pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 550,
toolbar: true,
report: report
});
function pivotEndpoint(request, successCallback, errorCallback) {
request = JSON.parse(request);
var result = null;
switch (request.type) {
case "handshake":
result = {
"version": "2.8.22"
};
break;
case "fields":
result = getSchema(request.index);
break;
case "members":
result = getMembers(request.index, request.field, request.page);
break;
case "select":
console.log("value", document.forms.controls.elements.type.value);
if (document.forms.controls.elements.type.value == "unordered") {
result = getUnorderedSelectResult(request.index, request.query, request.page);
} else {
result = getOrderedSelectResult(request.index, request.query, request.page);
}
break;
}
successCallback(result);
}
function getSchema(index) {
return {
"aggregations": {
"any": ["count", "distinctcount"],
"date": null,
"number": null,
"string": null
},
"fields": [{
"uniqueName": "Origin Type",
"hierarchy": "Origin",
"type": "string"
}, {
"uniqueName": "Origin State",
"hierarchy": "Origin",
"parent": "Origin Type",
"type": "string"
}, {
"uniqueName": "Origin Name",
"hierarchy": "Origin",
"parent": "Origin State",
"type": "string"
}, {
"uniqueName": "Unique Visits Local",
"aggregations": ["average"],
"folder":...