Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does someone know any way to parse the pgo files into a qlikview? Thanks
There is a diagnostic setting in QlikView Server that allows for the PGO files to be mirrored in XML format for debugging purposes. It is named "PgoAsXmlAlso" and it's value should be "1" if enabled. You can set this in the Settings.ini file for QVS, under the "Settings 7" node in QlikView Server 10 and 11.
You can't. But you can surely use QMS APIs to get information you are looking for. Search QMS API here in the forum and you will find some information. Also Power Tools would allow you to export some information you might be looking for.
There is a diagnostic setting in QlikView Server that allows for the PGO files to be mirrored in XML format for debugging purposes. It is named "PgoAsXmlAlso" and it's value should be "1" if enabled. You can set this in the Settings.ini file for QVS, under the "Settings 7" node in QlikView Server 10 and 11.
Interesting!!! Thanks Stefan.
What if we keep the setting active always? Any side effects or issues with keeping this setting active in production environment?
For data security purposes, and also performance, I would not recommend having this enabled in any environment over extended periods of time. It is a diagnostic easter-egg, not a feature.
Specifically in larger cluster environments where PGO operations needs to be instantaneous, this is very much not recommended.
Thanks Stefan.
How about reading Meta files? Any trick to that?
hi Stefan,
With lots of curoisty I tried the above method. but where does the xml file gets created. I am not able to find it
Deepak
They will be created and maintained in the QVS root - the main User Document folder for your QVS. Are you sure you created the setting correctly?
Settings.ini file example:
[Settings 7]
PGOAsXmlAlso=1
..more settings..
[Authentication]
..settings...
Rakesh Mehta wrote:
Thanks Stefan.
How about reading Meta files? Any trick to that?
Yes, but that has to be done with the SharedFileViewer, which is a part of the Power Tools for QlikView: http://community.qlik.com/docs/DOC-2649. Just note, that reading .meta files in this tool is kind of a "bonus", so never mind the red or pink markings on data in the file, as that does not apply to .meta files, only to .shared files.
Once you get the object list, double click IDs to see the data and venture deeper into the file.
Thanks Stefan
I made a mistake. I wrote PGOAsXmlAlso=1 at the end of the file. I changed it to the top and now its working fine.
Deepak