06-06-2018 07:24 AM
Hello SAS Community
I was wondering if anyone could help me with finding a solution for sharing parameters between reports on SAS VA (v7.3) in an automated way?
I want to avoid creating one very large dashboard because is slows down runtime of loading the dashboard and maintaining therefore I am currently creating a series of dashboards showing student qualification data and have links to each of the reports so users can flick between them soit seems like it is one report, and to help the user I have put some qualification/course filters in the report prompt section of the dashboard.
However because my dashboards are separate it means the user has to select the qualification/course in each dashboard, which is not the best user experience, therefore is there a way I can generate a link that carries the parameter(s) selected in the report prompt of one report and apply it to another.
I have been able to use the URL to the report and manually add the parameter e.g. "&award_Qual_Filter=B01" (without the quotes) and this works however I am struggling to get it to work in an automated way.
I have looked at the following documentation
http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#n0avi8j19qgkkun1q5znm... but when I try to create an external link I am unable to add a new parameter, the + symbol is grayed out, yet in the documentation is indicates it should be blue and can be used, however I'm not sure this would work either because I don't know if I can populate the "add new parameter" with a parameter field, acting like a macro variable.
Would a stored process be able to create an automated redirect URL?
Any advice would be gratefully received.
06-07-2018 04:14 AM
I don't think the link in text object really work with parameters ?!
You can do almost the same with a tile chart.
Create one dummy category with one value (in my case "DoubleClick me!") and assign it to the chart.
Then create the interaction to the second report and do not mark the check box.
Worked for me!