SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 66406: The SAS® Visual Analytics crosstab displays no data when you use hierarchies and filters

DetailsHotfixAboutRate It

A crosstab does not display data when you complete the following steps:

  1. You Expand All on a hierarchy level.
  2. You collapse a single member of the currently expanded all level.
  3. You apply a filter on another member of the hierarchy that was not collapsed.

Here is an example that would trigger this issue:

  1. Click Expand All on the DriveTrain level:

drivetrain

  1. Click the down arrow to collapse Front:

collapse front

  1. On the button bar, select Rear as the filter:

filter on rear


After you complete these steps, the hierarchy levels and the data are not displayed.

To work around the issue, complete these steps:

  1. Change the filter so that all the members are displayed.
  2. Fully expand each level (In this example, fully expand Front).
  3. At this point, you can then change the filter selection. 

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Visual Analytics (on SAS Viya)Cloud Foundry8.58.5.1ViyaViya
Linux for x648.58.5.1ViyaViya
Microsoft® Windows® for x648.58.5.1ViyaViya
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.