07-25-2016 03:08 PM
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).
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?
07-25-2016 04:06 PM
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_sas
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
07-25-2016 04:50 PM
07-26-2016 03:28 AM
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.