Version

Adding MdxDataSelector

Overview

Although a separate control, the data selector ( MdxDataSelector) is an essential mechanism for the WinPivotGrid control; binding the data selector to the same data source as the pivot grid. The WinPivotGrid displays the list of dimensions and measures that the user can interact with at runtime by adding them to the pivot grid.

Note
Note:

If the data selector is not present at runtime, you will not be able to add the dimensions. You can only remove them from the pivot grid.

The following code example demonstrates binding data selector to the same data source as the pivot grid, using the data source object illustrated in the previous examples.

In C#:

mdxDataSelector1.DataSource = xmlaDs;

In Visual Basic:

mdxDataSelector1.DataSource = xmlaDs

The following screenshot illustrates the pivot grid with data selector both bound to XMLA data source. The same approach applied to ADOMD data source.

Adding MdxDataSelector 1.png