BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Achraf_Ougdal
Obsidian | Level 7

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#n0r2de9vkep76bn1tjb5... 

 

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
1 ACCEPTED SOLUTION

Accepted Solutions
Sam_SAS
SAS Employee

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

View solution in original post

2 REPLIES 2
Madelyn_SAS
SAS Super FREQ

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. 

Sam_SAS
SAS Employee

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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 530 views
  • 2 likes
  • 3 in conversation