BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
rgreen33
Pyrite | Level 9

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

1 ACCEPTED SOLUTION

Accepted Solutions
BrunoMueller
SAS Super FREQ

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

2 REPLIES 2
BrunoMueller
SAS Super FREQ

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
Pyrite | Level 9

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

 

Thanks,

Ricky

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
  • 2 replies
  • 1122 views
  • 0 likes
  • 2 in conversation