[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'FRF' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 2250 SHUFFLE
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 2250/SHUFFLE
Individual query expressions are:
WHERE DimCurrency.AlternateKey EQ 'FRF'
PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount
SKIP 2250
SHUFFLE
Note that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-.
ExecuteOne/_/22/Start = 2025-12-23 06:03:55.034
ExecuteOne/_/22/Query = WHERE DimCurrency.AlternateKey EQ 'FRF'
ExecuteOne/_/22/CountBefore = 60398
ExecuteOne/_/22/CountAfter = 59
ExecuteOne/_/22/Finish = 2025-12-23 06:03:55.616
ExecuteOne/_/22/ElapsedTime = 00:00:00.581
ExecuteOne/_/22/Text = ------------------------------------------------------
ExecuteOne/_/22/Start = 2025-12-23 06:03:55.616
ExecuteOne/_/22/Query = PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount
ExecuteOne/_/22/CountBefore = 59
StrCurrentType = DimCustomer.Name+','+DimCustomerId
ExecuteOne/_/22/CountAfter = 60
ExecuteOne/_/22/Finish = 2025-12-23 06:03:55.747
ExecuteOne/_/22/ElapsedTime = 00:00:00.130
ExecuteOne/_/22/Text = ------------------------------------------------------
ExecuteOne/_/22/Start = 2025-12-23 06:03:55.747
ExecuteOne/_/22/Query = SKIP 2250
ExecuteOne/_/22/CountBefore = 60
ExecuteOne/_/22/CountAfter = 0
ExecuteOne/_/22/Finish = 2025-12-23 06:03:55.747
ExecuteOne/_/22/ElapsedTime = 00:00:00.000
ExecuteOne/_/22/Text = ------------------------------------------------------
ExecuteOne/_/22/Start = 2025-12-23 06:03:55.747
ExecuteOne/_/22/Query = SHUFFLE
ExecuteOne/_/22/CountBefore = 0
ExecuteOne/_/22/CountAfter = 0
ExecuteOne/_/22/Finish = 2025-12-23 06:03:55.747
ExecuteOne/_/22/ElapsedTime = 00:00:00.000
ExecuteOne/_/22/Text = ------------------------------------------------------
| DimCustomer.Name+','+DimCustomerIdId |
|---|
Generated 2025-12-23 06:03:55.747 UTC