Possible to Blend Data Sources in a SAS VA 7.5 existing report?

pkrause — Tue, 16 Mar 2021 14:53:16 GMT

Hello, I know there are a handful of topics related but I'm not seeing what I need. I'm wondering if it's possible to blend or join multiple data sources within a report (without creating a star schema)? To set this up a bit further, I have a number of existing reports that now need a couple fields added from recently created corporate tables. These sources contain common fields I can use as a key, thus, I hoped to make a simple join within the report without creating a new data source as I have done in Tableau in the past.

I have added a data source and setup the relationship between the sources, however, I am not able to add data from both sources onto the same crosstab or use one source as a filter for the other.

Can this be done?

Thanks in advance!

Re: Possible to Blend Data Sources in a SAS VA 7.5 existing report?

SASKiwi — Tue, 16 Mar 2021 19:29:59 GMT

I'm pretty sure this is possible in SAS VA on Viya as you can create views on table joins. In SAS VA 7.5 I don't think views are supported so you are probably better off adding the required fields to the existing data source prior to loading into VA.

topic Re: Possible to Blend Data Sources in a SAS VA 7.5 existing report? in SAS Visual Analytics

Possible to Blend Data Sources in a SAS VA 7.5 existing report?

Re: Possible to Blend Data Sources in a SAS VA 7.5 existing report?