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.

  • Should the AccountType business definition and permitted domain explicitly include Asset, Liability and Equity as shown by the representative chart of accounts?

    Account.AccountType column (String)

  • Confirm that current DateKey values follow the requested YYYYMMDD encoding; current gold establishes the object and type but not value-level conformance.

    Calendar.DateKey column (Int64)

  • Should `Calendar.FiscalMonth` be changed from Summarise by Sum to Summarise by None?

    Calendar.FiscalMonth column (Int64)

  • Confirm that the current model uses July as fiscal month 1, as illustrated by the workbook formulas.

    Calendar.FiscalMonth column (Int64)

  • Confirm that the current column is consistently expressed in the required reporting currency and reporting-sign convention.

    Ledger.SignedAmount column (Decimal)

  • Confirm the operational rule used to classify late or manual postings as adjustments; the object and type are observed but value-level business logic is not.

    Ledger.IsAdjustment column (Boolean)

  • Does the production DAX implement Actual Revenue plus signed expense balances with the intended account classification and filter context?

    Metrics.Actual Net measure (Decimal)

  • What production account-classification rule should Actual Revenue use, and does the current DAX implement it?

    Metrics.Actual Revenue measure (Decimal)

  • What is the production budget source and grain, and does the current Budget Net DAX implement the intended budget revenue-plus-expenses logic?

    Metrics.Budget Net measure (Decimal)

  • Confirm that current DAX is `Actual Net - Budget Net` and that favourable-positive sign behaviour is preserved across report contexts.

    Metrics.Net Variance measure (Decimal)