topic Hello everyone, How can we resolve this issue and display all the values in the table? Thanks in SAS Visual Analytics

Hello everyone, How can we resolve this issue and display all the values in the table? Thanks

Naiii — Tue, 10 Sep 2024 10:51:26 GMT

Re: Hello everyone, How can we resolve this issue and display all the values in the table? Thanks

TSBruce — Tue, 10 Sep 2024 12:06:03 GMT

You are most likely running into a constraint and may need to increase some of these values. You can find documentation on this at https://sas.service-now.com/csm?id=kb_article_view&sysparm_article=KB0036315. If this article is not helpful, I would suggest opening a Technical Support case.

Re: Hello everyone, How can we resolve this issue and display all the values in the table? Thanks

Madelyn_SAS — Tue, 10 Sep 2024 20:43:25 GMT

Besides reviewing what @TSBruce sent, I was wondering which version you are using, and how many rows you are expecting to display. Your table has only 2 categories and a measure. If you select the table and then look at the Options tab, do you see a value specified for Override system data limit? Are either of those categories stored as VARCHAR and/or are they very long (i.e., thousands of characters)?

Re: Hello everyone, How can we resolve this issue and display all the values in the table? Thanks

Naiii — Wed, 11 Sep 2024 14:18:00 GMT

J'ai un tableau croisé ici, c'est un simple exemple. Le problème, c'est que lorsque j'ajoute un champ avec des valeurs distinctes (1 441 053), rien ne s'affiche et le message suivant apparaît : Aucune donnée n'apparaît car trop de valeurs ont été renvoyées par la requête. Filtrez vos données pour réduire le nombre de valeurs

Re: Hello everyone, How can we resolve this issue and display all the values in the table? Thanks

Madelyn_SAS — Wed, 11 Sep 2024 14:47:32 GMT

Would you be willing to create a SAS Technical Support case for this so that we can help further? The best way is to log in with your customer profile and provide the necessary information such as site number, product, and version.

Customer Support Center