Ignite UI API Reference

Enables sorting of the header cells in columns.

 
        //Initialize
        $(".selector").igPivotGrid({
            allowHeaderColumnsSorting : true
        });
        
        //Get
        var allowHeaderColumnsSorting = $(".selector").igPivotGrid("option", "allowHeaderColumnsSorting");
        
        //Set
        $(".selector").igPivotGrid("option", "allowHeaderColumnsSorting", true);
      

Enables sorting of the header cells in rows.

 
        //Initialize
        $(".selector").igPivotGrid({
            allowHeaderRowsSorting : true
        });
        
        //Get
        var allowHeaderRowsSorting = $(".selector").igPivotGrid("option", "allowHeaderRowsSorting");
        
        //Set
        $(".selector").igPivotGrid("option", "allowHeaderRowsSorting", true);
      

Enables sorting of the value cells in columns.

 
        //Initialize
        $(".selector").igPivotGrid({
            allowSorting : true
        });
        
        //Get
        var allowSorting = $(".selector").igPivotGrid("option", "allowSorting");
        
        //Set
        $(".selector").igPivotGrid("option", "allowSorting", true);
      

The indentation for every level column when the compactColumnHeaders is set to true.

 
        //Initialize
        $(".selector").igPivotGrid({
            compactColumnHeaderIndentation : 20
        });
        
        //Get
        var indentation = $(".selector").igPivotGrid("option", "compactColumnHeaderIndentation");
        
        //Set
        $(".selector").igPivotGrid("option", "compactColumnHeaderIndentation", 20);
      

A boolean value indicating wheter the column headers should be arranged for compact header layout – each hieararchy is in a single row.

 
        //Initialize
        $(".selector").igPivotGrid({
            compactColumnHeaders : true
        });
        
        //Get
        var compactColumnHeaders = $(".selector").igPivotGrid("option", "compactColumnHeaders");
        
        //Set
        $(".selector").igPivotGrid("option", "compactColumnHeaders", true);
      

The indentation for every level row when the compactRowHeaders is set to true.

 
        //Initialize
        $(".selector").igPivotGrid({
            compactRowHeaderIndentation : 20
        });
        
        //Get
        var indentation = $(".selector").igPivotGrid("option", "compactRowHeaderIndentation");
        
        //Set
        $(".selector").igPivotGrid("option", "compactRowHeaderIndentation", 20);
    

A boolean value indicating wheter the row headers should be arranged for compact header layout – each hieararchy is in a single column.

 
        //Initialize
        $(".selector").igPivotGrid({
            compactRowHeaders : true
        });
        
        //Get
        var compactRowHeaders = $(".selector").igPivotGrid("option", "compactRowHeaders");
        
        //Set
        $(".selector").igPivotGrid("option", "compactRowHeaders", true);
      

A function that will be called to determine if an item can be moved in or dropped on an area of the pivot grid.
paramType="string" The location where the item will be moved - igPivotGrid, igPivotDataSelector, filters, rows, columns or measures.
paramType="string" The type of the item - Hierarchy, Measure or MeasureList.
paramType="string" The unique name of the item.
returnType="bool" The function must return true if the item should be accepted.

 
      //Initialize
        $(".selector").igPivotGrid({
            customMoveValidation : function(location, itemType, uniqueName) {
                // disable moving of any element to the columns
                if (location == 'columns') {
                    return false;
                }
                // if the current item is a hierarchy containing the word "Seller" in its uniqueName, disable the move
                if (itemType == 'Hierarchy'
                    && uniqueName.indexOf("Seller") !== -1) {
                    return false;
                }
                
                // in all other cases allow the move
                return true;
            }
        });
        
        //Get
        var customValidation = $(".selector").igPivotGrid("option", "customMoveValidation");
        
        //Set
        $(".selector").igPivotGrid("option", "customMoveValidation", validationFunc);
      

An instance of $.ig.OlapXmlaDataSource or $.ig.OlapFlatDataSource.

 
        //Initialize
        $(".selector").igPivotGrid({
            dataSource : ds
        });
        
        //Get
        var dataSource = $(".selector").igPivotGrid("option", "dataSource");
        
        //Set
        $(".selector").igPivotGrid("option", "dataSource", ds);
      

