topic Re: SAS Viya 3.5 - no data appears because too many values were returned from the query in SAS Visual Analytics

SAS Viya 3.5 - no data appears because too many values were returned from the query

mrafiqahmed — Sat, 12 Dec 2020 10:07:18 GMT

Hi,

I have a crosstab in my report. When I open the report, it doesn't load the data into the crosstab; it shows the warning

'no data appears because too many values were returned from the query...'

Please look at the screenshot.

I have set 5000000 limit for crosstab in reportdata.properties; but, still this issue occurs. Any help to resolve this issue is appreciated.

rodrigo_pereira — Wed, 30 Jun 2021 07:53:20 GMT

Hello,

same issue here!
There are other parameters which should be changed in order to have the data displayed and exported as is in the cross tab?

Thank you,

Rodrigo

rodrigo_pereira — Wed, 30 Jun 2021 09:59:16 GMT

Even after the changin the CrossTab limit to 500.000, the cross tab apparently is still limited to 40.000 rows.

Madelyn_SAS — Wed, 30 Jun 2021 14:12:43 GMT

There are other cardinality properties that can impact the amount of data shown. Please see

https://support.sas.com/kb/62/148.html