Materialized view

[mohd-danshaik]

Can qlikview access SAS SPDS materialized views or would we have to create a SAS SPDS table for the same? What would be faster a materialized view or creating a table?

[s_lassen]

I assume that when you access data from an SPDS server, this is done not by reading the physical file, but by connecting with the server and have it deliver the data. So I guess that you can access both materialized views and normal views from the server.

[mohd-danshaik]

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?

[s_lassen]

Yes, that is the way things normally work with material views - unless you make changes to the underlying tables, then the view will run more slowly.

Is your problem that creating the view takes a lot of time, or is it that the access to it takes a lot of time? In the latter case, the problem may be that some of the underlying tables were updated after the materialized view had been created. Depends on the setting on the server (and what kind of server you are using, e.g. Oracle and MS SQL also have materialized views), but often the materialized view is not updated until you access it, unless you update the view explicitly. You will have to look that up in the SPDS documentation.

[mohd-danshaik]

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?

[LinusH]

My first thought is to access SPDS via ODBC, not via "SAS" if I understand what you have tried correctly.