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;
}
