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
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
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!
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.