Hello all. I have two tables in memory on the "Public LASR Analytic Server" that I want to use in one report object in SAS VA. I know that a report object can only reference a single data source. Since the tables are already in memory, I thought that I could join the tables and create a view instead of creating an output table and use the view as my data source for the report object. I've tried using Visual Data Builder in VA to create this view by creating a "New Data Query". Even though I select "Create an SQL Query View" on the Properties tab of the data builder, an output table is created instead of a view.
In my research of the problem, I found the following statement about the LASR Server:
Okay, so I guess I found the problem but is there a workaround? Can I save the view in a different library type where VA can consume the data? It looks like all of the tables that are currently being consumed by VA are on the "Public LASR Analytic Server" (except for EVDMLA). Thanks.
I now think the answer I gave in that post is incorrect, as it is quite clear you can't create views in a LASR library. You can create a view in a "normal SAS library" that references LASR tables, but you can't use a normal SAS library in a VA report.
I suggest you might want to re-think your problem. You can't display millions of rows in a VA list table anyway, the default maximum is less than 100K from memory.
We have summary reports that work off tables with 30M rows - that's why I asked how many rows is prohibitive for you.
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.