BookmarkSubscribeRSS Feed
DipuRahman
Calcite | Level 5

Hi All,

 

We have a requirement for VA reports to be rerun at a later time that will "remember" and load the previously selected value(s) from the user (based on some unique ID). What does that mean?

 

For example, there is a report that the user selects a car's make and model, and enters an unique ID for that report. Based on that selection, the report will be run. In this example,

Report ID: 123

Make: Acura

Model: 3 models selected as shown below.

DipuRahman_0-1701976681085.png

 

This runs the report and creates outputs. In addition, it updates a table in CAS:

DipuRahman_6-1701978107523.png

 

 

 

Request from the users:

The report also has a different section where the users can select a Report ID from the past:

DipuRahman_2-1701977432394.png

DipuRahman_3-1701977591335.png

And auto populate the previous selection.

 

So this is where I'm not sure what to do. If the user selects 123 for Report ID, I want the Make List control object to automatically select Acura, and the Model List control to automatically select the three Models (selected the first time):

DipuRahman_4-1701977781959.png

DipuRahman_5-1701977811106.png

 

Reason for request: If they want to go back to rerun a report that had 50 models selected, and this time not have to manually select 50 models again (or select 48 models from the original list). This will help reduce the selection time.

 

Is there anyway to use that CAS table with user selected values to do this?

 

Any input is appreciated!

Thanks!

 

Using SAS® Visual Analytics. Release: 8.5.2, 

SAS® Viya® release: V.03.05

1 REPLY 1
Renato_sas
SAS Employee

This is not possible with default VA control objects, but a DDC that implements an HTML form could be used to do it.

 

The DDC HTML would need to leverage CAS REST API to query the CAS table containing the desired report ID and pull the parameter settings from that report, supposedly stored in that CAS table. Because the custom HTML provides the prompts, you have the ability to manipulate them via JavaScript to pre-set the prompt values according to what had been saved.

 

I'm not saying it's simple, but it's definitely doable.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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
  • 1 reply
  • 648 views
  • 0 likes
  • 2 in conversation