I have a PivotGrid, reading an SSAS OLAP cube. This works really well, apart from a problem when applying some filters. If a field is dragged into the report filter box, and the filter applied by first unselecting all the values, then choosing a single value , the grid shows the correct totals, but shows blanks in the other cells.
Filtering by unselecting the unwanted items instead, doesn't seem to cause this issue.
Attached are before the filter and after the filter screenshots.
Below is the XAML - I haven't at this point done much more than replicate your demo, pointing to our cube.
<UserControl
xmlns:sys
=
"clr-namespace:System;assembly=mscorlib"
xmlns:pivot
=
"http://schemas.telerik.com/2008/xaml/presentation/pivot"
x:Class
=
"CubeBrowser.MainPage"
mc:Ignorable
=
"d"
d:DesignHeight
=
"400"
d:DesignWidth
=
"700"
>
<UserControl.Resources>
<pivot:XmlaDataProvider x:Key
=
"DataProvider"
>
<pivot:XmlaDataProvider.ConnectionSettings>
<pivot:XmlaConnectionSettings
Cube
=
"ADT_Timeliness_Cube"
Database
=
"AcademyAS"
ServerAddress
=
"http://finsql3/olap/msmdpump.dll"
/
>
<
/
pivot:XmlaDataProvider.ConnectionSettings>
<pivot:XmlaDataProvider.RowGroupDescriptions>
<pivot:XmlaGroupDescription MemberName
=
"[EventType].[EventType]"
/
>
<
/
pivot:XmlaDataProvider.RowGroupDescriptions>
<pivot:XmlaDataProvider.ColumnGroupDescriptions>
<pivot:XmlaGroupDescription MemberName
=
"[ReportingSite].[ReportSiteName]"
/
>
<
/
pivot:XmlaDataProvider.ColumnGroupDescriptions>
<pivot:XmlaDataProvider.AggregateDescriptions>
<pivot:XmlaAggregateDescription MemberName
=
"[Measures].[EventCount]"
/
>
<
/
pivot:XmlaDataProvider.AggregateDescriptions>
<pivot:XmlaDataProvider.FilterDescriptions>
<
/
pivot:XmlaDataProvider.FilterDescriptions>
<
/
pivot:XmlaDataProvider>
<
/
UserControl.Resources>
<Grid x:Name
=
"LayoutRoot"
Background
=
"White"
>
<Grid.ColumnDefinitions>
<ColumnDefinition Width
=
"3*"
/
>
<ColumnDefinition Width
=
"*"
/
>
<
/
Grid.ColumnDefinitions>
<Grid.RowDefinitions>
<RowDefinition Height
=
"*"
/
>
<RowDefinition Height
=
"Auto"
/
>
<
/
Grid.RowDefinitions>
<pivot:RadPivotGrid x:Name
=
"Pivot"
Grid.RowSpan
=
"2"
DataProvider
=
"{StaticResource DataProvider}"
/
>
<pivot:RadPivotFieldList x:Name
=
"FieldList"
Grid.Column
=
"1"
Margin
=
"4 0 0 0"
DataProvider
=
"{StaticResource DataProvider}"
/
>
<
/
Grid>
<
/
UserControl>
Is this a bug, or can I do something to stop this happening?
Thanks