Skip to content
FDE BI Evidence Workbenchobserved → compared → decided → scoped

Open questions

What the model still wants answered

Raised while comparing this input with current gold. Most are questions for the client rather than for the estate.

  • Which report page or audience should own the control view?

    Provide a monthly close-control view identifying unapproved manual adjustments before reporting-pack sign-off

  • What exact event and timestamp define reporting-pack sign-off?

    Provide a monthly close-control view identifying unapproved manual adjustments before reporting-pack sign-off

  • How is a manual adjustment identified: JournalSource, IsAdjustment, or a combination?

    Provide a monthly close-control view identifying unapproved manual adjustments before reporting-pack sign-off

  • Who is authorised to provide consultant confirmation?

    Obtain consultant confirmation that approved adjustments are excluded from the exception value

  • What test cases will demonstrate exclusion of approved adjustments?

    Obtain consultant confirmation that approved adjustments are excluded from the exception value

  • Must confirmation be recorded in a test script, deployment approval, or governance register?

    Obtain consultant confirmation that approved adjustments are excluded from the exception value

  • Is JournalSource approved for addition to the target semantic model?

    Expose Ledger.JournalSource

  • What source values constitute manual journals?

    Expose Ledger.JournalSource

  • Who owns value-domain governance and mapping changes?

    Expose Ledger.JournalSource

  • Is ApprovalStatus approved for addition to the semantic model?

    Expose Ledger.ApprovalStatus

  • What is the authoritative status domain and case handling?

    Expose Ledger.ApprovalStatus

  • Is status captured as current state or as-of close cut-off?

    Expose Ledger.ApprovalStatus

  • Should this be a new explicit DAX measure in Metrics?

    Expose Metrics.Unapproved Adjustment Value

  • What currency and formatting rules apply?

    Expose Metrics.Unapproved Adjustment Value

  • Must the measure respond to all account and calendar filters?

    Expose Metrics.Unapproved Adjustment Value

  • What column or composite key uniquely identifies a ledger entry?

    Preserve JournalSource and ApprovalStatus at ledger-entry grain

  • Can one ledger entry have multiple approval history rows?

    Preserve JournalSource and ApprovalStatus at ledger-entry grain

  • Will ingestion deduplicate, aggregate, or otherwise change source grain?

    Preserve JournalSource and ApprovalStatus at ledger-entry grain

  • Does 'sum the absolute value' mean SUMX over ABS(SignedAmount) per qualifying entry?

    Calculate the exception measure as the sum of absolute adjustment-entry values where approval status is not approved

  • Does 'not approved' include blank, pending, rejected, cancelled, or unknown statuses?

    Calculate the exception measure as the sum of absolute adjustment-entry values where approval status is not approved

  • Should reversals and duplicate adjustment entries be handled specially?

    Calculate the exception measure as the sum of absolute adjustment-entry values where approval status is not approved

  • What is the authoritative ledger-entry identifier?

    Retain drill-through to the original ledger entry

  • Should drill-through remain inside Power BI or deep-link to the finance system?

    Retain drill-through to the original ledger entry

  • Which entry attributes may be displayed, considering access and sensitivity?

    Retain drill-through to the original ledger entry

  • Which export, version, and owner are authoritative?

    Reconcile acceptance to the governed ledger export for a closed month

  • Which closed month will be used for acceptance?

    Reconcile acceptance to the governed ledger export for a closed month

  • Must reconciliation cover row counts, qualifying entry IDs, values, or all three?

    Reconcile acceptance to the governed ledger export for a closed month

  • What tolerance and sign-off evidence are required?

    Reconcile acceptance to the governed ledger export for a closed month

  • Is an approval late when it occurs after month end, close lock, export extraction, refresh, or pack sign-off?

    Create an explicit definition of late approvals

  • Should late approvals restate the closed-month result or remain visible as subsequent changes?

    Create an explicit definition of late approvals

  • Which timestamp and time zone are authoritative?

    Create an explicit definition of late approvals