topic Re: How to use EG dataset to Visual analytics in SAS Visual Analytics

How to use EG dataset to Visual analytics

yhuang — Thu, 31 Mar 2016 21:06:25 GMT

Hi guys,

I was wondering if there is a way to use what EG generated dataset and apply it to VA for reporting purpose. In my situation, I would like use EG as data management tool to build lots of queries and filters to generate a dataset that ready to report, and the next step would be use this perfectly organized data to report on VA (Since VA has so many cool reporting tools).

Some other info, the EG and VA are installed in two different servers, my initial idea would be, using task scheduler in EG to generate new data every day, the BIG problem is, how do I link those data I created to VA? and I would want automate this process to make sure the report I builid in VA are reflecting the most recent data.

Thanks

Re: How to use EG dataset to Visual analytics

JuanS_OCS — Sat, 02 Apr 2016 20:45:43 GMT

Hi,

you can load any SAS table (which cames from EG or not) into SAS VA on different ways:

- use the Auto Load functionality: really easy, just drop the table in a shared location and after some time it will be automatically loaded into VA. Really nice.

- If you drop the table on any location reachable by SAS VA, you can load the table through the query builder, which can be automated through scheduling.

- You can also load the table manually through the interface, if you have the correct authorizations.

You can see additional information and details on: http://blogs.sas.com/content/sgf/2014/05/07/sas-visual-analytics-loading-data-into-memory/

Additionally, since EG 7.1, there are new functionalities to manually load a SAS table into SAS VA. Please read this wonderful post: http://bi-notes.com/2015/10/oh-snap-upload-data-to-the-lasr-server-just-like-that/

Re: How to use EG dataset to Visual analytics

jb9977 — Tue, 24 Oct 2017 21:46:45 GMT

Hi Yhuang,

Were you able to resolve the issue? Currently I am in the same situation as you were.

Thanks

Re: How to use EG dataset to Visual analytics

itchyeyeballs — Thu, 26 Oct 2017 15:52:00 GMT

We find the simplest way is to use the tip in the last link posted by JuanS. Right click on the data source and select upload to LASR. This becomes part of your process flow and bypasses any additional work or steps if you have already done all the work in EG.

You can then just schedule the process flow (ideally do this on your server so its not dependent on a specific PC) and it will refresh when needed

Having it in the process flow gives you a nice visual so you can see whats happening and when, like this