An object that will be used to create an instance of $.ig.OlapXmlaDataSource or $.ig.OlapFlatDataSource.
The provided value must contain an object with settings for one of the data source types - xmlaOptions or flatDataOptions.

 
        $("#pivotGrid").igPivotGrid({
            dataSourceOptions: {
                flatDataOptions:
                    {
                        dataSource:
                        [{ "ProductCategory": "Clothing", "UnitPrice": 12.81, "SellerName": "Stanley Brooker", "Country": "Bulgaria", "City": "Plovdiv", "Date": "01/01/2012", "UnitsSold": 282 },
                        { "ProductCategory": "Clothing", "UnitPrice": 49.57, "SellerName": "Elisa Longbottom", "Country": "US", "City": "New York", "Date": "01/05/2013", "UnitsSold": 296 },
                        { "ProductCategory": "Bikes", "UnitPrice": 3.56, "SellerName": "Lydia Burson", "Country": "Uruguay", "City": "Ciudad de la Costa", "Date": "01/06/2011", "UnitsSold": 68 },
                        { "ProductCategory": "Accessories", "UnitPrice": 85.58, "SellerName": "David Haley", "Country": "UK", "City": "London", "Date": "04/07/2012", "UnitsSold": 293 },
                        { "ProductCategory": "Components", "UnitPrice": 18.13, "SellerName": "John Smith", "Country": "Japan", "City": "Yokohama", "Date": "12/08/2012", "UnitsSold": 240 },
                        { "ProductCategory": "Clothing", "UnitPrice": 68.33, "SellerName": "Larry Lieb", "Country": "Uruguay", "City": "Ciudad de la Costa", "Date": "05/12/2011", "UnitsSold": 456 },
                        { "ProductCategory": "Components", "UnitPrice": 16.05, "SellerName": "Walter Pang", "Country": "Bulgaria", "City": "Sofia", "Date": "02/19/2013", "UnitsSold": 492 }],
                        metadata: {
                            cube: {
                                name: "Sales",
                                caption: "Sales",
                                measuresDimension: {
                                    caption: "Measures",
                                    measures: [ //for each measure, name and aggregator are required
                                        { caption: "UnitsSold", name: "UnitsSold", aggregator: $.ig.OlapUtilities.prototype.sumAggregator('UnitsSold') }]
                                },
                                dimensions: [ // for each dimension name and hierarchies are required
                                    {
                                        caption: "Seller", name: "Seller", hierarchies: [{
                                            caption: "Seller", name: "Seller", levels: [
                                                {
                                                    name: "AllSellers", caption: "All Sellers",
                                                    memberProvider: function (item) { return "All Sellers"; }
                                                },
                                                {
                                                    name: "SellerName", caption: "Seller",
                                                    memberProvider: function (item) { return item.SellerName; }
                                                }]
                                        }]
                                    },
                                    {
                                        caption: "Date", name: "Date", /*displayFolder: "Folder1\\Folder2",*/ hierarchies: [
                                            $.ig.OlapUtilities.prototype.getDateHierarchy(
                                                "Date", // the source property name
                                                ["year", "quarter", "month", "date"], // the date parts for which levels will be generated (optional)
                                                "Dates", // The name for the hierarchy (optional)
                                                "Date", // The caption for the hierarchy (optional)
                                                ["Year", "Quarter", "Month", "Day"], // the captions for the levels (optional)
                                                "AllPeriods") // the root level caption (optional)
                                        ]
                                    }
                                ]
                            }
                        }
                    },
                // Preload hiearhies for the rows, columns, filters and measures
                rows: "[Date].[Dates]",
                columns: "[Seller].[Seller]",
                measures: "[Measures].[UnitsSold]"
            }
        });
        
        //Get
        $(".selector").igPivotGrid("option", "dataSourceOptions");
        
        //Set
        $(".selector").igPivotGrid("option", "dataSourceOptions", dataOptions);
      

• columns

  Type:

  string

  Default:

  null

  A list of hierarchy names separated by comma (,). These will be the hierarchies in the columns of the data source.

• filters

  Type:

  string

  Default:

  null

  A list of hierarchy names separated by comma (,). These will be hierarchies in the filters of the data source.

