Qlik is not able to access the materialized views that we have created in the SAS Spds. It could be due to the fact that qlik doesn't run queries to extract data in SAS SPDS. It only reads the data from SAS tables in qlik. Similar to an implicit sql pass thru where the query is not run in the database. And as materialized views need to be accessed through database queries, qlik is not able to read data. Thoughts? ... View more

Thanks lassen. I have tried to create the materialized views in SAS DI. But when I open the materialized view I found that it taking the same time to open as the normal view. Is it that it will take time once and after that it will open quickly since it holds the output in a temporary table? ... View more

Hi Pablo, Can you please post a screen shot of what you are trying to do? ... View more

Hi Allan, Thanks a lot for your response. We do not have the Data Lineage exploration available to us. So that is why we are probably trying to get it done with code or some combination of Code plus VA exploration. ... View more

Hi Rama_V, Thanks a lot for your inputs. This could be really helpful. I had thought of a similar way of extracting meta info and then representing them in SAS VA. Will implement the same and keep you posted if it works ... View more

Hi Guys, I am also currently working on a case study where in I need to extract the impact analysis details for any given table in SAS DI.   My question is pretty similar to the original question in this post but I would only want to check the data lineage for any given source table using SAS code.   I am currently using SAS 9.4 ... View more