☝️Small business or a startup? See if you qualify for our special offer.
+
List of all demos

Connect to MS Analysis Services

Flexmonster Pivot Table & Charts provides a seamless connection to Microsoft Analysis Services cubes.


    new Flexmonster({
      container: "#pivot-container",
      componentFolder: "https://cdn.flexmonster.com/",
      height: 600,
      toolbar: true,
      report: {
        dataSource: {
          type: "microsoft analysis services",
          proxyUrl: "https://olap.flexmonster.com:8085/",
          catalog: "Adventure Works DW Standard Edition",
          cube: "Adventure Works",
          binary: true,
        },
        slice: {
          rows: [
            {
              uniqueName: "[Product].[Product Categories]",
            },
          ],
          columns: [
            {
              uniqueName: "[Customer].[Country]",
            },
            {
              uniqueName: "[Date].[Month of Year]",
              caption: "Month",
            },
            {
              uniqueName: "[Measures]",
            },
          ],
          measures: [
            {
              uniqueName: "[Measures].[Internet Total Product Cost]",
              format: "currency"
            },
            {
              uniqueName: "[Measures].[Internet Average Sales Amount]",
              active: false,
              format: "currency"
            },
            {
              uniqueName: "[Measures].[Gross Profit]",
              active: false,
              format: "currency"
            },
          ],
          drills: {
            rows: [
              {
                tuple: ["[Product].[Product Categories].[Category].&[4]"],
              },
              {
                tuple: ["[Product].[Product Categories].[Subcategory].&[28]"],
              },
              {
                tuple: ["[Product].[Product Categories].[Subcategory].&[25]"],
              },
            ],
          },
          memberProperties: [
            {
              levelName: "[Product].[Product Categories].[Product]",
              properties: ["List Price", "Start Date"],
            },
          ],
        },
        options: {
          showMemberProperties: true,
        },
        formats: [
          {
            name: "",
            thousandsSeparator: ",",
            decimalSeparator: ".",
            decimalPlaces: 2,
          },
          {
            name: "currency",
            currencySymbol: "$",
          },
        ],
      },
      shareReportConnection: {
        url: "https://olap.flexmonster.com:9500",
      },
      beforetoolbarcreated: function (toolbar) {
        toolbar.showShareReportTab = true;
      },
    });
    
    <div id="pivot-container"></div>
    
    #fm-pivot-view .fm-grid-view div.fm-level-0.fm-cell,
    #fm-pivot-view .fm-grid-view div.fm-level-0.fm-cell.fm-total {
      background-color: #a7d6ae;
    }
    
    #fm-pivot-view .fm-grid-view div.fm-level-1.fm-cell,
    #fm-pivot-view .fm-grid-view div.fm-level-1.fm-cell.fm-header,
    #fm-pivot-view .fm-grid-view div.fm-level-1.fm-cell.fm-total {
      background-color: #bee8c5;
    }
    
    #fm-pivot-view .fm-grid-view div.fm-level-2.fm-cell,
    #fm-pivot-view .fm-grid-view div.fm-level-2.fm-cell.fm-header,
    #fm-pivot-view .fm-grid-view div.fm-level-2.fm-cell.fm-total {
      background-color: #e1f7e4;
    }
    
    #fm-pivot-view .fm-grid-layout .fm-grand-total {
      background-color: #f5f5f5 !important;
    }
    
    #fm-pivot-view .fm-grid-layout span.fm-hierarchy-link {
      color: #0d0d0d !important;
    }
    

    It is possible to connect to OLAP cubes either using the XMLA protocol or a much faster approach via Flexmonster Accelerator — a server-side proxy. Flexmonster JavaScript pivot grid works efficiently with both SSAS tabular and multidimensional models.

    To connect to Microsoft Analysis Services from the pivot table via XML for analysis, refer to the Connecting to Microsoft Analysis Services via XMLA guide.

    To learn how to connect to Microsoft Analysis Services or Azure Analysis Services with the highest performance, get straight to the Getting started with Flexmonster Accelerator guide.