A javascript object containing the data souce configuration options as properties.

• catalog

  Type:

  string

  Default:

  null

  The catalog name.

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

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

• filters

  Type:

  string

  Default:

  null

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

• isRemote

  Type:

  bool

  Default:

  false

  Specifies if the data is to be served by a XMLA remote provider.

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

• measures

  Type:

  string

  Default:

  null

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

• requestOptions

  Type:

  object

  Default:

  {}

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

  Code Sample

   
  // Initialize
  $.ig.OlapXmlaDataSource({
      requestOptions: {
          // example for setting the credentials for basic authentication
          withCredentials: true,
          beforeSend: function (jqXHR, options, requestOptions) {
              var xhr = options.xhr();
              if (requestOptions.withCredentials && "withCredentials" in xhr) {
                  // if the user name is "user123" and the passord is "password123" the value set for the
                  // Authorization header will be "Basic dXNlcjEyMzpwYXNzd29yZDEyMw==" where "dXNlcjEyMzpwYXNzd29yZDEyMw=="
                  // is the Base64 encoded string "user123:password123"
                  jqXHR.setRequestHeader("Authorization", "Basic UserName:PasswordEncodedInBase64");
              }
          }
      }
  });
  
            

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

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

• serverUrl

  Type:

  string

  Default:

  null

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