WHERE DimSalesTerritoryId EQ '1'

Edit keys at this level only

_Description = Contains, in addition to result, also log information about execution of API query0x000D0x000AWHERE DimSalesTerritoryId EQ '1'0x000D0x000A0x000D0x000AIndividual query expressions are:0x000D0x000AWHERE DimSalesTerritoryId EQ '1'0x000D0x000A0x000D0x000ANote that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-.0x000D0x000A
AllLogEntriesForThisQuery = ExecuteOne/_/10/Start = 2025-08-05 22:09:01.0060x000D0x000AExecuteOne/_/10/Query = WHERE DimSalesTerritoryId EQ '1'0x000D0x000AExecuteOne/_/10/CountBefore = 40x000D0x000AShouldTerminate/_/10/Text = For query expression0xoooo000D0xoooo000A0xoooo000D0xoooo000AWHERE DimSalesTerritoryId EQ '1'0xoooo000D0xoooo000A0xoooo000D0xoooo000Athe key0xoooo000D0xoooo000A0xoooo000D0xoooo000ADimSalesTerritoryId0xoooo000D0xoooo000A0xoooo000D0xoooo000Awas not found.0xoooo000D0xoooo000A0xoooo000D0xoooo000ALast errorResponse is:0xoooo000D0xoooo000A0xoooo000D0xoooo000AIrrelevant to call TryGetP for this class (PValue0xoooo003CBoolean0xoooo003E). Parameters: k: DimSalesTerritoryId (type IP). The reason you are not allowed to do this is that this class only contains a single value (of type Boolean). It is therefore unable to handle more complex operations. 0xoooo000D0xoooo000ACompoundKey.errorResponse: Invalid key.0xoooo000D0xoooo000A0xoooo000D0xoooo000A0xoooo000D0xoooo000AThe current type is PRich.0xoooo000D0xoooo000AProbably the wrong key was used as criteria, or the key name was misspelled.0xoooo000D0xoooo000A0xoooo000D0xoooo000ASome possible correct keys are:0xoooo000D0xoooo000APRichId, -DimAccount-, -DimCurrency-, -DimCustomer-, -DimDepartment-, -DimEmployee-, -DimGeography-, -DimOrganization-, -DimProduct-, -DimProductCategory-, -DimProductSubcategory-, -DimPromotion-, -DimReseller-, -DimSalesReason-, -DimSalesTerritory-, -FactCallCenter-, -FactCurrencyRate-, -FactFinance-, -FactInternetSale-, -FactInternetSaleReason-, -FactProductDescription-, -FactResellerSale-, -FactSalesQuota-, -FactSurveyResponse-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 '1'0xoooo000D0xoooo000A0xoooo000D0xoooo000Athe key0xoooo000D0xoooo000A0xoooo000D0xoooo000ADimSalesTerritoryId0xoooo000D0xoooo000A0xoooo000D0xoooo000Awas not found.0xoooo000D0xoooo000A0xoooo000D0xoooo000ALast errorResponse is:0xoooo000D0xoooo000A0xoooo000D0xoooo000AIrrelevant to call TryGetP for this class (PValue0xoooo003CBoolean0xoooo003E). Parameters: k: DimSalesTerritoryId (type IP). The reason you are not allowed to do this is that this class only contains a single value (of type Boolean). It is therefore unable to handle more complex operations. 0xoooo000D0xoooo000ACompoundKey.errorResponse: Invalid key.0xoooo000D0xoooo000A0xoooo000D0xoooo000A0xoooo000D0xoooo000AThe current type is PRich.0xoooo000D0xoooo000AProbably the wrong key was used as criteria, or the key name was misspelled.0xoooo000D0xoooo000A0xoooo000D0xoooo000ASome possible correct keys are:0xoooo000D0xoooo000APRichId, -DimAccount-, -DimCurrency-, -DimCustomer-, -DimDepartment-, -DimEmployee-, -DimGeography-, -DimOrganization-, -DimProduct-, -DimProductCategory-, -DimProductSubcategory-, -DimPromotion-, -DimReseller-, -DimSalesReason-, -DimSalesTerritory-, -FactCallCenter-, -FactCurrencyRate-, -FactFinance-, -FactInternetSale-, -FactInternetSaleReason-, -FactProductDescription-, -FactResellerSale-, -FactSalesQuota-, -FactSurveyResponse-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/_/10/CountAfter = 00x000D0x000AExecuteOne/_/10/Finish = 2025-08-05 22:09:01.0070x000D0x000AExecuteOne/_/10/ElapsedTime = 00:00:00.0010x000D0x000AExecuteOne/_/10/Text = ------------------------------------------------------
CreateHints = True
CurrentStrictness = ON
Limit = 1000
Queries = WHERE DimSalesTerritoryId EQ '1'
StrCurrentType = PRich
TerminateReason = For query expression0x000D0x000A0x000D0x000AWHERE DimSalesTerritoryId EQ '1'0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ADimSalesTerritoryId0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AIrrelevant to call TryGetP for this class (PValue0x003CBoolean0x003E). Parameters: k: DimSalesTerritoryId (type IP). The reason you are not allowed to do this is that this class only contains a single value (of type Boolean). It is therefore unable to handle more complex operations. 0x000D0x000ACompoundKey.errorResponse: Invalid key.0x000D0x000A0x000D0x000A0x000D0x000AThe current type is PRich.0x000D0x000AProbably the wrong key was used as criteria, or the key name was misspelled.0x000D0x000A0x000D0x000ASome possible correct keys are:0x000D0x000APRichId, -DimAccount-, -DimCurrency-, -DimCustomer-, -DimDepartment-, -DimEmployee-, -DimGeography-, -DimOrganization-, -DimProduct-, -DimProductCategory-, -DimProductSubcategory-, -DimPromotion-, -DimReseller-, -DimSalesReason-, -DimSalesTerritory-, -FactCallCenter-, -FactCurrencyRate-, -FactFinance-, -FactInternetSale-, -FactInternetSaleReason-, -FactProductDescription-, -FactResellerSale-, -FactSalesQuota-, -FactSurveyResponse-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 2025-08-05 22:09:01.011 UTC