C# Populate KetticPivotGrid with Data using AdomdDataProvider
KetticPivotGrid control allows the users to populate this control with data from OLAP Cube and it uses the AdomdDataProvider to import data from OLAP Cube. The KetticPivotGrid control supports Microsoft.AnalysisServices.AdomdClient and we need to install an Adomd client on our computer to use the AdomdDataProvider. In this tutorial, we shall go through the procedures of using the AdomdDataProvider to bind KetticPivotGrid to data in C#.NET.
Key Properties of AdomdDataProvider for PivotGrid
When we want to get data from OLAP Cube, we shall define the significant properties of AdomdDataProvider as below.
Define AdomdDataProvider and Connect to OLAP Cube
In order to display data in KetticPivotGrid and KetticPivotFieldList, the users of the control need to connect the KetticPivotGrid to OLAP Cube. The C# code below demonstrates how to modify the ConnectionSettings property of the AdomdDataProvider to connect to OLAP Cube in .NET applications.
Define Group Descriptions in AdomdDataProvider for PivotGrid
KetticPivotGrid control contains three different description collections to store data for the AdomdDataProvider to display in KetticPivotGrid and KetticPivotFieldList, including RowGroupDescription, ColumnGroupDescription, and AggregateDescriptions collections.
The AdomdGroupDescription defines the data displaying in Rows and Columns in KetticPivotGrid. The AdomdGroupDescription contains the MemberName property for the users to set the string according to the OLAP Cube.
The AdomdAggregateDescription defines the data aggregated and displayed in cells in KetticPivotGrid. The AdomdAggregateDescription contains the MemberName property for the users to set the data that will be aggregated.
UI Controlsfor Windows Forms.NET WinForms UI Overview.NET WinForms UI Features.NET WinForms UI GuideC# WinForms UI DesignVB.NET WinForms UI Design
WinForms UI Controls