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

How to use EG dataset to Visual analytics

Reply
New Contributor
Posts: 4

How to use EG dataset to Visual analytics

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

Trusted Advisor
Posts: 1,839

Re: How to use EG dataset to Visual analytics

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/

Contributor
Posts: 20

Re: How to use EG dataset to Visual analytics

Hi Yhuang,

 

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

 

 

 

Thanks

Frequent Contributor
Posts: 131

Re: How to use EG dataset to Visual analytics

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

 

Capture.GIF

 

 

 

Ask a Question
Discussion stats
  • 3 replies
  • 708 views
  • 2 likes
  • 4 in conversation