Data not displaying in SAS Visual Analytics 7.3 Crosstab visualization for 2650 rows and 31 columns

[S_hanjagimath]

Hi,

I created Crosstab visualization in SAS VA 7.3 with 2650 rows and 31 columns and getting the error message as "Too much data to Display".

How should I solve this problem. As per the documentation croostab can hold up to 40000 rows.

Any idea how should I resolve this problem

[Madelyn_SAS]

You are likely running into a midtier limit on cardinality for crosstabs. According to the Visual Analytics administration documentation, the middle-tier maximum cardinality threshold for crosstabs is 50,000 unique values (not the maximum volume of data). Does the table include high-cardinality data items? You can sometimes work around this by changing the roles for some of your categories from rows to columns or vice versa.