Bug: ordering of hierarchy not respected - Less members
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>
<div id="pivot-container"></div>
JavaScript
new Flexmonster({
container: "#pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 550,
toolbar: true,
report: {
options: {
grid: {
type: "compact",
showGrandTotals: "none",
dragging: false,
},
configuratorActive: false,
configuratorButton: true,
fieldListPosition: "right",
defaultHierarchySortName: 'unsorted',
},
dataSource: {
type: "api",
url: pivotEndpoint,
index: "digitalperf:device-digitalperf-profile",
},
slice: {
columns: [
{
uniqueName: "[Measures]",
},
],
rows: [
{
uniqueName: "Date",
filter: {
members: ["date.[2020].[q1].[jan]"],
},
},
],
reportFilters: [],
measures: [
{
uniqueName: "Number of Products",
aggregation: "sum",
format: "wholeNumber",
},
],
expands: {
expandAll: true,
},
drills: {
drillAll: true,
},
},
},
});
function pivotEndpoint(request, successCallback, errorCallback) {
request = JSON.parse(request);
var result = null;
if (request.type == "handshake") {
result = { version: "2.8.22" };
} else if (request.type == "fields") {
result = getSchema(request.index);
} else if (request.type == "members") {
result = getMembers(
request.index,
request.field,
request.filter,
request.page
);
} else if (request.type == "select") {
result =...