High cardinality thresholds in SAS Visual Analytics

Naz10 — Mon, 29 Mar 2021 22:24:30 GMT

I'd like to increase the number of predictions in the text input object, i.e. if I have a list of names and I start typing 'al' in the text input box, it brings up all the options that contain 'al'. The issue is that it displays top 20,000 rows (there are about 1M rows in the data).

I found a few recommendations, but none of them worked:

- Override system data limit locally within the report object https://support.sas.com/kb/67/404.html .

- Increased MaxRowsLookup in Environment Manager https://support.sas.com/kb/62/148.html

- Added midtierAllocationByteLimit to the Report Data service properties and increased to 500,000,000 as suggested here https://support.sas.com/kb/62/148.html.

Based on the server log in VA, the limit is still 20,000:

START:			MultiResultQueryManager.initialize
sas.reportdata.defaultMaxCellsProducedrow limit :250000 sas.reportdata.custom.protobufSizeLimitrow limit :48000 sas.reportdata.custom.expectedMaxCharsPerColumn sas.reportdata.custom.midtierAllocationByteLimit mid tier protect row limit:20000 sas.reportdata.custom.expectedMaxCharsPerColumn sas.reportdata.custom.midtierAllocationByteLimit aggregate estimate row limit:4900 sas.reportdata.custom.expectedMaxCharsPerColumn sas.reportdata.custom.midtierAllocationByteLimit summary estimate row limit:4200 sas.reportdata.custom.categoryCardinalityServerLimit row limit:50000 
com.sas.bidata.result.cas.CasGroupByQueryRunner time elapsed:7251milliseconds, total elapsed:7254

Any ideas what or how to increase the number of rows?

Thanks in advance!

Re: High cardinality thresholds in SAS Visual Analytics

Madelyn_SAS — Tue, 08 Jun 2021 19:36:20 GMT

Assuming this is Visual Analytics on SAS Viya, in edit mode, select the text input control and then press CTRL+ALT+Q. On the 'snowman' menu, select False for retrieve from cache. The other options should be OK. Click the little arrow to re-run the query. This will add a few tabs to the window. Display the o Results tab. What are the rowCount and availableRowCount in the <DataFile> tag.

Re: High cardinality thresholds in SAS Visual Analytics

alisio_meneses — Mon, 23 Jan 2023 19:19:27 GMT

Could you please explain what menu is this 'snowman?

Re: High cardinality thresholds in SAS Visual Analytics

Madelyn_SAS — Mon, 23 Jan 2023 19:29:43 GMT

It is the three vertical dots.

topic Re: High cardinality thresholds in SAS Visual Analytics in SAS Visual Analytics

High cardinality thresholds in SAS Visual Analytics

Re: High cardinality thresholds in SAS Visual Analytics

Re: High cardinality thresholds in SAS Visual Analytics

Re: High cardinality thresholds in SAS Visual Analytics