Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA Autload Location in Meta Data Folder Structure

Accepted Solution Solved
Reply
Contributor
Posts: 50
Accepted Solution

SAS VA Autload Location in Meta Data Folder Structure

Hi,

 

I just set up autoload in VA. I followed this guide: https://blogs.sas.com/content/sgf/2016/04/04/sas-visual-analytics-autoload-configuration-made-easy/

 

I can put tables into folders and they will be loaded into my Public LASR Library. So far so good, but the table is put in the wrong metadata folder.

 

How do I control the folder location?

 

I marked the table in yellow and it should be put in the red underlined folder.

 

Thanks and regards

DirLASR.JPG


Accepted Solutions
Solution
‎11-22-2017 05:37 AM
Trusted Advisor
Posts: 1,852

Re: SAS VA Autload Location in Meta Data Folder Structure

Hello @dirks,

 

On the library properties (SAS Management Console) you can go to the Extended Attributes tab, and the VA.Default.MetadataFolder.

 

If you change this folder and restart LASR, and then trigger AutoLoad, it should autoload new tables in the new Metadata folder you have set up.

View solution in original post


All Replies
Solution
‎11-22-2017 05:37 AM
Trusted Advisor
Posts: 1,852

Re: SAS VA Autload Location in Meta Data Folder Structure

Hello @dirks,

 

On the library properties (SAS Management Console) you can go to the Extended Attributes tab, and the VA.Default.MetadataFolder.

 

If you change this folder and restart LASR, and then trigger AutoLoad, it should autoload new tables in the new Metadata folder you have set up.

Contributor
Posts: 50

Re: SAS VA Autload Location in Meta Data Folder Structure

Posted in reply to JuanS_OCS

Hello Juan,

 

thank you!

 

Does that mean I would have to create a Library for each set of tables?

 

I have got all my tables in the VA Public LASR Library and under there I have different folder locations for each report/data mart.

 

lasr2.JPG

Trusted Advisor
Posts: 1,852

Re: SAS VA Autload Location in Meta Data Folder Structure

Hey @dirks!

 

yes, for that kind of structure, I would recommend you either create different autoload folders for each metadata folder you need or either nto to use autoload, but use sas procedures/code to load the tables on the folders you need.

Contributor
Posts: 50

Re: SAS VA Autload Location in Meta Data Folder Structure

Posted in reply to JuanS_OCS

JuanS_OCS wrote:

Hey @dirks!

 

yes, for that kind of structure, I would recommend you either create different autoload folders for each metadata folder you need or either nto to use autoload, but use sas procedures/code to load the tables on the folders you need.


Juan,

isn't the autoload only per Library? Where do I tell it to use a different metadatafolder? Do you know a guide on how to autoload with procedures or code?

 

Thanks!

Trusted Advisor
Posts: 1,852

Re: SAS VA Autload Location in Meta Data Folder Structure

[ Edited ]

Indeed, mantra:

 

1 autoload folder == 1 autoload SAS library == 1 Autload Metadata folder

 

If you know how to program SAS, it is quite easy what you mention. And if not, I would recommend you to get on-board a SAS programmer.

Contributor
Posts: 50

Re: SAS VA Autload Location in Meta Data Folder Structure

Posted in reply to JuanS_OCS

Got it! Thanks a lot!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 325 views
  • 1 like
  • 2 in conversation