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

OLAP Filter Issue

5 Answers 51 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
AP
Top achievements
Rank 1
Iron
Iron
Veteran
AP asked on 02 Jun 2015, 03:25 PM

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

5 Answers, 1 is accepted

Sort by
0
Kalin
Telerik team
answered on 05 Jun 2015, 08:32 AM
Hello,

We are not aware of such an issue with the PivotGrid control and OLAP. Can you please try reproduce the issue our online Silverlight demo and share a video with the exact steps?

I'm looking forward to hearing from you.

Regards,
Kalin
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
AP
Top achievements
Rank 1
Iron
Iron
Veteran
answered on 05 Jun 2015, 09:03 AM

Kalin,

Thanks for the response, - I'm not set up to produce a video. I have had a look at the online demo, and don't seem to be able to reproduce the issue. However, your OLAP cube demo looks a bit strange, as it always seems to report the same numbers. Attachment 1 shows the grid (with a filter applied) split by country and category. The totals just seem to replicate the country columns - which doesn't seem to be right!

I have also attached images showing the issue in our own grid, step by step. It's based on a very simple cube, with simple dimensions.

  • Attachment 2 shows the pivot grid without a filter
  • Attachment 3 shows the site filter dialogue box
  • Attachment 4 shows the results when the select all option is used to deselect all values, and then a single value (Solihull) is selected
  • Attachment 5 shows the results (after removing the filter, refreshing, and then adding the filter again) when instead of using the select all option, values were deselected individually.

As you will see, the total values are the same, but when the select all option is used to unselect values, only the total column in the pivot grid is shown. The application is based on your OLAP demo, with no extra code added in the cs file.

0
Kalin
Telerik team
answered on 10 Jun 2015, 08:43 AM
Hi Andrew,

We tested the same steps in our OLAP examples, but couldn't manage to observe the explained issue. In order to provide further assistance we would need to be able to reproduce that behavior, so we can investigate it on our side. If you manage to reproduce it in one of our OLAP demos that would be really helpful. Otherwise you could send us the OLAP cube with a sample project with the exact settings and will be glad to check it and think of solution.

I'm looking forward to hearing from you.

Regards,
Kalin
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
AP
Top achievements
Rank 1
Iron
Iron
Veteran
answered on 12 Jun 2015, 12:50 PM

Kalin,

 

I suspect it may be cube specific. I will investigate further on some other cubes and see if I can re-produce the error.

 

0
Kalin
Telerik team
answered on 16 Jun 2015, 03:18 PM
Hi Andrew,

Please let us know when you have further information regarding the issue.

Meanwhile if you have any other questions, do not hesitate to contact us.

Regards,
Kalin
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
PivotGrid
Asked by
AP
Top achievements
Rank 1
Iron
Iron
Veteran
Answers by
Kalin
Telerik team
AP
Top achievements
Rank 1
Iron
Iron
Veteran
Share this question
or