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.

  • Are Actual Expenses, Budget Revenue and Budget Expenses required as production measures even though they are absent from the authoritative register?

    Management P&L metric prototype

  • What are the approved DAX definitions and source for budget values?

    Management P&L metric prototype

  • Should revenue/expense classification use account-number ranges as in the prototype formulas, or governed AccountType/AccountGroup mappings?

    Management P&L metric prototype

  • Should AccountType cover the full balance-sheet and P&L domain (Asset, Liability, Equity, Revenue, Expense), rather than only the register's stated revenue-or-expense classification?

    Account.AccountType column

  • Should the YYYYMMDD encoding and uniqueness of Calendar.DateKey be tested against source/model data during implementation validation?

    Calendar.DateKey column

  • Does the current Calendar.FiscalMonth use the required July-start numbering shown by the workbook formula?

    Calendar.FiscalMonth column

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

    Calendar.FiscalMonth column

  • Is SignedAmount already converted into a single reporting currency, and what conversion-rate/date rules are intended when CurrencyCode is added?

    Ledger.SignedAmount column

  • Is the workbook's positive-revenue/negative-expense sign convention the required production convention?

    Ledger.SignedAmount column

  • What business rule distinguishes late or manual adjustments, and is the current field populated consistently with that rule?

    Ledger.IsAdjustment column

  • Is CostCentre available in the finance posting source at the same posting grain as Ledger?

    Ledger.CostCentre column

  • Is a separate Cost Centre dimension required, or is a code column on Ledger sufficient?

    Ledger.CostCentre column

  • Who owns the authoritative cost-centre hierarchy and effective-dating rules?

    Ledger.CostCentre column

  • Is transaction currency available on every posting in the finance source?

    Ledger.CurrencyCode column

  • Are transaction amount, reporting amount and exchange-rate fields also needed to make transaction-currency analysis meaningful?

    Ledger.CurrencyCode column

  • Should CurrencyCode link to a governed currency dimension?

    Ledger.CurrencyCode column

  • What is the authoritative source and owner for AccountGroup mappings?

    Account.AccountGroup column

  • Can an account belong to more than one management group, and are mappings effective-dated?

    Account.AccountGroup column

  • The reference examples differ in grouping vocabulary from some chart-of-accounts examples; what controlled hierarchy is intended?

    Account.AccountGroup column