qvd_files and their origin

[datanibbler]

Hi,

I find quite often that it is somewhat challenging to backtrack a KPI - if the data in the QlikView_database comes from a qvd_file, then the question is which QlikView_app created that qvd. That is somewhat hit_and_miss.

Therefore I wonder: Would it be possible to pass some parameter to a qvd that another app can read that would contain some information on what app created that qvd?

Thanks a lot!

Best regards,

DataNibbler

[Gysbert_Wassenaar]

Every qvd file contains an xml header. You can load the qvd file as an xml file. One of the tags contains the app name that created the qvd. Another interesting bit is the LineageInfo which tells you where the data came from. In the case that data was retrieved from a database you'll find the sql statement and some information about the odbc/oledb connection.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<QvdTableHeader>

   <QvBuildNo>12347</QvBuildNo>

   <CreatorDoc>D:\QVdata\temp\qvd_gen.qvw</CreatorDoc>

   <CreateUtcTime>2014-06-15 15:51:59</CreateUtcTime>

   <SourceCreateUtcTime></SourceCreateUtcTime>

   <SourceFileUtcTime></SourceFileUtcTime>

   <SourceFileSize>-1</SourceFileSize>

   <StaleUtcTime></StaleUtcTime>

...table and field info intermezzo...

   <Compression></Compression>

   <RecordByteSize>35</RecordByteSize>

   <NoOfRecords>41353</NoOfRecords>

   <Offset>2131272</Offset>

   <Length>1447355</Length>

   <Lineage>

     <LineageInfo>

       <Discriminator>D:\QVdata\temp\comm122024.qvw</Discriminator>

       <Statement>Binary</Statement>

     </LineageInfo>

     <LineageInfo>

       <Discriminator>STORE - [AllINK.qvd] (qvd)</Discriminator>

       <Statement></Statement>

     </LineageInfo>

   </Lineage>

   <Comment></Comment>

</QvdTableHeader>

[datanibbler]

Hi Gysbert,

that sounds really cool.

How can I do that? By changing the extension to .xml, that doesn't work.

Do I need some xml_viewer? That's an issue as everything that has to be installed has to be approved by IT ...

[Gysbert_Wassenaar · Accepted solution]

Use Qlikview. Simply use the qvd as a file source, but choose XML as file type.

[#5]

Thank you Sir for that information, very helpfull

[datanibbler]

Perfect!

Thanks a lot!

[Peter_Cammaert]

I think the Governance Dashboard is a specialist in reading stuff like that. Have a look at The QlikView Governance Dashboard | Qlik

[Arindam_Ghoshal_13]

Hi Gysbert_Wassenaar,

Do we have any way to find qvd origin in Qlik Sense without using QlikView.

Any suggestions are always welcome.