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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.