Daniel Schuessler
Top achievements
Rank 1
Daniel Schuessler
asked on 15 Apr 2013, 06:50 PM
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
This is really a basic feature that is required for the grid to be feature complete.
thanks,
dan
6 Answers, 1 is accepted
0
Accepted
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
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.
0
Luis Gilbert
Top achievements
Rank 1
answered on 13 May 2013, 08:07 PM
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.
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.
0
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
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.
0
Kristoffer Rødseth
Top achievements
Rank 1
answered on 19 Aug 2013, 11:43 AM
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?
0
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:
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:
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:
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
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 >>
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 >>
0
Kristoffer Rødseth
Top achievements
Rank 1
answered on 04 Sep 2013, 12:39 PM
Perfect, thank you very much.