This is a migrated thread and some comments may be shown as answers.

XmlaDataProvider

1 Answer 111 Views

PivotGrid

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

David asked on 29 Jan 2013, 09:20 AM

Hi,

Your online demo http://demos.telerik.com/silverlight/#PivotGrid/OlapKpis is wonderful. However, when i migrate the code from xaml to cs, it does not work. Is there anything i missed?

XmlaDataProvider provider = new XmlaDataProvider();

XmlaConnectionSettings settings = new XmlaConnectionSettings();

settings.Cube = "Adventure Works";

settings.Database = "Adventure Works DW 2008R2";

settings.ServerAddress = @"http://demos.telerik.com/olap/msmdpump.dll";

provider.ConnectionSettings = settings;

provider.AggregatesPosition = PivotAxis.Rows;

provider.RowGroupDescriptions.Add(new XmlaGroupDescription() { MemberName = "[Product].[Category]" });

provider.ColumnGroupDescriptions.Add(new XmlaGroupDescription() { MemberName = "[Date].[Fiscal Year]" });

provider.AggregateDescriptions.Add(new XmlaAggregateDescription() { MemberName = "[Measures].[Internet Sales Amount]" });

provider.AggregateDescriptions.Add(new XmlaAggregateDescription() { MemberName = "[Measures].[Internet Revenue Goal]" });

provider.AggregateDescriptions.Add(new XmlaAggregateDescription() { MemberName = "[Measures].[Internet Revenue Status]" });

provider.AggregateDescriptions.Add(new XmlaAggregateDescription() { MemberName = "[Measures].[Internet Revenue Trend]" });

RadPivotGrid pivot = new RadPivotGrid();

pivot.DataProvider = provider;

Thanks

1 Answer, 1 is accepted

Accepted

answered on 29 Jan 2013, 09:40 AM

Hi David,

You should call Refresh method of your DataProvider to show the data in RadPivotGrid. The other (and preferred way when you initialize your DataProvider) is to call BeginInit and EndInit methods so all of your changes will apply together:

provider.BeginInit();