topic Re: Too Many Drop Down Values in SAS Visual Analytics

Too Many Drop Down Values

Ujjawal — Mon, 25 Jul 2016 19:08:16 GMT

I need to report information at customer level. I have around 60K customers. The data is shown below for 1 customer. The same kind of information would be for other 60k customers. There are 7 metrics against each customer so there would be (60K * 7 =420,000 rows in the data).

Customer	Metrics	Scores
ABC	Balance	100005
ABC	Income	25000
ABC	Tenure	20
ABC	Products	A
ABC	Category	AA
ABC	Risk	A+
ABC	Value	B

My requirement is to have a drop down to select a customer and the respective metrics scores would be displayed in a list table. The problem i am facing here is SAS VA is unable to take 60K unique customers' name in a drop down. The data do not get loaded in the drop down. Is there a way to do it? Any option other than drop down?

Re: Too Many Drop Down Values

BrunoMueller — Mon, 25 Jul 2016 20:06:05 GMT

How about using a different approach, enter parts of a customer name and filter the list table based on the entered text. See this video https://www.youtube.com/watch?v=g-ZWxX4jxRU by @TeriPatsilaras

Have not tested it, but using a Text Input Control where you assign your category, allows you to start typing the first letters of the customer name

Bruno

Re: Too Many Drop Down Values

Ujjawal — Mon, 25 Jul 2016 20:50:10 GMT

Thank you so much for your suggestion. I would test it. It seems there is also a restriction on number of rows in a list table. The maximum threshold is 40K. Can we change it?

Re: Too Many Drop Down Values

BrunoMueller — Tue, 26 Jul 2016 07:06:34 GMT

As far as I know, this is not possible.

Bruno

Re: Too Many Drop Down Values

MichelleHomes — Tue, 26 Jul 2016 07:28:19 GMT

Hi,

It might be possible to change the default cardinal it's setting of 40,000 as outlined in the documentation, however I'd question whether the increase client resource consumption is wise and perhaps a better approach to address your requirement with filtering the data first is best.

http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#n0r2de9vkep76bn1tjb53x9l43g3.htm

Kind Regards,

Michelle