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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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