PivotGrid OLAP Filtering

7 posts, 1 answers
  1. Daniel Schuessler
    Daniel Schuessler avatar
    7 posts
    Member since:
    Mar 2010

    Posted 15 Apr 2013 Link to this post

    The PivotGrid does not allow filtering by dimension values that are in the Row Labels (or Column Labels) sections.  This is allowed in Excel when connected to an OLAP data source by clicking on the Row Labels cell (in the grid) and by unselecting the values that you want to filter out.   See attached image.

    This is really a basic feature that is required for the grid to be feature complete.

    thanks,

    dan
  2. Answer
    Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 16 Apr 2013 Link to this post

    Hi Daniel Schuessler,

    Thank you for sending your feedback. We are really happy when our customers share their opinion, so we can evaluate the features based on your needs. This one is in our to-do list and we'll try to push it higher in the list, but in the moment there are other features on the pipeline, so I cannot give you exact timeframe when this will be ready.

    We are sorry for the caused inconvenience. Feel free to contact us if you have any problems or concerns.

    Kind regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  3. DevCraft banner
  4. Luis Gilbert
    Luis Gilbert avatar
    15 posts
    Member since:
    Jul 2009

    Posted 13 May 2013 Link to this post

    I think you should consider adding searching feature inside filtering.
    For example, when you have a dimension with thousand of customer names, it is not user-friendly to find a customer name.
    A better approach would be to have inside the filter function a textbox that show customers that "contains" whatever is in textbox.
  5. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 15 May 2013 Link to this post

    Hello Luis Gilbert,

    We've already added this feature in our to-do list and hopefully it will be ready soon. Thank you for sharing your suggestions. Feel free to contact us in case you have any other ideas or concerns.

    Regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  6. Kristoffer Rødseth
    Kristoffer Rødseth avatar
    4 posts
    Member since:
    Mar 2010

    Posted 19 Aug 2013 Link to this post

    Filtering by dimension values that are in the Row or Column Labels sections is a feature we are waiting for. Can you give an update as to when it will be available?
  7. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 20 Aug 2013 Link to this post

    Hello Kristoffer,

    Since our 2013.2 724 release, we have included this filtering feature in our RadPivotGrid and RadPivotFieldList.

    I'm sending you a sample project, demonstrating the usage of RadPivotFieldList's dialog to filter the items in rows/columns. In XAML you will find a declaration of Label filter on [Product].[Category] group description. In the UI you can click on Category in RadPivotFieldList (columns) and open Label filter dialog to see which of the items are selected.

    Basically we have extended our Label Filters and now you are able to use OlapSetCondition (previously this condition was available for Filter Descriptions only) or combination of OlapSetCondition and another condition via OlapItemsFilterCondition. Let me explain these scenarios:

    1) Use "old" way to add label filter:
    <pivot:XmlaGroupDescription MemberName="[Product].[Category]">
        <pivot:XmlaGroupDescription.GroupFilter>
            <pivot:OlapLabelGroupFilter>
                <pivot:OlapLabelGroupFilter.Condition>
                    <pivot:OlapTextCondition Comparison="Contains" Pattern="Bi"/>
                </pivot:OlapLabelGroupFilter.Condition>
            </pivot:OlapLabelGroupFilter>
        </pivot:XmlaGroupDescription.GroupFilter>
    </pivot:XmlaGroupDescription>


    This way all items in the top part of the Label dialog will be checked, while in the bottom part you will see the applied filter.

    2) Apply "OlapSetCondition" only:
    <pivot:XmlaGroupDescription MemberName="[Product].[Category]">
        <pivot:XmlaGroupDescription.GroupFilter>
            <pivot:OlapLabelGroupFilter>
                <pivot:OlapLabelGroupFilter.Condition>
                    <pivot:OlapSetCondition Comparison="Includes">
                        <pivot:OlapSetCondition.Items>
                            <sys:String>[Product].[Category].&[1]</sys:String>
                            <sys:String>[Product].[Category].&[3]</sys:String>
                        </pivot:OlapSetCondition.Items>
                    </pivot:OlapSetCondition>
                </pivot:OlapLabelGroupFilter.Condition>
            </pivot:OlapLabelGroupFilter>
        </pivot:XmlaGroupDescription.GroupFilter>
    </pivot:XmlaGroupDescription>

    This way in the top part of the Label filter dialog, only the selected items will be checked. In the bottom part, the default state will be shown. 

    3) Apply two conditions simultaneously:
    <pivot:XmlaGroupDescription MemberName="[Product].[Category]">
        <pivot:XmlaGroupDescription.GroupFilter>
            <pivot:OlapLabelGroupFilter>
                <pivot:OlapLabelGroupFilter.Condition>
                    <pivot:OlapItemsFilterCondition>
                        <pivot:OlapItemsFilterCondition.DistinctCondition>
                            <pivot:OlapSetCondition Comparison="Includes">
                                <pivot:OlapSetCondition.Items>
                                    <sys:String>[Product].[Category].&[1]</sys:String>
                                    <sys:String>[Product].[Category].&[3]</sys:String>
                                </pivot:OlapSetCondition.Items>
                            </pivot:OlapSetCondition>
                        </pivot:OlapItemsFilterCondition.DistinctCondition>
                        <pivot:OlapItemsFilterCondition.Condition>
                            <pivot:OlapTextCondition Comparison="Contains" Pattern="Bi"/>
                        </pivot:OlapItemsFilterCondition.Condition>
                    </pivot:OlapItemsFilterCondition>
                </pivot:OlapLabelGroupFilter.Condition>
            </pivot:OlapLabelGroupFilter>
        </pivot:XmlaGroupDescription.GroupFilter>
    </pivot:XmlaGroupDescription>

    In this case you have to use OlapItemsFilterCondtion, which has Condition and DistinctCondition properties. In the DistinctCondition you should use OlapSetCondition and it will be visible in the top part of the Label filter dialog. In the bottom part of the dialog you will see the condition set to Condition property of OlapItemsFilterCondition

    You can use any of the three ways to define filters. In case you need only a single filter, use one of the first two ways, in a more complex scenario you can use OlapItemsFilterCondition.

    Hopefully this helps. Feel free to contact us in case you have any problems or concerns.

    Regards,
    Rosen Vladimirov
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
  8. Kristoffer Rødseth
    Kristoffer Rødseth avatar
    4 posts
    Member since:
    Mar 2010

    Posted 04 Sep 2013 Link to this post

    Perfect, thank you very much.
Back to Top
DevCraft banner