/ dt / FactInternetSale / WHERE DimCurrency.AlternateKey EQ 'USD' / PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount / SHUFFLE / SKIP 1000 / SKIP 0 / TAKE 1000

TAKE 1000

Edit keys at this level only

_Description = Contains, in addition to result, also log information about execution of API query0x000D0x000AWHERE DimCurrency.AlternateKey EQ 'USD'/PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount/SHUFFLE/SKIP 1000/SKIP 0/TAKE 10000x000D0x000A0x000D0x000AIndividual query expressions are:0x000D0x000AWHERE DimCurrency.AlternateKey EQ 'USD'0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0x000D0x000ASHUFFLE0x000D0x000ASKIP 10000x000D0x000ASKIP 00x000D0x000ATAKE 10000x000D0x000A0x000D0x000ANote that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-.0x000D0x000A
AllLogEntriesForThisQuery = ExecuteOne/_/28/Start = 2025-12-19 03:03:24.2430x000D0x000AExecuteOne/_/28/Query = WHERE DimCurrency.AlternateKey EQ 'USD'0x000D0x000AExecuteOne/_/28/CountBefore = 603980x000D0x000AExecuteOne/_/28/CountAfter = 334000x000D0x000AExecuteOne/_/28/Finish = 2025-12-19 03:03:24.8210x000D0x000AExecuteOne/_/28/ElapsedTime = 00:00:00.5770x000D0x000AExecuteOne/_/28/Text = ------------------------------------------------------0x000D0x000AExecuteOne/_/28/Start = 2025-12-19 03:03:24.8210x000D0x000AExecuteOne/_/28/Query = PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0x000D0x000AExecuteOne/_/28/CountBefore = 334000x000D0x000AStrCurrentType = DimCustomer.Name+','+DimCustomerId0x000D0x000AExecuteOne/_/28/CountAfter = 118190x000D0x000AExecuteOne/_/28/Finish = 2025-12-19 03:03:25.6570x000D0x000AExecuteOne/_/28/ElapsedTime = 00:00:00.8360x000D0x000AExecuteOne/_/28/Text = ------------------------------------------------------0x000D0x000AExecuteOne/_/28/Start = 2025-12-19 03:03:25.6570x000D0x000AExecuteOne/_/28/Query = SHUFFLE0x000D0x000AExecuteOne/_/28/CountBefore = 118190x000D0x000AExecuteOne/_/28/CountAfter = 118190x000D0x000AExecuteOne/_/28/Finish = 2025-12-19 03:03:25.6580x000D0x000AExecuteOne/_/28/ElapsedTime = 00:00:00.0000x000D0x000AExecuteOne/_/28/Text = ------------------------------------------------------0x000D0x000AExecuteOne/_/28/Start = 2025-12-19 03:03:25.6580x000D0x000AExecuteOne/_/28/Query = SKIP 10000x000D0x000AExecuteOne/_/28/CountBefore = 118190x000D0x000AExecuteOne/_/28/CountAfter = 108190x000D0x000AExecuteOne/_/28/Finish = 2025-12-19 03:03:25.6580x000D0x000AExecuteOne/_/28/ElapsedTime = 00:00:00.0000x000D0x000AExecuteOne/_/28/Text = ------------------------------------------------------0x000D0x000AExecuteOne/_/28/Start = 2025-12-19 03:03:25.6580x000D0x000AExecuteOne/_/28/Query = SKIP 00x000D0x000AExecuteOne/_/28/CountBefore = 108190x000D0x000AExecuteOne/_/28/CountAfter = 108190x000D0x000AExecuteOne/_/28/Finish = 2025-12-19 03:03:25.6580x000D0x000AExecuteOne/_/28/ElapsedTime = 00:00:00.0000x000D0x000AExecuteOne/_/28/Text = ------------------------------------------------------0x000D0x000AExecuteOne/_/28/Start = 2025-12-19 03:03:25.6580x000D0x000AExecuteOne/_/28/Query = TAKE 10000x000D0x000AExecuteOne/_/28/CountBefore = 108190x000D0x000AExecuteOne/_/28/CountAfter = 10000x000D0x000AExecuteOne/_/28/Finish = 2025-12-19 03:03:25.6580x000D0x000AExecuteOne/_/28/ElapsedTime = 00:00:00.0000x000D0x000AExecuteOne/_/28/Text = ------------------------------------------------------
CreateHints = True
CurrentStrictness = ON
Limit = 1000
Queries = WHERE DimCurrency.AlternateKey EQ 'USD'0x003BPIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0x003BSHUFFLE0x003BSKIP 10000x003BSKIP 00x003BTAKE 1000
StrCurrentType = DimCustomer.Name+','+DimCustomerId
UseCache = False

Edit keys at all sub levels.
NOTE: Edits are always additive. Use 'Invalid' in order to delete keys.

Edit single sub keys only: _Description / AllLogEntriesForThisQuery / CreateHints / CurrentStrictness / Limit / Queries / StrCurrentType / UseCache

Generated 2025-12-19 03:03:25.659 UTC