WHERE DimSalesTerritoryId EQ '5'

Edit keys at this level only

_Description = Contains, in addition to result, also log information about execution of API query0x000D0x000AWHERE DimSalesTerritoryId EQ '5'0x000D0x000A0x000D0x000AIndividual query expressions are:0x000D0x000AWHERE DimSalesTerritoryId EQ '5'0x000D0x000A0x000D0x000ANote that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-.0x000D0x000A
AllLogEntriesForThisQuery = ExecuteOne/_/26/Start = 2024-11-14 18:09:17.3870x000D0x000AExecuteOne/_/26/Query = WHERE DimSalesTerritoryId EQ '5'0x000D0x000AExecuteOne/_/26/CountBefore = 230x000D0x000AShouldTerminate/_/26/Text = For query expression0xoooo000D0xoooo000A0xoooo000D0xoooo000AWHERE DimSalesTerritoryId EQ '5'0xoooo000D0xoooo000A0xoooo000D0xoooo000Athe key0xoooo000D0xoooo000A0xoooo000D0xoooo000ADimSalesTerritoryId0xoooo000D0xoooo000A0xoooo000D0xoooo000Awas not found.0xoooo000D0xoooo000A0xoooo000D0xoooo000ALast errorResponse is:0xoooo000D0xoooo000A0xoooo000D0xoooo000AKey DimSalesTerritoryId not found0xoooo000D0xoooo000ACompoundKey.errorResponse: Invalid key.0xoooo000D0xoooo000A0xoooo000D0xoooo000A0xoooo000D0xoooo000AThe current type is DimAccountCollection.0xoooo000D0xoooo000AProbably the wrong key was used as criteria, or the key name was misspelled.0xoooo000D0xoooo000A0xoooo000D0xoooo000ASome possible correct keys are:0xoooo000D0xoooo000ADimAccountCollectionId, -1-, -10-, -100-, -101-, -11-, -12-, -13-, -14-, -15-, -17-, -18-, -19-, -2-, -20-, -21-, -22-, -23-, -24-, -25-, -26-, -27-, -28-, -29-, -3-, -30-, -31-, -32-, -33-, -34-, -35-, -36-, -37-, -38-, -39-, -4-, -40-, -41-, -42-, -43-, -44-, -45-, -46-, -47-, -48-, -49-, -5-, -50-, -51-, -52-, -53-, -54-, -55-, -56-, -57-, -58-, -59-, -6-, -60-, -61-, -62-, -63-, -64-, -65-, -66-, -67-, -68-, -69-, -7-, -70-, -71-, -72-, -73-, -74-, -75-, -76-, -77-, -78-, -79-, -8-, -80-, -81-, -82-, -83-, -84-, -85-, -87-, -88-, -89-, -9-, -90-, -91-, -92-, -93-, -94-, -95-, -96-, -97-, -98-, -99-0xoooo000D0xoooo000A0xoooo000D0xoooo000ASome new key functions (available for all entity classes) are:0xoooo000D0xoooo000A-COUNTP-(), -COUNTPREC-(), -GETTYPE-(), -TOPROPERTYSTREAM-()0xoooo000D0xoooo000A0xoooo000D0xoooo000ASome function keys (used on existing keys) are:0xoooo000D0xoooo000A-ABS-(), -AVG-(), -AWFISCALYEAR-(), -COUNT-(), -DATE-(), -DAYOFWEEK-(), -DISTINCT-(), -DOUBLE-(), -FIRSTLINE-(), -HOURMINUTE-(), -INT-(), -JOIN-(), -LENGTH-(), -MAX-(), -MIN-(), -MONTH-(), -QUARTER-(), -SHORT-(), -SINGLE-(), -SUM-(), -TMB-(), -TOTALHOURS-(), -TOTALMINUTES-(), -TYPE-(), -VERYSHORT-(), -WEEK-(), -YEAR-(), -YEARMONTH-(), -YEARQUARTER-(), -YEARWEEK-()0xoooo000D0xoooo000A0xoooo000D0xoooo000ASome quantile keys (used on existing keys) are:0xoooo000D0xoooo000A-MEDIAN-, -TERTILE-, -QUARTILE-, -QUINTILE-, -SEXTILE-, -SEPTILE-, -OCTILE-, -DECILE-, -DUODECILE-, -HEXADECILE-, -VENTILE-, -PERCENTILE-, -PERMILLE-0xoooo000D0xoooo000A0xoooo000D0xoooo000A0x000D0x000ATerminateReason = For query expression0xoooo000D0xoooo000A0xoooo000D0xoooo000AWHERE DimSalesTerritoryId EQ '5'0xoooo000D0xoooo000A0xoooo000D0xoooo000Athe key0xoooo000D0xoooo000A0xoooo000D0xoooo000ADimSalesTerritoryId0xoooo000D0xoooo000A0xoooo000D0xoooo000Awas not found.0xoooo000D0xoooo000A0xoooo000D0xoooo000ALast errorResponse is:0xoooo000D0xoooo000A0xoooo000D0xoooo000AKey DimSalesTerritoryId not found0xoooo000D0xoooo000ACompoundKey.errorResponse: Invalid key.0xoooo000D0xoooo000A0xoooo000D0xoooo000A0xoooo000D0xoooo000AThe current type is DimAccountCollection.0xoooo000D0xoooo000AProbably the wrong key was used as criteria, or the key name was misspelled.0xoooo000D0xoooo000A0xoooo000D0xoooo000ASome possible correct keys are:0xoooo000D0xoooo000ADimAccountCollectionId, -1-, -10-, -100-, -101-, -11-, -12-, -13-, -14-, -15-, -17-, -18-, -19-, -2-, -20-, -21-, -22-, -23-, -24-, -25-, -26-, -27-, -28-, -29-, -3-, -30-, -31-, -32-, -33-, -34-, -35-, -36-, -37-, -38-, -39-, -4-, -40-, -41-, -42-, -43-, -44-, -45-, -46-, -47-, -48-, -49-, -5-, -50-, -51-, -52-, -53-, -54-, -55-, -56-, -57-, -58-, -59-, -6-, -60-, -61-, -62-, -63-, -64-, -65-, -66-, -67-, -68-, -69-, -7-, -70-, -71-, -72-, -73-, -74-, -75-, -76-, -77-, -78-, -79-, -8-, -80-, -81-, -82-, -83-, -84-, -85-, -87-, -88-, -89-, -9-, -90-, -91-, -92-, -93-, -94-, -95-, -96-, -97-, -98-, -99-0xoooo000D0xoooo000A0xoooo000D0xoooo000ASome new key functions (available for all entity classes) are:0xoooo000D0xoooo000A-COUNTP-(), -COUNTPREC-(), -GETTYPE-(), -TOPROPERTYSTREAM-()0xoooo000D0xoooo000A0xoooo000D0xoooo000ASome function keys (used on existing keys) are:0xoooo000D0xoooo000A-ABS-(), -AVG-(), -AWFISCALYEAR-(), -COUNT-(), -DATE-(), -DAYOFWEEK-(), -DISTINCT-(), -DOUBLE-(), -FIRSTLINE-(), -HOURMINUTE-(), -INT-(), -JOIN-(), -LENGTH-(), -MAX-(), -MIN-(), -MONTH-(), -QUARTER-(), -SHORT-(), -SINGLE-(), -SUM-(), -TMB-(), -TOTALHOURS-(), -TOTALMINUTES-(), -TYPE-(), -VERYSHORT-(), -WEEK-(), -YEAR-(), -YEARMONTH-(), -YEARQUARTER-(), -YEARWEEK-()0xoooo000D0xoooo000A0xoooo000D0xoooo000ASome quantile keys (used on existing keys) are:0xoooo000D0xoooo000A-MEDIAN-, -TERTILE-, -QUARTILE-, -QUINTILE-, -SEXTILE-, -SEPTILE-, -OCTILE-, -DECILE-, -DUODECILE-, -HEXADECILE-, -VENTILE-, -PERCENTILE-, -PERMILLE-0xoooo000D0xoooo000A0xoooo000D0xoooo000A0xoooo000D0xoooo000AHINT: Use 'STRICT OFF' in order to force execution of query (ignoring this problem).0x000D0x000AExecuteOne/_/26/CountAfter = 00x000D0x000AExecuteOne/_/26/Finish = 2024-11-14 18:09:17.3890x000D0x000AExecuteOne/_/26/ElapsedTime = 00:00:00.0010x000D0x000AExecuteOne/_/26/Text = ------------------------------------------------------
CreateHints = True
CurrentStrictness = ON
Limit = 1000
Queries = WHERE DimSalesTerritoryId EQ '5'
StrCurrentType = DimAccountCollection
TerminateReason = For query expression0x000D0x000A0x000D0x000AWHERE DimSalesTerritoryId EQ '5'0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ADimSalesTerritoryId0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey DimSalesTerritoryId not found0x000D0x000ACompoundKey.errorResponse: Invalid key.0x000D0x000A0x000D0x000A0x000D0x000AThe current type is DimAccountCollection.0x000D0x000AProbably the wrong key was used as criteria, or the key name was misspelled.0x000D0x000A0x000D0x000ASome possible correct keys are:0x000D0x000ADimAccountCollectionId, -1-, -10-, -100-, -101-, -11-, -12-, -13-, -14-, -15-, -17-, -18-, -19-, -2-, -20-, -21-, -22-, -23-, -24-, -25-, -26-, -27-, -28-, -29-, -3-, -30-, -31-, -32-, -33-, -34-, -35-, -36-, -37-, -38-, -39-, -4-, -40-, -41-, -42-, -43-, -44-, -45-, -46-, -47-, -48-, -49-, -5-, -50-, -51-, -52-, -53-, -54-, -55-, -56-, -57-, -58-, -59-, -6-, -60-, -61-, -62-, -63-, -64-, -65-, -66-, -67-, -68-, -69-, -7-, -70-, -71-, -72-, -73-, -74-, -75-, -76-, -77-, -78-, -79-, -8-, -80-, -81-, -82-, -83-, -84-, -85-, -87-, -88-, -89-, -9-, -90-, -91-, -92-, -93-, -94-, -95-, -96-, -97-, -98-, -99-0x000D0x000A0x000D0x000ASome new key functions (available for all entity classes) are:0x000D0x000A-COUNTP-(), -COUNTPREC-(), -GETTYPE-(), -TOPROPERTYSTREAM-()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000A-ABS-(), -AVG-(), -AWFISCALYEAR-(), -COUNT-(), -DATE-(), -DAYOFWEEK-(), -DISTINCT-(), -DOUBLE-(), -FIRSTLINE-(), -HOURMINUTE-(), -INT-(), -JOIN-(), -LENGTH-(), -MAX-(), -MIN-(), -MONTH-(), -QUARTER-(), -SHORT-(), -SINGLE-(), -SUM-(), -TMB-(), -TOTALHOURS-(), -TOTALMINUTES-(), -TYPE-(), -VERYSHORT-(), -WEEK-(), -YEAR-(), -YEARMONTH-(), -YEARQUARTER-(), -YEARWEEK-()0x000D0x000A0x000D0x000ASome quantile keys (used on existing keys) are:0x000D0x000A-MEDIAN-, -TERTILE-, -QUARTILE-, -QUINTILE-, -SEXTILE-, -SEPTILE-, -OCTILE-, -DECILE-, -DUODECILE-, -HEXADECILE-, -VENTILE-, -PERCENTILE-, -PERMILLE-0x000D0x000A0x000D0x000A0x000D0x000AHINT: Use 'STRICT OFF' in order to force execution of query (ignoring this problem).
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 / TerminateReason / UseCache

Generated 2024-11-14 18:09:17.390 UTC