DIS Workbook Import Validation

Description

Categories
Enginatics
Repository
GitHub
Discoverer workbook migration validation report showing every workbook and worksheet next to its conversion state: whether the workbook xml is uploaded, selected for conversion or converted, the object use key derived from the workbook xml, and the migrated Blitz report and template.

Workbooks known only from the end user layer and workbooks whose xml was uploaded after deletion from Discoverer are both listed, so gaps in either direction are visible. The Not yet imported parameter restricts to worksheets without a migrated template.

The Accessed after parameter restricts the output to workbooks with recorded usage since that date, the same scope the DIS Workbook Export Script lists for export; left blank, every workbook is shown including those never accessed. The usage statistics columns show access count, last accessed date and user within the same window.

SQL 93 lines

Parameters 5

ParameterTypeList of values SQL
WorkbookLOV
y.workbook=:workbook
Accessed afterDate
eqs.qs_created_date>=:accessed_after
Workbook OwnerLOV
xxen_util.dis_user_name(y.doc_eu_id,:eul,'N')=:doc_owner
Not yet importedLOV
xrtv.template_name is null
End User LayerLOV
<parameter_value>