This topic provides an overview of the
igOlapXmlaDataSource™ component and its main features.
The following table lists the topics and concepts required as a prerequisite to understanding this topic.
This topic contains the following sections:
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 for jQuery widgets capable of visualizing and interacting with OLAP data, e.g.
The following table summarizes the main features of the
igOlapXmlaDataSource component. Additional details on each feature are available after the table.
|MS SSAS server support||Given a URL of an Internet Information Services (IIS) server hosting the
|Support of OLAP metadata pre-sets||When initialized, the
|Data slices generation||After hierarchies are assigned as rows/columns,
|Integration with Ignite UI for jQuery controls||The
igOlapXmlaDataSource component is designed to communicate with an MS SQL Server Analysis Services (SSAS) server that has HTTP access through
msmdpump.dll or through ADOMD.NET. In order to connect to the server, you need to specify only the URL of the server.
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.
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.
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.
igOlapXmlaDataSource component can feed data to those data visualization controls of Ignite UI for jQuery that are capable of presenting OLAP data. The controls supported at this writing are
The following topics provide additional information related to this topic.
Adding igOlapXmlaDataSource to an HTML Page: This topic explains how to add the
igOlapXmlaDataSource to and HTML page and how to configure it for retrieving data from a Microsoft® SQL Server Analysis Services (SSAS) Server.
Adding igOlapXmlaDataSource to an ASP.NET MVC Application: This topic explains, in both conceptual and step-by-step form, how to add the
igOlapXmlaDataSource component to an ASP.NET MVC application using the ASP.NET MVC helper.
Data Provider Configuration (igOlapXmlaDataSource): This is a group of topics explaining how to configure the
igOlapXmlaDataSource data providers.
Configuring the Tabular View of the Result Set by Arranging the Columns, Rows, Filters, and Measures of the Pivot Grid (igOlapFlatDataSource, igOlapXmlaDataSource, igPivotDataSelector, igPivotGrid, igPivotView): 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.
Key Performance Indicators Support (igPivotGrid, igPivotDataSelector, igOlapXmlaDataSource): This topic explains conceptually how the Key Performance Indicators (KPIs) data from a multi-dimensional (OLAP) data set is visualized in Ignite UI for jQuery™. The Ignite UI for jQuery controls that visualize KPIs are the
igPivotDataSelector and the
Known Issues and Limitations (igOlapXmlaDataSource): This topic provides information about the known issues and limitations of the
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.
The following samples provide additional information related to this topic.
Binding igPivotGrid to Xmla Data Source: This sample demonstrates how to bind the
igPivotGrid to an
igOlapXmlaDataSource and uses an
igPivotDataSelector for data selection.
Using the ASP.NET MVC Helper with Xmla Data Source: This sample demonstrates how to use the ASP.NET MVC Helper for the
igOlapXmlaDataSource and how to use this data source in
Binding igPivotView to XMLA to Show KPIs: This sample demonstrates how to bind the
igPivotView to an
View on GitHub