TerminateReason

For query expression

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

the key

SalesAmount

was not found.

Last errorResponse is:

Key SalesAmount not found
CompoundKey.errorResponse: Invalid key.

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

Some possible correct keys are:
DimAccountCollectionId, -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-

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/_/76/Start = 2024-05-05 14:31:21.549
ExecuteOne/_/76/Query = PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount
ExecuteOne/_/76/CountBefore = 23
ShouldTerminate/_/76/Text = For query expression0x000D0x000A0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0x000D0x000A0x000D0x000Athe 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: dt, doc, app, TimestampIsOld0x000D0x000A0x000D0x000AInvalid MemberEntityKey because of: Property 'DimCustomer' not defined in schema for 'DimAccountCollection' (enum 'DimAccountCollectionP.DimCustomer' does not exist,0x000D0x000Aand also0x000D0x000AEntityMethodKey 'TryGetDimCustomer' not defined for DimAccountCollection0x000D0x000A0x000D0x000A0x000D0x000Akey was understood to be of type BinaryOperatorKey0x000D0x000AThe 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:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AABS(), 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:0x000D0x000AMEDIAN, TERTILE, QUARTILE, QUINTILE, SEXTILE, SEPTILE, OCTILE, DECILE, DUODECILE, HEXADECILE, VENTILE, PERCENTILE, PERMILLE0x000D0x000A0x000D0x000A
TerminateReason = For query expression0x000D0x000A0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0x000D0x000A0x000D0x000Athe 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: dt, doc, app, TimestampIsOld0x000D0x000A0x000D0x000AInvalid MemberEntityKey because of: Property 'DimCustomer' not defined in schema for 'DimAccountCollection' (enum 'DimAccountCollectionP.DimCustomer' does not exist,0x000D0x000Aand also0x000D0x000AEntityMethodKey 'TryGetDimCustomer' not defined for DimAccountCollection0x000D0x000A0x000D0x000A0x000D0x000Akey was understood to be of type BinaryOperatorKey0x000D0x000AThe 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:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AABS(), 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:0x000D0x000AMEDIAN, TERTILE, QUARTILE, QUINTILE, SEXTILE, SEPTILE, OCTILE, DECILE, DUODECILE, HEXADECILE, VENTILE, PERCENTILE, PERMILLE0x000D0x000A0x000D0x000A0x000D0x000AHINT: Use 'STRICT OFF' in order to force execution of query (ignoring this problem).
ShouldTerminate/_/76/Text = For query expression0x000D0x000A0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000AOrderDate.Year()0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey OrderDate not found0x000D0x000A0x000D0x000Akey was understood to be of type OrdinaryKeyPlusFunctionOrQuantile0x000D0x000AThe 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:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AABS(), 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:0x000D0x000AMEDIAN, TERTILE, QUARTILE, QUINTILE, SEXTILE, SEPTILE, OCTILE, DECILE, DUODECILE, HEXADECILE, VENTILE, PERCENTILE, PERMILLE0x000D0x000A0x000D0x000A
TerminateReason = For query expression0x000D0x000A0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000AOrderDate.Year()0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey OrderDate not found0x000D0x000A0x000D0x000Akey was understood to be of type OrdinaryKeyPlusFunctionOrQuantile0x000D0x000AThe 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:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AABS(), 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:0x000D0x000AMEDIAN, TERTILE, QUARTILE, QUINTILE, SEXTILE, SEPTILE, OCTILE, DECILE, DUODECILE, HEXADECILE, VENTILE, PERCENTILE, PERMILLE0x000D0x000A0x000D0x000A0x000D0x000AHINT: Use 'STRICT OFF' in order to force execution of query (ignoring this problem).
ShouldTerminate/_/76/Text = For query expression0x000D0x000A0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ASalesAmount0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey SalesAmount 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:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AABS(), 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:0x000D0x000AMEDIAN, TERTILE, QUARTILE, QUINTILE, SEXTILE, SEPTILE, OCTILE, DECILE, DUODECILE, HEXADECILE, VENTILE, PERCENTILE, PERMILLE0x000D0x000A0x000D0x000A
TerminateReason = For query expression0x000D0x000A0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ASalesAmount0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey SalesAmount 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:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AABS(), 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:0x000D0x000AMEDIAN, TERTILE, QUARTILE, QUINTILE, SEXTILE, SEPTILE, OCTILE, DECILE, DUODECILE, HEXADECILE, VENTILE, PERCENTILE, PERMILLE0x000D0x000A0x000D0x000A0x000D0x000AHINT: Use 'STRICT OFF' in order to force execution of query (ignoring this problem).
StrCurrentType = DimCustomer.Name+','+DimCustomerId
ExecuteOne/_/76/CountAfter = 2
ExecuteOne/_/76/Finish = 2024-05-05 14:31:21.577
ExecuteOne/_/76/ElapsedTime = 00:00:00.027
ExecuteOne/_/76/Text = ------------------------------------------------------

Generated 2024-05-05 14:31:22.071 UTC