PivotGrid OLAP Filtering

[Daniel Schuessler]

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

[Rosen Vladimirov]

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

[Luis Gilbert]

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.

[Rosen Vladimirov]

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

[Kristoffer Rødseth]

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?

[Rosen Vladimirov]

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

[Kristoffer Rødseth]

Perfect, thank you very much.