topic Re: Need help creating a dynamic list of html links to reports in a particular folder. in SAS Visual Analytics

Need help creating a dynamic list of html links to reports in a particular folder.

rgreen33 — Thu, 07 Dec 2017 15:30:03 GMT

In SAS Visual Analytics, I have a folder that contains 12+ reports that are all related. On each of these reports, I would like to create a tab that provides the user with a listing of the other reports in this folder (with HTML links). Has anyone done this? Or, does anyone have any ideas on how this could be done? I would like for this list to be dynamic (reading from the system) as new reports may be added in the future...and I don't want to have to update every single report. Obviously, one way to accomplish this would be to build a dataset and manually maintain the information in the dataset and read that into SAS VA report. However, I would like for this to be automated for my developers (and myself as I will be promoting any new reports from dev to prod). So, maybe something like a stored process or scheduled job that pulls the data from the system...but, how would I pull this info? Any ideas would be greatly appreciated.

Thanks,

Ricky

Re: Need help creating a dynamic list of html links to reports in a particular folder.

BrunoMueller — Thu, 07 Dec 2017 17:08:39 GMT

I suggest to use a Stored Process.

You can use the %MDSECDS() macro to get a list of all the reports like this:

%mdsecds(
  folder="/Shared Data"
  , includesubfolders=YES
  ,membertypes="Report.BI"
)

You then get a data set WORK.MDSECDS_OBJS with all the objects. with this you can build the link to call your report.

Using the Stored Process will take the permission of the individual user into account.

Re: Need help creating a dynamic list of html links to reports in a particular folder.

rgreen33 — Fri, 08 Dec 2017 20:15:01 GMT

Thank you for the info. I think that I will be able to work with this to come up with a solution.

Thanks,

Ricky