Completed
Last Updated: 08 Mar 2018 09:10 by ADMIN
ADMIN
Polya
Created on: 08 Jun 2015 09:43
Category: PivotGrid
Type: Feature Request
2
PivotGrid: Add a way to display all distinct values in value\label filter dialog
The DistinctValuesLimit property is available in our R1 2018 Release.
(Total attached files size should be smaller than 20mb. Allowed extensions: .zip, .rar, .jpg, .png, .gif)
4 comments
ADMIN
Kalin
Posted on: 06 Dec 2017 08:20
Hi Paulo,

There is another item in the portal regarding the filter TextBox, please vote for it on the the following link:
https://feedback.telerik.com/Project/143/Feedback/Details/201209-pivotgrid-filtering-textbox-for-distinct-values

As for this feature request we have added DistinctValuesLimit property to the Adomd and Xmla providers. It is already live with the latest internal build - please give it a try.

Kalin
Paulo
Posted on: 05 Dec 2017 14:40
I would like the suggest add filter textbox similar the excel. When there are many options is more easy use the text to filter the values.
Attached Files:
Software
Posted on: 20 Nov 2017 15:12
the WPF control code that is being used limits to top 100:

SELECT {TOPCOUNT(AddCalculatedMembers({[Products].[SKU].Children}), 1000)} DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME ON COLUMNS FROM [Account Planning]

I have changed this in the source code to test, but getting the controls building was impossible.
Paulo
Posted on: 20 Nov 2017 15:01
There is a KB solution to same problem in ASP.NET Ajax, https://www.telerik.com/support/kb/aspnet-ajax/pivotgrid/details/filter-list-missing-values-with-large-amount-of-data