Named Set in JQuery PivotGrid widget

Named sets is a multidimensional expression (MDX) that returns a set of dimension members, that can be created by combining cube data, arithmetic operators, numbers, and functions.

Client mode

You can bind the named sets in the PivotGrid by setting it’s unique name in the fieldName property either in row or column axis and the isNamedSets boolean property to “true”.

  • js
  • <!--Create a tag which acts as a container for PivotGrid-->
     <div id="PivotGrid1" style="height: 350px; width: 100%; overflow: auto"></div>
    
    <script type="text/javascript">
        $(function() {
            $("#PivotGrid1").ejPivotGrid({
                dataSource: {
                    data: "https://bi.syncfusion.com/olap/msmdpump.dll", //data
                    catalog: "Adventure Works DW 2008 SE",
                    cube: "Adventure Works",
                    rows: [{
                        fieldName: "[Date].[Fiscal]"
                    }],
                    columns: [{
                        fieldName: "[Core Product Group]",
                        isNamedSets: true
                    }],
                    values: [{
                        measures: [{
                            fieldName: "[Measures].[Internet Sales Amount]",
                        }],
                        axis: "columns"
                    }]
                }
            });
        });
    </script>

    NamedSet in JavaScript pivot grid OLAP client mode

    Server mode

    You can add named sets in the PivotGrid by using NamedSetElement Class in the OlapReport.

  • c#
  • OlapReport olapReport = new OlapReport();
    olapReport.Name = "Customer Report";
    olapReport.CurrentCubeName = "Adventure Works";
    
    DimensionElement dimensionElementRow = new DimensionElement();
    dimensionElementRow.Name = "Date";
    dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
    
    MeasureElements measureElementColumn = new MeasureElements();
    measureElementColumn.Elements.Add(new MeasureElement {
    Name = "Internet Sales Amount"
    });
    
    NamedSetElement dimensionElementColumn = new NamedSetElement();
    dimensionElementColumn.Name = "Core Product Group";
    
    olapReport.CategoricalElements.Add(dimensionElementColumn);
    olapReport.CategoricalElements.Add(measureElementColumn);
    olapReport.SeriesElements.Add(dimensionElementRow);

    NamedSset in JavaScript pivot grid OLAP server mode