Struggling to find databases views used in qlikview dashboard

[Anonymous]

Hi all,

Our qlikview reports using some other systems (business and billing) data to display in dashboards such as views, tables etc.

Still couldnot understand and find those tables, views in  BI reports. you help is highly appreciated.

Thanks

[Gysbert_Wassenaar]

You'll have to look at the load script of the Qlikview document to find out where the source data came from. Once the data is loaded into the Qlikview document the charts use the internal data model directly. The charts won't connect to database views. 

[Anonymous]

Good explanation, but I found the source document that would reflect on the charts, the question now, where are the views that used to get data from other database. Thanks

[Gysbert_Wassenaar]

As I said the load script is where you can find the statements that load the data from the sources. If there are database views used then you should be able to find the SQL Select statements that use them. Possibly you're looking at the final dashboard document that does not load data from database sources but from another qlikview document or from qvd files. In that case you'll have to look at the load script of that other document or the document that created the qvd files.