QVW Metadata - hides the sheet name for objects inside containers

[Anonymous]

Hi All

I am a 7 months QV Developer and have a requirement to audit the occurance of customer sensitive data in my inherited library of QV Apps. I have found the QVW Metatdata very useful and can create  a table of filename, sheet name, table name, field (expression or dimension), definition etc. and I can string search the definitions for customer data fields . So far so good.

However I find that when tables have been placed into containers only the container object is listed in the metadata table

[DocumentSummary/Sheet/ChildObjects/ObjectId]  and this seems to be the only place where you can link to

[DocumentSummary/Sheet] to get the sheet name

I have also not been able to find in Metadata any connection between the tables and their container

So for all those tables that are in containers the best I can do is indicate that they are in the QVW and on one of many possible sheets that have container objects. But it would be better to be able to pin this down to the exact correct sheet as containers are frequently used here.

I wondered if anyone else tried this and found a workaround?

On a old version of QlikView 11.20.13206.0 SR13 64 bit Edition

Many thanks, Clare

[rwunderlich]

Where are you getting the metadata?  Are you loading the QVW directly or using -prj folders?

-Rob

[Anonymous]

Hi Rob

I borrowed the same script that Governance Dashboard uses. Here is the basic script using one named QVW

When implemented I would loop through all the QVW’s from a list of those that are in active use

Object:

LOAD

'Z:\QlikViewR2\Ops\Depots\Depot Scorecard.qvw|'&ObjectId%Table as objectId,

'Z:\QlikViewR2\Ops\Depots\Depot Scorecard.qvw|'&%Key_Sheet_A4D568A6CD8BD40A as sheetMap

FROM Z:\QlikViewR2\Ops\Depots\Depot Scorecard.qvw (XmlSimple, Table is );

Sheet:

LOAD

'Z:\QlikViewR2\Ops\Depots\Depot Scorecard.qvw|'&%Key_Sheet_A4D568A6CD8BD40A as sheetMap,

SheetId & ': ' & Title as sheet

FROM Z:\QlikViewR2\Ops\Depots\Depot Scorecard.qvw (XmlSimple, Table is );

SheetObject: //All sheet objects but sheet not identified in this table – useful to get the caption and type though

LOAD

ObjectId as ObjectId2,

Caption,

Type,

Field,

Text,

%Key_DocumentSummary_3E3ED09C8BC69525 // Key to parent table: DocumentSummary

FROM Z:\QlikViewR2\Ops\Depots\Depot Scorecard.qvw (XmlSimple, Table is );

And I ‘see’ the available tables in the qvw metadata through this screen when do a load of table files in editor

The data has gaps for sheet as below

Because Objects like CH360 and CH363 are not in the table but the containers they sit in are.

I do not know what ‘using the –prj folders’ means

Thanks for helping, Clare

<http://www.flogas.co.uk>[Safety First]<http://>

Clare Freeman

Senior Business Intelligence Developer

www.flogas.co.uk<http://www.flogas.co.uk>

please don't print this e-mail unless you really need to.

This electronic message contains information from Flogas Britain Ltd, which may be privileged or confidential. The information is intended for use only by the individual(s) or entity name above. If you are not the intended recipient, be aware that any disclosure, copying distribution or use of the contents of this information is strictly prohibited. Activity and use of the Flogas Britain Ltd e-mail system is monitored to secure its effective operation and for other lawful business purposes. Communications using this system will also be monitored and may be recorded to secure effective operation and for other lawful business purposes.

This message has not been encrypted. It may therefore be liable to compromise. It is your responsibility to scan this message for viruses. Viruses and compromises of security are inherent risks in relation to email. To the extent permitted by law we do not accept any liability for any virus infection and/or external compromise of security in relation to transmissions by email.

Any personal views expressed in this message are not necessarily the views of Flogas Britain Ltd, its members or employees. Please note that contracts may NOT be concluded on behalf of Flogas Britain Ltd by email.

Flogas Britain is a limited company registered in England with registered number 993638.

The registered office of Flogas Britain is Rayns Way, Watermead Business Park, Syston, Leicester LE7 1PF.

[rwunderlich]

I can't speak to the script that Governance dashboard uses, but I've always had difficulty getting a through analysis using just the QVW XML.  As an alternative, you might want to try the Document Analyzer tool which I know handles container objects fine.  If you want to analyze multiple QVWs in a single go, use the DABatch script to analyze all QVWs in a directory.  Then load the result QVDs -- see the DACOmpareTool.qvw for an example -- and build your analysis from that data.

All the utilities I referenced above can be downloaded in the zip file here:

Qlikview Cookbook: QV Document Analyzer http://qlikviewcookbook.com/recipes/download-info/document-analyzer/

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[marcus_sommer]

Another way might be to read the document layout of a qvw which could be exported per menu: file-->export-->document layout or per macro which creates also a xml-file with a similar structure like the xml-header of a qvw.

- Marcus

[rwunderlich]

Marcus is suggesting the -prj folders (document layout is same form) I mentioned earlier.  The Sheet->Object and Container->Object mapping is in the QlikviewProject.xml file.

If you want to go that route you can generate the -prj files in batch using this tool:

Qlikview Cookbook: Prj Tool http://qlikviewcookbook.com/recipes/download-info/prj-tool/

-Rob