SAS VA sas-relationship-reporter

Maicfelps — Sun, 26 Mar 2023 17:35:16 GMT

I am running the following command on SAS Mid Tier

/sas-relationship-loader -host xx.xxxx -port xxxx -user xxxx -password xxxxx -protocol https "/BIP Tree/ReportStudio/Maps/"

It says it returned the following message

INFO Processed 1,119 total relationships for 42 objects.

In which directory and file did he write this?

I'm expecting a file output with all the relationships that the reports have, for example, report A uses tables C, D and E

Thanks

Re: SAS VA sas-relationship-reporter

Mickey_SAS — Fri, 31 Mar 2023 14:40:24 GMT

The sas-relationship-reporter is just creating data in the database on the server. I think by default it is consumed by SAS Lineage.

https://go.documentation.sas.com/doc/en/bicdc/9.4/bisag/n1j47pnoqq6apsn18q273ds2z5vl.htm

However, it sounds like you are primarily interested in your Visual Analytics reports and the tables they use. I might suggest as an alternative that you look into using the VA Administrative reports. It has a report specifically for report relationships, that leverages the same functionality as sas-relationship-reporter behind the scenes to generate relationship data, load it into LASR, and then even provides a predefined report for you to look at this data in Visual Analytics. You can read about that here.

https://go.documentation.sas.com/doc/en/vacdc/7.5/vaag/p1g2jx1snw4s2on1gwmniie7dctj.htm

topic Re: SAS VA sas-relationship-reporter in SAS Visual Analytics

SAS VA sas-relationship-reporter

Re: SAS VA sas-relationship-reporter