Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Need to load the historical data into the Governance Dashboard - mainly into the SessionTaskAuditMaster table to show the performances in the Previous Timestamps.
I followed one approach -
But not sure how to get the previous dates from the logs. Could someone please help me more on this -
You can get it from the StartTimeStamp:
StartTimeStamp="9/6/2015 10:42:03 PM"
which format is: M*/D*/CCYY H*12:MI:SS AM
You can read more about this on the help site: documentation.qlikview.com/governance-dashboard/1.1/QlikView_help.htm#Publisher_datetime_format.htm
Hi twa,
I was able to load the XML files into a QVW. However for the history there are no records somehow.
Is there something I am missing from my side?
Also, getting an error like this, when starting to load. Once clicking OK, it is running fine afterwards.
That's strange. I don't have any issue loading the xml file.
Could you create a new qvw and load the xml file manually and see what script is automatically generated? You should be able to modify that autogenerated script to load all files (*) and to add the additional date fields.
Hi twa,
OK. I simply changed like this and able to get these fields.
MonthName(StartTimeStamp) as [Task History Month],
Date(StartTimeStamp) as [Task History Date],
year(StartTimeStamp) as [Task History Year],
hour(StartTimeStamp) as [Task History Hour].
Now if I put this in UserConfig.txt and reload the Governance Dashboard, should I be able to get the historical data to be used?
I mean I am not sure how to link these History to the existing data model.
You need to be sure to have
TaskId as TaskID,
in that load script. That will be the link between the task history and the Task Name (and app name).
DMohanty - The Governance Dashboard 2.0 has task reload history now. Wahoo!
Hey twa,
That's an awesome update.
I am excited in exploring the new changes in Governance Dashboard.
Thanks for the news.
Regards!