Skip to main content

Data Breakdown & Lineage Inspection

CellContext: detail/lineageA detailed popup forwindow triggered when inspecting a specific report cell or line item,item.

showing
its value,

Key format,Components & Elements:

    Header Details: Displays key metrics such as cell coordinates/identifiers, calculated numeric values, formatting types, and target row/column conditions,conditions.

    and

    SQL Queries Section: Outlines the underlying SQLdatabase queries executing against system data tables (specifically result_data_direct and result_data_bcl,).

    with

    Action Options: Includes action buttons such as "See breakdown" (to inspect underlying record details) and "Export to Excel".

    image (27).png

    Context: The granular drill-down view displayed after clicking "See breakdown".

      Key Components & Elements:

        Data Table/Grid: Shows the individual source records that aggregate into the parent report cell's total value.

        Columns: Displays source transaction attributes such as record IDs, source system flags, posting dates, amounts, and Excelaccount export options.
        codes.

        image (27).pngFiltering & Pagination Controls: Interfaces for filtering specific line items or sorting source records.

        image.png


        Context: A direct inspection view focused on data provenance and lineage flow.

          Key Components & Elements:

            Lineage Diagram / Mapping Structure: Visual representation tracing data from raw input tables down to calculated reporting output cells.

            SQL Preview Panel: Highlights code syntax and condition rules driving cross-table reconciliations.image.png