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

[rgreen33]

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

[BrunoMueller · Accepted solution]

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.

[rgreen33]

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

Thanks,

Ricky