Is that possible to retrieve information from QMC Publisher into Qlikview?
I have the following scenarios:
I do appreciate your help.
I have already checked the Governance Dashboard, but it doesn't provide me the information I need.
I need to retrieve the user's assgned call list and each document my users have access to.
I've just checked the System Monitor app, and I couldn't find the information I need: "I need to retrieve the user's assgned call list and each document my users have access to.";
Is this information there?
Did you check the Log Details tab -> Session Log table, in the Gov Dashboard session information. You might need to tweak around the expressions to get the total cals and Last used dates. You might add additional information based on your local requirement.
You could use the PGO as XML setting in QlikView Server to output the contents of the PGO files (particularly the CalData.pgo file which holds the information you're looking for I believe) to an XML. You could then load the XML into QlikView.
Navigate to the Root Folder and you'll see the .pgo.xml files
Hope this helps
I've tested and it worked. The XML files was generated at "C:\ProgramData\QlikTech\Documents". I have three more questions:
Thank you in advance.
I've been receiving the following message when trying to reload the QVW file:
VX_CONNECT_ERROR: Could not connect to server: localhost
Error accessing Management Service.
Make sure you are in the 'QlikView Management API' group on the 'localhost' server! If the group doesn't exist you can create it, a logoff/login or a server restart may be required!
Authorization failed for user REDERECORD\rudrodrigues, required access level is QlikView Management API
CUSTOM CONNECT TO "Provider=QVSManager.exe;Server=localhost;Warnings=True;Debug=False;XUserId=UEeJBQC;XPassword=WTfGbTC;"
I suppose I have only to create the group QlikView Management API in the server and add my user in, alright?