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
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.
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.
Thank you for the info. I think that I will be able to work with this to come up with a solution.
Thanks,
Ricky
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.