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

Glossary Item Box

Topic Overview

Purpose

This topic provides an overview of the igOlapFlatDataSource™ 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

igOlapFlatDataSource summary

The igOlapFlatDataSource component enables multi-dimensional (OLAP-like) analysis to be performed on flat data collections. Given a data collection or an igDataSource™ instance and based on the user configuration, it extracts the necessary metadata in order to create dimensions of hierarchies and measures. The igOlapFlatDataSource component also performs calculations and aggregates data as requested using the component’s API directly or through one or more of the Ignite UI widgets capable of visualizing and interacting with OLAP data, e.g. igPivotView™ or igPivotGrid™.

Main Features Summary

Main features summary chart

The following table summarizes the main features of the igOlapFlatDataSource component.

Feature

Description

Multiple data types support

Any data source supported by the igDataSource component can be used as input data.

OLAP metadata generation

The igOlapFlatDataSource allows programmatically defining of custom metadata structure based on your input data.

Data slices generation

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

Integration with Ignite UI controls

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


Multiple data types support

Any data source supported by the igDataSource component can be used as input data for igOlapFlatDataSource. The igOlapFlatDataSource component works on top of an igDataSource instance that is being fed with data. Alternatively, you can use any data source supported by the igDataSource component, by specifying a data source options object. This way, you can perform an Online Analytical Processing (OLAP) analysis on almost any data collection. For a list of the data types supported by igDataSource, refer to igDataSource Overview.

Related Topics:

OLAP metadata generation

The igOlapFlatDataSource allows programmatically defining of custom metadata structure based on your input data. You can specify a data sub-set of your data objects when generating the members of a level and when calculating the values for a measure. You can define hierarchies and specify which levels to be used for a hierarchy. You can group the hierarchies to dimensions and also specify some properties for the cube to which these dimensions belong.

Related Topics:

Data slices generation

The igOlapFlatDataSource 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, igOlapFlatDataSource calculates the required data values and writes them 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 based on the existing measures.

Related Topics:

Integration with Ignite UI controls

The igOlapFlatDataSource 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

Adding igOlapFlatDataSource

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

Defining Metadata (igOlapFlatDataSource)

This topic explains how to define metadata for the data used with igOlapFlatDataSource so that flat data can be presented in multi-dimensional (OLAP) form.

Configuring the Tabular View of the Result Set by Arranging the Columns, Rows, Filters, and Measures of the Pivot Grid (igFlatDataSource, 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.

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