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

AK100 — Thu, 02 Jul 2020 08:25:49 GMT

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?

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

BrunoMueller — Thu, 02 Jul 2020 09:41:54 GMT

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

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)

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

AK100 — Thu, 02 Jul 2020 09:59:26 GMT

How does that work?

topic How to check what objects/tables are linked to my LASR table in SAS Visual Analytics

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

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

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

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