Configuration settings that will be assigned to the igPivotDataSelector widget.

• customMoveValidation

  Type:

  function

  Default:

  null

  A function that will be called to determine if an item can be moved in or dropped on an area of the data selector.
  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.

• dragAndDropSettings

  Type:

  object

  Default:

  {}

  Settings for the drag and drop functionality of the igPivotDataSelector.

  • 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.

• dropDownParent

  Type:

  enumeration

  Default:

  body

  Specifies the parent for the drop downs.

Configuration settings for the panel containing the igPivotDataSelector.

• collapsed

  Type:

  bool

  Default:

  false

  Determines if the panel containing the igPivotDataSelector will initially collapsed.

• collapsible

  Type:

  bool

  Default:

  true

  Determines if the panel containing the igPivotDataSelector will be collapsible.

• location

  Type:

  enumeration

  Default:

  right

  Determines the position of the data selector panel inside the igPivotView widget.

• resizable

  Type:

  bool

  Default:

  true

  Determines if the panel containing the igPivotDataSelector will be resizable.

• size

  Type:

  enumeration

  Default:

  250

  Determines the size of the igPivotDataSelector panel. The recommended value is 250px.

  Members

  • string
  • Type:string
  • The panel size can be set in pixels (px).
  • number
  • Type:number
  • The size can be set as a number.
  • null
  • Type:object
  • will automatically size the panel.

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

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.

• 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.

.

Set/Get the locale language setting for the widget.

Set/Get the locale setting for the widget.

Configuration settings that will be assigned to the igPivotGrid widget.

• allowHeaderColumnsSorting

  Type:

  bool

  Default:

  false

  Enables sorting of the header cells in columns.

• allowHeaderRowsSorting

  Type:

  bool

  Default:

  false

  Enables sorting of the header cells in rows.

• allowSorting

  Type:

  bool

  Default:

  false

  Enables sorting of the value cells in columns.

• compactColumnHeaderIndentation

  Type:

  number

  Default:

  30

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

• compactColumnHeaders

  Type:

  bool

  Default:

  false

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

• compactRowHeaderIndentation

  Type:

  number

  Default:

  20

  The indentation for every level row when the rowHeadersLayout is set to 'compact'.

• customMoveValidation

  Type:

  function

  Default:

  null

  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.

• defaultRowHeaderWidth

  Type:

  number

  Default:

  200

  Typle="number" Specifies the width of the row headers.

• disableColumnsDropArea

  Type:

  bool

  Default:

  false

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

• disableFiltersDropArea

  Type:

  bool

  Default:

  false

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

• disableMeasuresDropArea

  Type:

  bool

  Default:

  false

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

• disableRowsDropArea

  Type:

  bool

  Default:

  false

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

• dragAndDropSettings

  Type:

  object

  Default:

  {}

  Settings for the drag and drop functionality of the igPivotDataSelector.

  • 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.

• dropDownParent

  Type:

  enumeration

  Default:

  body

  Specifies the parent for the drop downs.

• firstLevelSortDirection

  Type:

  enumeration

  Default:

  ascending

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

• firstSortDirection

  Type:

  enumeration

  Default:

  ascending

  Spefies the default sort direction for the rows.

• gridOptions

  Type:

  object

  Default:

  {}

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

  • 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
    • Type:string
    • The default column width can be set in pixels (px).
    • number
    • Type: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.

  • fixedHeaders

    Type:

    bool

    Default:

    true

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

  • tabIndex

    Type:

    number

    Default:

    0

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

• hideColumnsDropArea

  Type:

  bool

  Default:

  false

  Hide the columns drop area.

• hideFiltersDropArea

  Type:

  bool

  Default:

  false

  Hide the filters drop area.

• hideMeasuresDropArea

  Type:

  bool

  Default:

  false

  Hide the measures drop area.

• hideRowsDropArea

  Type:

  bool

  Default:

  false

  Hide the rows drop area.

• isParentInFrontForColumns

  Type:

  bool

  Default:

  false

  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.

• isParentInFrontForRows

  Type:

  bool

  Default:

  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.

• levelSortDirections

  Type:

  array

  Default:

  []

  Elements Type:

  object

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

  • levelUniqueName

    Type:

    string

    Default:

    null

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

  • sortDirection

    Type:

    enumeration

    Default:

    null

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

• rowHeadersLayout

  Type:

  enumeration

  Default:

  compact

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

Configuration settings for the panel containing the igPivotGrid.

• collapsed

  Type:

  bool

  Default:

  false

  Determines if the panel containing the igPivotGrid will initially collapsed.

• collapsible

  Type:

  bool

  Default:

  false

  Determines if the panel containing the igPivotGrid will be collapsible.

• resizable

  Type:

  bool

  Default:

  true

  Determines if the panel containing the igPivotGrid will be resizable.

• size

  Type:

  enumeration

  Default:

  null

  Determines the size of the igPivotGrid panel.

  Members

  • string
  • Type:string
  • The panel size can be set in pixels (px).
  • number
  • Type:number
  • The size can be set as a number.
  • null
  • Type:object
  • will automatically size the panel.

Set/Get the regional setting for the widget.

.