BookmarkSubscribeRSS Feed
Calcite | Level 5

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


SAS Employee

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


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.




SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.

Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!

Submit your idea!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 1 reply
  • 2 in conversation