Skip to content

DESCRIPTION.md

Latest commit

 

History

History
18 lines (13 loc) · 1.28 KB

DESCRIPTION.md

File metadata and controls

18 lines (13 loc) · 1.28 KB

Case Study & Technical Analysis

Abstract

The DIS Migration identify missing EulConditions report is a specialized quality assurance tool for the Discoverer-to-Blitz Report migration process. In Discoverer, administrators can define "mandatory conditions" at the folder level (e.g., ORG_ID = 101) that are silently appended to every query using that folder. If these conditions are lost during migration, users might inadvertently access data they shouldn't see.

Technical Analysis

Core Logic

  • XML Parsing: The report parses the exported Discoverer XML (.eex files) stored in XXEN_DISCOVERER_WORKBOOK_XMLS.
  • Gap Analysis: It compares the conditions found in the XML against the converted SQL in Blitz Report to ensure that folder-level filters were correctly carried over.

Key Tables

  • XXEN_DISCOVERER_WORKBOOK_XMLS: A staging table holding the raw XML export of Discoverer workbooks.
  • XMLTABLE: Used to query the XML structure directly within the database.

Operational Use Cases

  • Security Validation: Ensuring that mandatory security filters (like Multi-Org access control) are preserved.
  • Data Integrity: Preventing "cartesian product" reports caused by missing join conditions that were defined as folder conditions.