qvd used for qvw

[#1]

hello guys

how could we can find out which qvd is used for which dashboard in a group of 25 qvds which were used in diff 7 qvws

thnaks in advance

[Chanty4u]

Hi,

Double click on Qvd file and open with notepad...

on 3rd or 4th line of that notepad file you will find creatordoc, which is the QVW file which generated respective qvd.

or

have a look at the tool QViewer. This enables you to read the metadata of a qvd including it's source.

hope this helps you.

suresh chanty

[Chanty4u]

hi,

or

Open the QVD with a Text Editor and in the first rows with Metadata you can find

<CreatorDoc>Pathtoqvw</CreatorDoc>

hope this helps you

suresh chanty

[Peter_Cammaert]

If I read your question correctly, you want to figure out which QVD's are used in your QVW documents.

There are two solutions to this:

1. DIY: Every QVW contains an XML header that documents various qualities of your QVW and its last reload. One of the pieces of informlation in this header is a list of the various tables that are used to build your data model. Both internal (RESIDENT, AUTOGENERATE, INLINE, ...) tables as well as external files are listed. Getting hold of this information is extremely simple, and you can use QlikView itself to monitor QlikView documents. Just do like this:
   - Create a new blank QVW.
   - In the load script, add a LOAD statement by clicking the Table Files button, navigating to one of your QVWs and opening it as XML (important!). The open table file view will list the various items in the XML header. Make sure that you load the LineageInfo table.
   - Reload this new document and display a list box for field Discriminator.
   - Discriminator lists all tables used as source in LOAD statements.
2. Advanced: install the Governance Dashboard and let it collect all this information for you. You will get a nice overview of sources used by your QVW's, and a lot more.

I attached a simple example document that lets you input the full path to an arbitrary QVW, click a reload button and view the list of source tables.

Best,

Peter