Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

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

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 80
Accepted Solution

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

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


Accepted Solutions
Solution
‎12-08-2017 03:15 PM
SAS Super FREQ
Posts: 831

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

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.

View solution in original post


All Replies
Solution
‎12-08-2017 03:15 PM
SAS Super FREQ
Posts: 831

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

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.

Frequent Contributor
Posts: 80

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

Posted in reply to Bruno_SAS

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

 

Thanks,

Ricky

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 202 views
  • 0 likes
  • 2 in conversation