TerminateReason

For query expression

PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmountController

the key

SalesAmountController

was not found.

Last errorResponse is:

Key SalesAmountController not found
CompoundKey.errorResponse: Invalid key.

The current type is PRich.
Probably the wrong key was used as criteria, or the key name was misspelled.

Some possible correct keys are:
PRichId, -~dbg-, -~std-

Some new key functions (available for all entity classes) are:
-COUNTP-(), -COUNTPREC-(), -GETTYPE-(), -TOPROPERTYSTREAM-()

Some function keys (used on existing keys) are:
-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-()

Some quantile keys (used on existing keys) are:
-MEDIAN-, -TERTILE-, -QUARTILE-, -QUINTILE-, -SEXTILE-, -SEPTILE-, -OCTILE-, -DECILE-, -DUODECILE-, -HEXADECILE-, -VENTILE-, -PERCENTILE-, -PERMILLE-

HINT: Use 'STRICT OFF' in order to force execution of query (ignoring this problem).

AllLogEntriesForThisQuery

ExecuteOne/_/26/Start = 2025-11-05 09:33:17.183
ExecuteOne/_/26/Query = PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmountController
ExecuteOne/_/26/CountBefore = 4
ShouldTerminate/_/26/Text = For query expression0x000D0x000A0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmountController0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ADimCustomer.Name+','+DimCustomerId0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000ALeft operand not found: Details: Key DimCustomer.Name not found0x000D0x000ACompoundKey.errorResponse: Invalid ForeignKey because of: No key found in data storage for foreign type 'ARAdventureWorksOLAP.DimCustomer'.0x000D0x000ASome of the keys found where: _Description, AddController, EditController, GQController, RQController0x000D0x000A0x000D0x000AInvalid MemberEntityKey because of: Property 'DimCustomer' not defined in schema for 'PRich' (enum 'PRichP.DimCustomer' does not exist,0x000D0x000Aand also0x000D0x000AEntityMethodKey 'TryGetDimCustomer' not defined for PRich0x000D0x000A0x000D0x000A0x000D0x000Akey was understood to be of type -BinaryOperatorKey-0x000D0x000AThe current type is PRich.0x000D0x000AProbably the wrong key was used as criteria, or the key name was misspelled.0x000D0x000A0x000D0x000ASome possible correct keys are:0x000D0x000APRichId, -~dbg-, -~std-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-0x000D0x000A0x000D0x000A
TerminateReason = For query expression0x000D0x000A0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmountController0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ADimCustomer.Name+','+DimCustomerId0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000ALeft operand not found: Details: Key DimCustomer.Name not found0x000D0x000ACompoundKey.errorResponse: Invalid ForeignKey because of: No key found in data storage for foreign type 'ARAdventureWorksOLAP.DimCustomer'.0x000D0x000ASome of the keys found where: _Description, AddController, EditController, GQController, RQController0x000D0x000A0x000D0x000AInvalid MemberEntityKey because of: Property 'DimCustomer' not defined in schema for 'PRich' (enum 'PRichP.DimCustomer' does not exist,0x000D0x000Aand also0x000D0x000AEntityMethodKey 'TryGetDimCustomer' not defined for PRich0x000D0x000A0x000D0x000A0x000D0x000Akey was understood to be of type -BinaryOperatorKey-0x000D0x000AThe current type is PRich.0x000D0x000AProbably the wrong key was used as criteria, or the key name was misspelled.0x000D0x000A0x000D0x000ASome possible correct keys are:0x000D0x000APRichId, -~dbg-, -~std-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).
ShouldTerminate/_/26/Text = For query expression0x000D0x000A0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmountController0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000AOrderDate.Year()0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey OrderDate not found0x000D0x000A0x000D0x000Akey was understood to be of type -OrdinaryKeyPlusFunctionOrQuantile-0x000D0x000AThe current type is PRich.0x000D0x000AProbably the wrong key was used as criteria, or the key name was misspelled.0x000D0x000A0x000D0x000ASome possible correct keys are:0x000D0x000APRichId, -~dbg-, -~std-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-0x000D0x000A0x000D0x000A
TerminateReason = For query expression0x000D0x000A0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmountController0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000AOrderDate.Year()0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey OrderDate not found0x000D0x000A0x000D0x000Akey was understood to be of type -OrdinaryKeyPlusFunctionOrQuantile-0x000D0x000AThe current type is PRich.0x000D0x000AProbably the wrong key was used as criteria, or the key name was misspelled.0x000D0x000A0x000D0x000ASome possible correct keys are:0x000D0x000APRichId, -~dbg-, -~std-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).
ShouldTerminate/_/26/Text = For query expression0x000D0x000A0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmountController0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ASalesAmountController0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey SalesAmountController not found0x000D0x000ACompoundKey.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, -~dbg-, -~std-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-0x000D0x000A0x000D0x000A
TerminateReason = For query expression0x000D0x000A0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmountController0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ASalesAmountController0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey SalesAmountController not found0x000D0x000ACompoundKey.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, -~dbg-, -~std-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).
StrCurrentType = DimCustomer.Name+','+DimCustomerId
ExecuteOne/_/26/CountAfter = 2
ExecuteOne/_/26/Finish = 2025-11-05 09:33:21.028
ExecuteOne/_/26/ElapsedTime = 00:00:03.845
ExecuteOne/_/26/Text = ------------------------------------------------------

Generated 2025-11-05 09:33:21.030 UTC