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.
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/
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
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.