How to check what objects/tables are linked to my LASR table

AK100 · Posted 07-02-2020 04:25 AM

I want to check what tables/objects are linked to my LASR table because it constantly prompts an error as soon as I open up the dashboard. I would like to delete the LASR table actually but i'm afraid there might be something linked to it...Is there a specific way to check this?

BrunoMueller · Posted 07-02-2020 05:41 AM

Have you tried the sas-relationship-reporter https://go.documentation.sas.com/?docsetId=bisag&docsetTarget=n02xw5d6g8m7v7n1shgdj8pf7vkf.htm&docse...

Here is an example output

PS D:\Program Files\SASPlatformObjectFramework\9.4\tools> .\sas-relationship-reporter -host someHost -port 80 -user someUid -password somePw -report impact "/Shared Data/Basics/LASR Data/PRODUCTS_CLEAN(Table)"
"/Shared Data/Basics/LASR Data/PRODUCTS_CLEAN" (Table)
  Impacts: "/Shared Data/Advanced/Demos/Solutions/VA2-Demo8.1a" (SAS report (2G))
  Impacts: "/Shared Data/Advanced/Demos/Solutions/VA2-Demo8.1b" (SAS report (2G))
  Impacts: "/Shared Data/Advanced/Demos/Solutions/VA2-Demo8.2" (SAS report (2G))
  Impacts: "/Shared Data/Advanced/Demos/Solutions/VA2-Demo9.1" (SAS report (2G))
  Impacts: "/Shared Data/Advanced/Demos/VA2-Demo8.1a" (SAS report (2G))
  Impacts: "/Shared Data/Advanced/Demos/VA2-Demo8.1b" (SAS report (2G))
  Impacts: "/Shared Data/Advanced/Demos/VA2-Demo8.2" (SAS report (2G))
  Impacts: "/Shared Data/Advanced/Demos/VA2-Demo9.1" (SAS report (2G))
  Impacts: "/Shared Data/Advanced/Practices/Solutions/VA2-Practice8.1" (SAS report (2G))
  Impacts: "/Shared Data/Advanced/Practices/Solutions/VA2-Practice8.2" (SAS report (2G))
  Impacts: "/Shared Data/Advanced/Practices/Solutions/VA2-Practice9.1" (SAS report (2G))
  Impacts: "/Shared Data/Advanced/Practices/VA2-Practice8.1" (SAS report (2G))
  Impacts: "/Shared Data/Advanced/Practices/VA2-Practice8.2" (SAS report (2G))
  Impacts: "/Shared Data/Advanced/Practices/VA2-Practice9.1" (SAS report (2G))
  Impacts: "/Shared Data/Basics/Product Report" (SAS report (2G))
  Impacts: "Table metadata update" (JobTransformation) - in "/Shared Data/Basics/LASR Data/PRODUCTS_CLEAN - Load Job Tue Jun 11 16:04:08 EDT 2019" (Job)
      Is contained by: "/Shared Data/Basics/LASR Data/PRODUCTS_CLEAN - Load Job Tue Jun 11 16:04:08 EDT 2019" (Job)