DD-CON-004-Q030 Hard Time series

Goods booked against the wrong partner

In one month of 2025 Trading KSA recorded goods it bought from Manufacturing against Logistics' partner code. Which month, and how much did it record that way, in USD at that month's average rate? Answer as YYYY-MM · amount.

Expected: YYYY-MM · amount · KPI card
Tables: FactGLLines, DimICPartner, DimAccount_Oracle, FactICTransactions +1 · columns

FactGLLines
DimICPartner
DimAccount_Oracle
FactICTransactions
DimFXRate

EntityCode
LocalAccountCode
Amount
DrCrIndicator
PostingStatus
SourceTypeCode
PostingDateKey
PartnerCode
TransactionType
IssueDate
CounterpartyBookingDate
AmountUSD
IssuerEntityCode
CounterpartyEntityCode
RateType
Rate
PeriodKey
CurrencyCode
Topics: Time Series & Trends Risk & Controls Consolidation & Currency