• flatDataOptions

  Type:

  object

  Default:

  {}

  Settings for creating an instance of $.ig.OlapFlatDataSource.

  • dataSource

    Type:

    object

    Default:

    null

    Specifies any valid data source accepted by $.ig.DataSource, or an instance of an $.ig.DataSource itself.

  • dataSourceType

    Type:

    string

    Default:

    null

    Explicitly set data source type (such as "json"). Please refer to the documentation of $.ig.DataSource and its type property.

  • dataSourceUrl

    Type:

    string

    Default:

    null

    Specifies a remote URL accepted by $.ig.DataSource in order to request data from it.

  • metadata

    Type:

    object

    Default:

    {}

    Optional="false" An object containing processing instructions for the $.ig.DataSource data.

    • cube

      Type:

      object

      Default:

      {}

      Optional="false" Metadata used for the creation of the cube.

      • caption

        Type:

        string

        Default:

        null

        A caption for the cube.

      • dimensions

        Type:

        array

        Default:

        []

        Elements Type:

        object

        An array of dimension metadata objects.

        • caption

          Type:

          string

          Default:

          null

          A caption for the dimension.

        • hierarchies

          Type:

          array

          Default:

          []

          Elements Type:

          object

          An array of hierarchy metadata objects.

          • caption

            Type:

            string

            Default:

            null

            A caption for the hierarchy.

          • displayFolder

            Type:

            string

            Default:

            null

            The path to be used when displaying the hierarchy in the user interface.
            Nested folders are indicated by a backslash (\).
            The folder hierarchy will appear under parent dimension node.

          • levels

            Type:

            array

            Default:

            []

            Elements Type:

            object

            An array of level metadata objects.

            • caption

              Type:

              string

              Default:

              null

              A caption for the level.

            • memberProvider

              Type:

              function

              Default:

              null

              A function called for each item of the data source array when level members are created.
              Based on the item parameter the function should return a value that will form the $.ig.Member’s name and caption.

            • name

              Type:

              string

              Default:

              null

              Optional="false" A name for the level.
              The unique name of the level is formed using the following pattern:
              {<hierarchy.uniqueName>}.[<levelMetadata.name>].

          • name

            Type:

            string

            Default:

            null

            Optional="false" A name for the hierarchy.
            The unique name of the hierarchy is formed using the following pattern:
            [<parentDimension.name>].[<hierarchyMetadata.name>].

        • name

          Type:

          string

          Default:

          null

          Optional="false" A unique name for the dimension.

      • measuresDimension

        Type:

        object

        Default:

        {}

        An object providing information about the measures' root node.

        • caption

          Type:

          string

          Default:

          null

          A caption for the measures dimension.
          The default value is "Measures".

        • measures

          Type:

          array

          Default:

          []

          Elements Type:

          object

          An array of measure metadata objects.

          • aggregator

            Type:

            function

            Default:

            null

            Optional="false" An aggregator function called when each cell is evaluated.
            Returns a value for the cell. If the returned value is null, no cell will be created in for the data source result.

          • caption

            Type:

            string

            Default:

            null

            A caption for the measure.

          • displayFolder

            Type:

            string

            Default:

            null

            The path used when displaying the measure in the user interface. Nested folders are indicated by a backslash (\).

          • name

            Type:

            string

            Default:

            null

            Optional="false" A unique name for the measure.

        • name

          Type:

          string

          Default:

          null

          A unique name for the measures dimension.
          The default value is "Measures". This name is used to create the names of dimensions using the following pattern:
          [<measuresDimensionMetadata.name>].[<measureMetadata.name>].

      • name

        Type:

        string

        Default:

        null

        Optional="false" A unique name for the cube.

  • responseDataKey

    Type:

    string

    Default:

    null

    See $.ig.DataSource.
    string Specifies the name of the property in which data records are held if the response is wrapped.
    null Option is ignored.

  • responseDataType

    Type:

    string

    Default:

    null

    String Explicitly set data source type (such as "json"). Please refer to the documentation of $.ig.DataSource and its type property.
    null Option is ignored.

• measures

  Type:

  string

  Default:

  null

  A list of measure names separated by comma (,). These will be the measures of the data source.

• rows

  Type:

  string

  Default:

  null

  A list of hierarchy names separated by comma (,). These will be the hierarchies in the rows of the data source.

