topic Visual Analytics - No item selected error in SAS Visual Analytics

Visual Analytics - No item selected error

phopkinson — Mon, 04 Nov 2024 10:07:03 GMT

Hi all,

I have a SAS Visual Analytics report - however when I export to a PDF I am getting a issue with one page saying that no item has been selected and it doesn't display the data at all with the object being blank. This is despite it being in the appendix tables, and the correct parameter having been set.

Re: Visual Analytics - No item selected error

Madelyn_SAS — Mon, 04 Nov 2024 14:55:00 GMT

I'd like to gather a bit more information. Which version of SAS Visual Analytics are you using? I assume that the object is not blank at the time that you select to print. Can you please confirm that? Are there any other messages in the PDF? Can you send a screen shot of what you see for the object? What type of object is it?

Re: Visual Analytics - No item selected error

phopkinson — Mon, 04 Nov 2024 14:56:55 GMT

The object is not blank when I select to print, the object is a text box and bar chart - when i go to print the text says no item selected and the bar chart is blank. I can't share any screenshot I'm afraid.

Re: Visual Analytics - No item selected error

Madelyn_SAS — Mon, 04 Nov 2024 15:29:56 GMT

With a limited amount of detail, all I can say is that this issue can occur with report objects that display data items that are calculated from a parameter. Sometimes Visual Analytics fails to query the server for the results of the indirect calculation. If you are using any release of Visual Analytics on SAS 9.4, then you can look in the SASVisualAnalyticsTransport log, typically located at

/SAS-configuration-directory/Lev1/Web/Logs/SASServer12_1/SASVisualAnalyticsTransport7.x.log

If it contains an error similar to the following...

Error getting QueryRunner - java.lang.Exception: Missing expression parameter value while parsing :#{pr28} (Reason : InvalidInternalState)

Then, as a workaround, you can add a data source filter that references the parameter directly. For example, if your parameter is named Region Parameter, the expression might look like this:

( 'Region Parameter'p NotMissing ) OR ( 'Region Parameter'p Missing )

This filter does not limit the number of rows returned from the query because the condition is always true.

Re: Visual Analytics - No item selected error

phopkinson — Mon, 04 Nov 2024 15:53:40 GMT

I'm afraid that I have already applied a data filter using this exact method and it hasn't resolved this issue at all.

Re: Visual Analytics - No item selected error

phopkinson — Mon, 04 Nov 2024 16:10:36 GMT

The parameter is definitely what is causing the issue here as once it is removed - the text and bar chart both display on the output.