Background: I have made a "metadata solution" that serves some main areas/needs in our organization 1. Give business analyst and data scientists etc. overview and fast access to all data and visualisation on our Viya solution 2. show relationship(data lineage) from visualisation(reports/analysis) to CAS tables, Users and data elements(columns) 3. Keep track of report usage, table/files usage and table usage and column changes on cas tables. 4. To be continued.... https://developer.sas.com/apis/rest/Visualization/ The solution uses the rest API and some other SAS function to collect this data a I have built a visual analytics dashboard/report with search option for all metadata elements. To get control over all our business data and insight is something we have been looking for many years now. Finally we are getting somewhere with this problem. I believe many organisations have the same issue. Question: I am trying to find the report summary/description element in the rest api and data columns that are in use in a report. Has anyone looked into this? I can list out all kinds of details about a report, graphs, tables, calculated elements, sections, columns available(in datasource) etc. but not summary text or used columns... Get report content metadata: PROC HTTP clear_cache METHOD = "GET" oauth_bearer=sas_services OUT = rcontent URL = "&BASE_URI/reports/reports/&id/content"; HEADERS "Accept" = "application/vnd.sas.report.content+json"; RUN; The rcontent libname have n number of tables with all kinds of report metadata but still haven´t found what I´m looking for:-)
... View more
