Expand all issue with multilevel hierarchies issue in custom data source API
Data source
by ilaria_nunziante
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
var pivot = new Flexmonster({
container: "#pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 550,
toolbar: true,
report: {
dataSource: {
type: "api",
url: "https://olap.flexmonster.com:9500",
index: "fm-product-sales",
mapping: {
"Category": {
type: "level",
hierarchy: "Item"
},
"Business Type": {
type: "level",
hierarchy: "Item",
parent: "Category"
},
"Color": {
type: "level",
hierarchy: "Item",
parent: "Business Type"
}
}
},
slice: {
rows: [{
uniqueName: "Country"
}, {
uniqueName: "Destination",
filter: {
members: ["destination.[australia]",
"destination.[canada]"
]
}
}, {
uniqueName: "Size",
}, {
uniqueName: "[Measures]"
}],
columns: [{
uniqueName: "Item",
//levelName: "Business Type"
}],
measures: [{
uniqueName: "Price",
aggregation: "sum"
}]
}
}
});