• xmlaOptions

  Type:

  object

  Default:

  {}

  Settings for creating an instance of $.ig.OlapXmlaDataSource.

  • catalog

    Type:

    string

    Default:

    null

    The catalog name.

  • cube

    Type:

    string

    Default:

    null

    The name of the cube in the data source.

  • discoverProperties

    Type:

    object

    Default:

    null

    Additional properties sent with every discover request.
    The object is treated as a key/value store where each property name is used as the key and the property value as the value.

  • enableResultCache

    Type:

    bool

    Default:

    true

    Enables/disables caching of the XMLA result object.

  • executeProperties

    Type:

    object

    Default:

    null

    Additional properties sent with every execute request.
    The object is treated as a key/value store where each property name is used as the key and the property value as the value.

  • mdxSettings

    Type:

    object

    Default:

    {}

    Optional="true" a javascript object containing information about how the request to the xmla server should be processed.

    • addCalculatedMembersOnColumns

      Type:

      bool

      Default:

      true

      Optional="true" a value indicating whether a members' set expressions on COLUMNS axis should be wrapped with AddCalculatedMembers MDX method. Default value is true.

    • addCalculatedMembersOnRows

      Type:

      bool

      Default:

      true

      Optional="true" a value indicating whether a members' set expressions on ROWS axis should be wrapped with AddCalculatedMembers MDX method. Default value is true.

    • dimensionPropertiesOnColumns

      Type:

      array

      Default:

      []

      Elements Type:

      object

      Optional="true" a string array with the names of intrinsic non-context sensitive member properties applied on COLUMNS axis. By defult CHILDREN_CARDINALITY and PARENT_UNIQUE_NAME properties are always added to DIMENSION PROPERTIES.

    • dimensionPropertiesOnRows

      Type:

      array

      Default:

      []

      Elements Type:

      object

      Optional="true" a string array with the names of intrinsic non-context sensitive member properties applied on ROWS axis. By defult CHILDREN_CARDINALITY and PARENT_UNIQUE_NAME properties are always added to DIMENSION PROPERTIES.

    • nonEmptyOnColumns

      Type:

      bool

      Default:

      true

      Optional="true" a value indicating whether a NON EMPTY clause is present on COLUMNS axis. Default value is true.

    • nonEmptyOnRows

      Type:

      bool

      Default:

      true

      Optional="true" a value indicating whether a NON EMPTY clause is present on ROWS axis. Default value is true.

  • measureGroup

    Type:

    string

    Default:

    null

    The name of the measure group in the data source.

  • requestOptions

    Type:

    object

    Default:

    {}

    An object containing information about how the request to the XMLA server should be processed.

    • beforeSend

      Type:

      function

      Default:

      null

      A callback to be invoked right before the request is send to the server. Extends beforeSend callback of jQuery.ajax’s options object.

    • withCredentials

      Type:

      bool

      Default:

      false

      The value is applied to XmlHttpRequest.withCredentials if supported by the user agent.
      Setting this property to true will allow IE8/IE9 to make authenticated cross-origin requests to tusted domains through XmlHttpRequest instead of XDomainRequest
      and will prompt the user for credentials.

  • serverUrl

    Type:

    string

    Default:

    null

    Optional="false" The URL of the XMLA server.

Specifies the width of the row headers.

 
        //Initialize
        $(".selector").igPivotGrid({
            defaultRowHeaderWidth : 180
        });
        
        //Get
        var defaultRowHeaderWidth = $(".selector").igPivotGrid("option", "defaultRowHeaderWidth");
        
        //Set
        $(".selector").igPivotGrid("option", "defaultRowHeaderWidth", 180);
      

Setting deferUpdate to true will not apply changes to the data source until the updateGrid method is called.

 
        //Initialize
        $(".selector").igPivotGrid({
            deferUpdate : true
        });
        
        //Get
        var deferUpdate = $(".selector").igPivotGrid("option", "deferUpdate");
        
        //Set
        $(".selector").igPivotGrid("option", "deferUpdate", true);
      

Disable the drag and drop for the columns drop area and the ability to use filtering and remove items from it.

 
        //Initialize
        $('.selector').igPivotGrid({
             disableColumnsDropArea : true
        });
        
        //Get
        var disableColumnsDropArea = $(".selector").igPivotGrid("option", "disableColumnsDropArea");
        
        //Set
        $(".selector").igPivotGrid("option", "disableColumnsDropArea", true);
        

Disable the drag and drop for the filters drop area and the ability to use filtering and remove items from it.

 
        //Initialize
        $('.selector').igPivotGrid({
             disableFiltersDropArea : true
        });
        
        //Get
        var disableFiltersDropArea = $(".selector").igPivotGrid("option", "disableFiltersDropArea");
        
        //Set
        $(".selector").igPivotGrid("option", "disableFiltersDropArea", true);
      

