topic Need help to understand a specific part in the documentation in SAS Visual Analytics

Need help to understand a specific part in the documentation

Achraf_Ougdal — Wed, 05 Jul 2023 12:44:24 GMT

Hello,

I was looking for the Limit number of rows that the different objects can show in this link https://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#n0r2de9vkep76bn1tjb53x9l43g3.htm

But I didn't understand the following sentence :

If a data source contains more than a million records, queries are blocked for data items whose cardinality is greater than 10,000 unique items in any particular category.

Can someone please explain ?

Thank you so much

Re: Need help to understand a specific part in the documentation

Madelyn_SAS — Wed, 05 Jul 2023 13:07:52 GMT

Your link is to very old documentation. This is the same topic in Visual Analytics 7.5 and I don't see that reference to a million records included.

https://go.documentation.sas.com/doc/en/vacdc/7.5/varef/p07uif0jfvtijon0zgbm5hiaqip4.htm

To see that same topic for other releases on SAS Viya, select your release from the drop-down list in the upper left.

Re: Need help to understand a specific part in the documentation

Sam_SAS — Wed, 05 Jul 2023 14:21:17 GMT

Hello,

I don't think that the note applies to releases after 7.4. If you have VA 7.4 (or earlier??), it might actually be difficult to find someone who can remember what this was supposed to mean.

It is likely that I wrote the note many years ago, based on something a developer told me. But we don't retain emails or other records that old anymore.

My best guess from looking at the note is that VA 7.4 would show an error in an object if: 1) the source table has more than 1 million rows and 2) a category in the object has more than 10,000 distinct values after filters/ranks are applied (cardinality). So for example, a list table would have an effective cardinality limit of 10,000 instead of 40,000 when the data source has more than 1 million rows.

I can look into this further if you have VA 7.4 or earlier and you need to know for sure, but I can't guarantee that I can get a conclusive answer.

Sam