OLAP Filter Issue

6 posts, 0 answers
  1. AP
    AP avatar
    187 posts
    Member since:
    Apr 2010

    Posted 02 Jun 2015 Link to this post

    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

  2. Kalin
    Admin
    Kalin avatar
    1208 posts

    Posted 05 Jun 2015 Link to this post

    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
  3. DevCraft banner
  4. AP
    AP avatar
    187 posts
    Member since:
    Apr 2010

    Posted 05 Jun 2015 in reply to Kalin Link to this post

    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.

  5. Kalin
    Admin
    Kalin avatar
    1208 posts

    Posted 10 Jun 2015 Link to this post

    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
  6. AP
    AP avatar
    187 posts
    Member since:
    Apr 2010

    Posted 12 Jun 2015 in reply to Kalin Link to this post

    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.

     

  7. Kalin
    Admin
    Kalin avatar
    1208 posts

    Posted 16 Jun 2015 Link to this post

    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
Back to Top
DevCraft banner