Flexmonster Demo - expand restoration
HTML
<script src="https://s3.amazonaws.com/flexmonster/2.2/flexmonster.js"></script>
<div id="pivot-content"></div>
JavaScript
var report = {
dataSource: {
dataSourceType: "microsoft analysis services",
proxyUrl: "http://olap.flexmonster.com/olap/msmdpump.dll",
dataSourceInfo: "WIN-IA9HPVD1RU5",
catalog: "Adventure Works DW Standard Edition",
cube: "Adventure Works",
binary: false
},
slice: {
rows: [
{
uniqueName: "[Geography].[Geography]",
levelName: "[Geography].[Geography].[State-Province]",
filter: {
members: [
"[Geography].[Geography].[City].&[Malabar]&[NSW]",
"[Geography].[Geography].[City].&[Lavender Bay]&[NSW]",
"[Geography].[Geography].[City].&[Matraville]&[NSW]",
"[Geography].[Geography].[City].&[Milsons Point]&[NSW]"
],
negation: true
},
sort: "asc"
},
{
uniqueName: "[Sales Channel].[Sales Channel]",
sort: "asc"
}
],
columns: [
{
uniqueName: "[Measures]"
}
],
measures: [
{
uniqueName: "[Measures].[Reseller Order Count]",
aggregation: "none",
active: true,
format: "29mvnel3"
}
],
expands: {
expandAll: false,
rows: [
{
tuple: [
"[Geography].[Geography].[City].&[Lane Cove]&[NSW]"
]
}
]
},
drills: {
drillAll: false,
rows: [
{
tuple: [
"[Geography].[Geography].[Country].&[Australia]"
]
},
{
tuple: [
...