or
AdomdConnectionSettings connectionSettings = new AdomdConnectionSettings();connectionSettings.Cube = "Operation";connectionSettings.Database = "Contoso_Retail";connectionSettings.ConnectionString = @"Provider=MSOLAP;Data Source=server;Initial Catalog=Contoso_Retail;";AdomdGroupDescription rowGroupDescription1 = new AdomdGroupDescription();rowGroupDescription1.MemberName = "[Date].[Calendar YQMD]";AdomdGroupDescription columnGropuDescription1 = new AdomdGroupDescription();columnGropuDescription1.MemberName = "[Geography].[Geography Hierarchy]";AdomdAggregateDescription aggregateDescription1 = new AdomdAggregateDescription();aggregateDescription1.MemberName = "[Measures].[Sales Amount]";AdomdDataProvider adomdDataProvider = new AdomdDataProvider();adomdDataProvider.ConnectionSettings = connectionSettings;adomdDataProvider.BeginInit();adomdDataProvider.RowGroupDescriptions.Add(rowGroupDescription1);adomdDataProvider.ColumnGroupDescriptions.Add(columnGropuDescription1);adomdDataProvider.AggregateDescriptions.Add(aggregateDescription1);adomdDataProvider.EndInit();this.radPivotGrid.DataProvider = adomdDataProvider;this.radPivotFieldList.DataProvider = adomdDataProvider;<Grid> <Grid.ColumnDefinitions> <ColumnDefinition Width="2*"/> <ColumnDefinition Width="*"/> </Grid.ColumnDefinitions> <pivot:RadPivotGrid x:Name="radPivotGrid"/> <pivot:RadPivotFieldList x:Name="radPivotFieldList" Grid.Column="1"/></Grid><LinearGradientBrush x:Key="GridViewRowSelectedBackground" EndPoint="0.5,1" StartPoint="0.5,0"> <GradientStop Color="#FFFFCA5D" Offset="1"/> <GradientStop Color="#FFFFDC9C" Offset="0"/></LinearGradientBrush> <Style x:Key="Form_Style" TargetType="Border" > <Setter Property="BorderBrush" Value="White" /> <Setter Property="BorderThickness" Value="2" /> <Setter Property="Padding" Value="1" /> <Setter Property="Margin" Value="1" /> <Setter Property="CornerRadius" Value="5"/> <Setter Property="Background" Value="{StaticResource Form_Background}" /> <Style.Triggers> <Trigger Property="IsKeyboardFocusWithin" Value="True" > <Setter Property="Background" Value="{StaticResource GridViewRowSelectedBackground}" /> </Trigger> </Style.Triggers></Style>