Disable the drag and drop for the measures drop area and the ability to use filtering and remove items from it.

 
        //Initialize
        $('.selector').igPivotGrid({
             disableMeasuresDropArea : true
        });
        
        //Get
        var disableMeasuresDropArea = $(".selector").igPivotGrid("option", "disableMeasuresDropArea");
        
        //Set
        $(".selector").igPivotGrid("option", "disableMeasuresDropArea", true);
      

Disable the drag and drop for the rows drop area and the ability to use filtering and remove items from it.

 
        //Initialize
        $('.selector').igPivotGrid({
             disableRowsDropArea : true
        });
        
        //Get
        var disableRowsDropArea = $(".selector").igPivotGrid("option", "disableRowsDropArea");
        
        //Set
        $(".selector").igPivotGrid("option", "disableRowsDropArea", true);
      

Settings for the drag and drop functionality of the igPivotGrid.

 
        //Initialize
        $(".selector").igPivotGrid({
            dragAndDropSettings : {
                appendTo : $("element"),
                containment : true,
                zIndex : 10
            }
        });
        
        //Get
        var dragAndDropSettings = $(".selector").igPivotGrid("option", "dragAndDropSettings");
        
        //Set
        $(".selector").igPivotGrid("option", "dragAndDropSettings", settings );
      

• appendTo

  Type:

  enumeration

  Default:

  body

  Which element the draggable helper should be appended to while dragging.

• containment

  Type:

  enumeration

  Default:

  false

  Specifies the containment for the drag helper. The area inside of which the helper is contained would be scrollable while dragging.

• zIndex

  Type:

  number

  Default:

  10

  Specifies z-index that would be set for the drag helper.

Specifies the parent for the drop downs.

Spefies the default sort direction for the levels if no sort direction is specified in an item from the levelSortDirections option.

 
        //Initialize
        $('.selector').igPivotGrid({
             firstLevelSortDirection : "descending"
        });
        
        //Get
        var firstLevelSortDirection = $(".selector").igPivotGrid("option", "firstLevelSortDirection");
        
        //Set
        $(".selector").igPivotGrid("option", "firstLevelSortDirection", "descending");
      

Spefies the default sort direction for the rows.

 
        //Initialize
        $('.selector').igPivotGrid({
             firstSortDirection : "descending"
        });
        
        //Get
        var firstSortDirection = $(".selector").igPivotGrid("option", "firstSortDirection");
        
        //Set
        $(".selector").igPivotGrid("option", "firstSortDirection", "descending");
      

Options specific to the igGrid that will render the pivot grid view.

 
        //Initialize
        $(".selector").igPivotGrid({
            gridOptions : {
                alternateRowStyles: true,
                caption: "My pivot grid",
                defaultColumnWidth: 150,
                enableHoverStyles: true
            }
        });
        
        //Get
        var gridOptions = $(".selector").igPivotGrid("option", "gridOptions");
        
        //Set
        $(".selector").igPivotGrid("option", "gridOptions", options );
      

• alternateRowStyles

  Type:

  bool

  Default:

  true

  Enables/disables rendering of alternating row styles (odd and even rows receive different styling). Note that if a custom jQuery template is set, this has no effect and CSS for the row should be adjusted manually in the template contents.

• caption

  Type:

  string

  Default:

  null

  Caption text that will be shown above the pivot grid header.

• defaultColumnWidth

  Type:

  enumeration

  Default:

  null

  Default column width that will be set for all columns.

  Members

  • string
  • The default column width can be set in pixels (px).
  • number
  • The default column width can be set as a number.

• enableHoverStyles

  Type:

  bool

  Default:

  false

  Enables/disables rendering of ui-state-hover classes when the mouse is over a record. This can be useful in templating scenarios, for example, where we don't want to apply hover styling to templated content.

• features

  Type:

  object

  Default:

  []

  A list of grid features definitions. The supported features are Resizing and Tooltips. Each feature goes with its separate options that are documented for the feature accordingly.

  Code Sample

   
          //Initialize
          $(".selector").igPivotGrid({
              gridOptions : {
                  alternateRowStyles: true,
                  caption: "My pivot grid",
                  defaultColumnWidth: 150,
                  enableHoverStyles: true,
                  features: [
                      {
                        name: "Tooltips",
                        visibility: "always"
                      },
                      {
                        name: "Resizing",
                        deferredResizing: false,
                        allowDoubleClickToResize: true
                      }
                  ]
              }
          });
            

