Infragistics(R) IgniteUI
igOlapXmlaDataSource Overview
E-mail your feedback on this topic.

Glossary Item Box

Topic Overview

Purpose

This topic provides an overview of the igOlapXmlaDataSource™ component and its main features.

Required background

The following table lists the topics and concepts required as a prerequisite to understanding this topic.

Type

Content

Topics

Topic

Purpose

This group of topics explain the multidimensional (OLAP) data source components of the Ignite UI® suite.


 

External Resources


In this topic


Introduction

igOlapXmlaDataSource summary

The igOlapXmlaDataSource component handles the communication between a JavaScript client application and a Microsoft® SQL Server Analysis Services (SSAS) server configured with the msmdpump.dll HTTP data provider. It exposes a user-friendly way for obtaining data from Microsoft SQL Server Analysis Services (MS SASS) – you do not have to possess any particular knowledge of Multidimensional Expressions (MDX) or XML for Analysis (XMLA) in order to get the data from an SSAS server. The igOlapXmlaDataSource generates the necessary MDX queries based on the commands it is given. The igOlapXmlaDataSource is usually used with one or more of the Ignite UI widgets capable of visualizing and interacting with OLAP data, e.g. igPivotView™ or igPivotGrid™.


Main Features

Main features summary chart

The following table summarizes the main features of the igOlapXmlaDataSource component. Additional details on each feature are available after the table.

Feature

Description

Given a URL of an Internet Information Services (IIS) server hosting the msmdpump.dll Internet Server Application Programming Interface (ISAPI) extension, the igOlapXmlaDataSource establishes connection to the server.

The igOlapXmlaDataSource supports basic (username and password) authentication.

When initialized, the igOlapXmlaDataSource downloads the OLAP metadata from the server – available databases, cubes, measure groups, dimensions, etc.

After hierarchies are assigned as rows/columns, igOlapXmlaDataSource generates one or more result axes containing tuples of members from the corresponding hierarchies. If measures, too, have been chosen, igOlapXmlaDataSource generates a two-dimensional array of value cell objects.

The igOlapXmlaDataSource component can feed data to those data visualization controls of Ignite UI that are capable of presenting OLAP data.


MS SSAS server (msmdpump.dll) support

The igOlapXmlaDataSource component is designed to communicate with an MS SQL Server Analysis Services (SSAS) server that has HTTP access through msmdpump.dll. In order to connect to the server, you need to specify only the URL of the server.

Related Topics:

Authentication support

The igOlapXmlaDataSource component exposes options for configuring authentication. For basic authentication, you can either set the credentials in code or let the user enter them from a browser popup. For the configuration requirements and limitations, refer to the related topics.

Related Topics:

Support of OLAP metadata pre-sets

Upon initialization, the igOlapXmlaDataSource component loads all the available metadata from the server. You can limit the downloaded metadata to a relevant pre-configured set by specifying database, cube, and measure group.

Related Topics:

Data slices generation

The igOlapXmlaDataSource component represents an abstraction of a pivot table. It has rows, columns, filters, and measures collections to which data source hierarchies and measures can be added. After adding items to these collections, igOlapXmlaDataSource downloads the needed data and writes it in an $ig.OlapResult object, which can be obtained through the result property. This object has row and column axes containing the hierarchies’ members and an array of data cell objects containing the measure values according to the present measures.

Related Topics:

Integration with Ignite UI controls

The igOlapXmlaDataSource component can feed data to those data visualization controls of Ignite UI that are capable of presenting OLAP data. The controls supported at this writing are igPivotDataSelector, igPivotGrid, and igPivotView.

Related Topics:


Related Content

Topics

The following topics provide additional information related to this topic.

Topic

Purpose

This topic explains how to configure IIS hosting HTTP data provider (msmdpump.dll) for SQL Server Analysis Services (SSAS), for cross-domain access (both authenticated and non-authenticated access). These settings are required for certain usage scenarios of the igOlapXmlaDataSource component.

This topic provides a workaround for configuring IIS for cross-domain authenticated access for the Mozilla® Firefox® browser. (At this writing, due to a bug, the current version of Firefox (17.0.1) does not support the standard IIS configuration (provided here)).

The topics in this group cover adding the igOlapXmlaDataSource component to an HTML page and an ASP.NET MVC View.

This topic explains how to configure the tabular View of the OLAP cube result set by arranging the hierarchies of the pivot grid columns, rows, filters, and measures, either from the grid’s interface or programmatically in the code.

This topic provides information about the known issues and limitations of the igOlapXmlaDataSource component.

igPivotDataSelector Overview

This topic provides conceptual information about the igPivotDataSelector control including its main features, minimum requirements, and user functionality.

igPivotGrid Overview

This topic provides conceptual information about the igPivotGrid control including its main features, minimum requirements, and user functionality.

igPivotView Overview

This topic provides conceptual information about the igPivotView control including its main features, minimum requirements, and user functionality.


Samples

The following samples provide additional information related to this topic.

Sample

Purpose

This sample demonstrates how to bind the igPivotGrid to an igOlapXmlaDataSource and uses an igPivotDataSelector for data selection.

This sample demonstrates how to use the ASP.NET MVC Helper for the igOlapXmlaDataSource and how to use this data source in igPivotDataSelector and igPivotGrid.

This sample demonstrates how to bind the igPivotView to an igOlapXmlaDataSource.