BookmarkSubscribeRSS Feed
Maicfelps
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


Thanks

1 REPLY 1
Mickey_SAS
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.

 

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

 

SAS Innovate 2025: Register Now

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!

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
  • 523 views
  • 0 likes
  • 2 in conversation