private void SetupAdomdProvider() { AdomdDataProvider provider = new AdomdDataProvider(); AdomdConnectionSettings settings = new AdomdConnectionSettings(); settings.Cube = "Adventure Works"; settings.Database = "Adventure Works DW 2008R2"; settings.ConnectionString = "Data Source=http://demos.telerik.com/olap/msmdpump.dll;Catalog=Adventure Works DW 2008R2"; provider.ConnectionSettings = settings; provider.AggregatesPosition = Pivot.Core.PivotAxis.Rows; provider.RowGroupDescriptions.Add(new AdomdGroupDescription() { MemberName = "[Product].[Category]" }); provider.ColumnGroupDescriptions.Add(new AdomdGroupDescription() { MemberName = "[Date].[Fiscal Year]" }); provider.AggregateDescriptions.Add(new AdomdAggregateDescription() { MemberName = "[Measures].[Internet Sales Amount]" }); provider.AggregateDescriptions.Add(new AdomdAggregateDescription() { MemberName = "[Measures].[Internet Revenue Goal]" }); provider.AggregateDescriptions.Add(new AdomdAggregateDescription() { MemberName = "[Measures].[Internet Revenue Status]" }); provider.AggregateDescriptions.Add(new AdomdAggregateDescription() { MemberName = "[Measures].[Internet Revenue Trend]" }); this.radPivotGrid1.PivotGridElement.DataProvider = provider; provider.DeferUpdates = false; }
private void SetupAdomdProvider() { AdomdDataProvider provider = new AdomdDataProvider(); AdomdConnectionSettings settings = new AdomdConnectionSettings(); settings.Cube = "Adventure Works"; settings.Database = "Adventure Works DW 2008R2"; settings.ConnectionString = "Data Source=http://demos.telerik.com/olap/msmdpump.dll;Catalog=Adventure Works DW 2008R2"; provider.ConnectionSettings = settings; provider.RowGroupDescriptions.Add(new AdomdGroupDescription() { MemberName = "[Date].[Calendar Year]" }); provider.RowGroupDescriptions.Add(new AdomdGroupDescription() { MemberName = "[Date].[Calendar Quarter of Year]" }); provider.ColumnGroupDescriptions.Add(new AdomdGroupDescription() { MemberName = "[Promotion].[Promotion Category]" }); provider.ColumnGroupDescriptions.Add(new AdomdGroupDescription() { MemberName = "[Product].[Category]" }); provider.AggregateDescriptions.Add(new AdomdAggregateDescription() { MemberName = "[Measures].[Internet Order Quantity]" }); provider.FilterDescriptions.Add(new AdomdFilterDescription() { MemberName = "[Product].[Product Line]" }); this.radPivotGrid1.PivotGridElement.DataProvider = provider; }