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?
Thanks
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