Load the Historical Data in Governance Dashboard

[dmohanty]

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 -

1. Converted the table into a QVD and added a Date Field to extract and store data into the QVD from today onwards on daily basis.
2. Loaded the table into the Model by removing the Hidden Script.

But not sure how to get the previous dates from the logs. Could someone please help me more on this -

1. What is the source for the Governance Dashboard?
2. How to read those historical data and bring into the model (can we edit our own script there)?
3. Mainly needed for 'Publisher Task "Last Run" Status' sheet

[Tyler_Waterfall]

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

[dmohanty]

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.

[Tyler_Waterfall]

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.

[dmohanty]

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.

[Tyler_Waterfall]

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).

[Tyler_Waterfall]

DMohanty‌ - The Governance Dashboard 2.0 has task reload history now. Wahoo!

You can find the beta version here:

[dmohanty]

Hey twa‌,

That's an awesome update.

I am excited in exploring the new changes in Governance Dashboard.

Thanks for the news.

Regards!