[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'FRF' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 1623
No result. See details below for possible causes
Contains, in addition to result, also log information about execution of API query
WHERE DimCurrency.AlternateKey EQ 'FRF'/PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount/SKIP 1623
Individual query expressions are:
WHERE DimCurrency.AlternateKey EQ 'FRF'
PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount
SKIP 1623
Note that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-.
ExecuteOne/_/15/Start = 2026-01-04 03:31:04.603
ExecuteOne/_/15/Query = WHERE DimCurrency.AlternateKey EQ 'FRF'
ExecuteOne/_/15/CountBefore = 60398
ExecuteOne/_/15/CountAfter = 59
ExecuteOne/_/15/Finish = 2026-01-04 03:31:05.191
ExecuteOne/_/15/ElapsedTime = 00:00:00.587
ExecuteOne/_/15/Text = ------------------------------------------------------
ExecuteOne/_/15/Start = 2026-01-04 03:31:05.191
ExecuteOne/_/15/Query = PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount
ExecuteOne/_/15/CountBefore = 59
StrCurrentType = DimCustomer.Name+','+DimCustomerId
ExecuteOne/_/15/CountAfter = 60
ExecuteOne/_/15/Finish = 2026-01-04 03:31:05.194
ExecuteOne/_/15/ElapsedTime = 00:00:00.002
ExecuteOne/_/15/Text = ------------------------------------------------------
ExecuteOne/_/15/Start = 2026-01-04 03:31:05.194
ExecuteOne/_/15/Query = SKIP 1623
ExecuteOne/_/15/CountBefore = 60
ExecuteOne/_/15/CountAfter = 0
ExecuteOne/_/15/Finish = 2026-01-04 03:31:05.194
ExecuteOne/_/15/ElapsedTime = 00:00:00.000
ExecuteOne/_/15/Text = ------------------------------------------------------
| DimCustomer.Name+','+DimCustomerIdId |
|---|
Generated 2026-01-04 03:31:05.194 UTC