• fixedHeaders

  Type:

  bool

  Default:

  true

  Headers will be fixed if this option is set to true, and only the grid data will be scrollable.

  Code Sample

   
          //Initialize
          $('.selector').igPivotGrid({
               fixedHeaders : true
          });
          
          //Get
          var fixedHeaders = $(".selector").igPivotGrid("option", "fixedHeaders");
          
          //Set
          $(".selector").igPivotGrid("option", "fixedHeaders", true);
          

• tabIndex

  Type:

  number

  Default:

  0

  Initial tabIndex attribute that will be set on the container element.

  Code Sample

   
          //Initialize
          $('.selector').igPivotGrid({
               tabIndex : 1
          });
          
          //Get
          var tabIndex = $(".selector").igPivotGrid("option", "tabIndex");
          
          //Set
          $(".selector").igPivotGrid("option", "tabIndex", 1);
            

This is the total height of the grid.

 
      //Initialize
      $('.selector').igPivotGrid({
            height : "600px"
      });
        
      //Get
      $(".selector").igPivotGrid("option", "height");
        
      //Set
      $(".selector").igPivotGrid("option", "height", "600px");
      

Hide the columns drop area.

 
        //Initialize
        $('.selector').igPivotGrid({
             hideColumnsDropArea : true
        });
        
        //Get
        var hideColumnsDropArea = $(".selector").igPivotGrid("option", "hideColumnsDropArea");
        
        //Set
        $(".selector").igPivotGrid("option", "hideColumnsDropArea", true);
      

Hide the filters drop area.

 
        //Initialize
        $('.selector').igPivotGrid({
             hideFiltersDropArea : true
        });
        
        //Get
        var hideFiltersDropArea = $(".selector").igPivotGrid("option", "hideFiltersDropArea");
        
        //Set
        $(".selector").igPivotGrid("option", "hideFiltersDropArea", true);
      

Hide the measures drop area.

 
        //Initialize
        $('.selector').igPivotGrid({
             hideMeasuresDropArea : true
        });
        
        //Get
        var hideMeasuresDropArea = $(".selector").igPivotGrid("option", "hideMeasuresDropArea");
        
        //Set
        $(".selector").igPivotGrid("option", "hideMeasuresDropArea", true);
      

Hide the rows drop area.

 
        //Initialize
        $('.selector').igPivotGrid({
             hideRowsDropArea : true
        });
        
        //Get
        var hideRowsDropArea = $(".selector").igPivotGrid("option", "hideRowsDropArea");
        
        //Set
        $(".selector").igPivotGrid("option", "hideRowsDropArea", true);
      

A boolean value indicating whether a parent in the columns is in front of its children.
If set to true, the query set sorts members in a level in their natural order - child members immediately follow their parent members.
If set to false the query set sorts the members in a level using a post-natural order. In other words, child members precede their parents.

 
        //Initialize
        $('.selector').igPivotGrid({
             isParentInFrontForColumns : true
        });
        
        //Get
        var isParentInFrontForColumns = $(".selector").igPivotGrid("option", "isParentInFrontForColumns");
        
        //Set
        $(".selector").igPivotGrid("option", "isParentInFrontForColumns", true);
      

A boolean value indicating whether a parent in the rows is in front of its children.
If set to true, the query set sorts members in a level in their natural order - child members immediately follow their parent members.
If set to false the query set sorts the members in a level using a post-natural order. In other words, child members precede their parents.

 
        //Initialize
        $('.selector').igPivotGrid({
             isParentInFrontForRows : true
        });
        
        //Get
        var isParentInFrontForRows = $(".selector").igPivotGrid("option", "isParentInFrontForRows");
        
        //Set
        $(".selector").igPivotGrid("option", "isParentInFrontForRows", true);
      

An array of level sort direction items, which predefine the sorted header cells.

 
        //Initialize
        $('.selector').igPivotGrid({
             levelSortDirections : [
                    { levelUniqueName: "[Date].[Dates].[year]", sortDirection: "descending" },
                    { levelUniqueName: "[Product].[Product].[ProductCategory]" }
                ]
        });
        
        //Get
        var levelSortDirections = $(".selector").igPivotGrid("option", "levelSortDirections");
        
        //Set
        $(".selector").igPivotGrid("option", "levelSortDirections", array);
      

• levelUniqueName

  Type:

  string

  Default:

  null

  Specifies the unique name of the level, which will be sorted.

• sortDirection

  Type:

  enumeration

  Default:

  null

  Specifies the sort direction. If no direction is specified, the level is going to be sorted in the direction specified by the firstLevelSortDirection option.