Show all fields in the drill-through view

Data source

by Flexmonster Pivot Table

HTML

<script src="https://cdn.flexmonster.com/flexmonster.js"></script>

<div>
  <p>
    In this example, the
    <a
      target="_blank"
      href="https://www.flexmonster.com/api/options-object/#showallfieldsdrillthrough"
    >showAllFieldsDrillThrough</a> is set to <code>true</code>. As a result, the
    <a
      target="_blank"
      href="https://www.flexmonster.com/user-interface/#drill-through-view"
    >drill-through view</a> displays all available columns.
  </p>
  <p>
    This property works only with
    <a
      target="_blank"
      href="https://www.flexmonster.com/api/options-object/#showallfieldsdrillthrough"
    >Flexmonster Accelerator</a>.
  </p>
</div>

<div id="pivot-container"></div>

CSS

@import url(https://cdn.flexmonster.com/assets/jsfiddle-styles.css);

JavaScript

new Flexmonster({
  container: "#pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  width: "100%",
  height: 600,
  toolbar: true,
  report: {
    options: {
      showAllFieldsDrillThrough: true
    },
    dataSource: {
      type: "microsoft analysis services",
      // Flag to use the Accelerator instead of XMLA
      binary: true,
      // URL to Flexmonster Accelerator
      proxyUrl: "https://olap.flexmonster.com:8085/FlexmonsterProxy/",
      // Catalog name for multidimensional models
      // Database name for tabular models
      catalog: "Adventure Works DW Standard Edition",
      // Cube name for multidimensional models
      // Model name for tabular models
      cube: "Adventure Works"
    },
    slice: {
      rows: [
        { uniqueName: "[Geography].[Geography]" }
      ],
      columns: [
        {
          uniqueName: "[Product].[Category]"
        },
        {
          uniqueName: "[Measures]"
        }
      ],
      measures: [
        {
          uniqueName: "[Measures].[Reseller Order Count]"
        },
        {
          uniqueName: "[Measures].[Discount Amount]"
        }
      ],
      drills: {
        rows: [
          {
            tuple: [
              "[Geography].[Geography].[Country].&[Australia]"
            ]
          },
          {
            tuple: [
              "[Geography].[Geography].[Country].&[Canada]"
            ]
          }
        ]
      }
    }
  }
});