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

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

Edit keys at this level only

_Description = Contains, in addition to result, also log information about execution of API query0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0x000D0x000A0x000D0x000AIndividual query expressions are:0x000D0x000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0x000D0x000A0x000D0x000ANote that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-.0x000D0x000A
AllLogEntriesForThisQuery = ExecuteOne/_/18/Start = 2024-05-18 22:03:06.0420x000D0x000AExecuteOne/_/18/Query = PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0x000D0x000AExecuteOne/_/18/CountBefore = 230x000D0x000AShouldTerminate/_/18/Text = For query expression0xoooo000D0xoooo000A0xoooo000D0xoooo000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0xoooo000D0xoooo000A0xoooo000D0xoooo000Athe key0xoooo000D0xoooo000A0xoooo000D0xoooo000ADimCustomer.Name+','+DimCustomerId0xoooo000D0xoooo000A0xoooo000D0xoooo000Awas not found.0xoooo000D0xoooo000A0xoooo000D0xoooo000ALast errorResponse is:0xoooo000D0xoooo000A0xoooo000D0xoooo000ALeft operand not found: Details: Key DimCustomer.Name not found0xoooo000D0xoooo000ACompoundKey.errorResponse: Invalid ForeignKey because of: No key found in data storage for foreign type 'ARAdventureWorksOLAP.DimCustomer'.0xoooo000D0xoooo000ASome of the keys found where: dt, doc, app, TimestampIsOld0xoooo000D0xoooo000A0xoooo000D0xoooo000AInvalid MemberEntityKey because of: Property 'DimCustomer' not defined in schema for 'DimAccountCollection' (enum 'DimAccountCollectionP.DimCustomer' does not exist,0xoooo000D0xoooo000Aand also0xoooo000D0xoooo000AEntityMethodKey 'TryGetDimCustomer' not defined for DimAccountCollection0xoooo000D0xoooo000A0xoooo000D0xoooo000A0xoooo000D0xoooo000Akey was understood to be of type -BinaryOperatorKey-0xoooo000D0xoooo000AThe 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 expression0xoooo000D0xoooo000A0xoooo000D0xoooo000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0xoooo000D0xoooo000A0xoooo000D0xoooo000Athe key0xoooo000D0xoooo000A0xoooo000D0xoooo000ADimCustomer.Name+','+DimCustomerId0xoooo000D0xoooo000A0xoooo000D0xoooo000Awas not found.0xoooo000D0xoooo000A0xoooo000D0xoooo000ALast errorResponse is:0xoooo000D0xoooo000A0xoooo000D0xoooo000ALeft operand not found: Details: Key DimCustomer.Name not found0xoooo000D0xoooo000ACompoundKey.errorResponse: Invalid ForeignKey because of: No key found in data storage for foreign type 'ARAdventureWorksOLAP.DimCustomer'.0xoooo000D0xoooo000ASome of the keys found where: dt, doc, app, TimestampIsOld0xoooo000D0xoooo000A0xoooo000D0xoooo000AInvalid MemberEntityKey because of: Property 'DimCustomer' not defined in schema for 'DimAccountCollection' (enum 'DimAccountCollectionP.DimCustomer' does not exist,0xoooo000D0xoooo000Aand also0xoooo000D0xoooo000AEntityMethodKey 'TryGetDimCustomer' not defined for DimAccountCollection0xoooo000D0xoooo000A0xoooo000D0xoooo000A0xoooo000D0xoooo000Akey was understood to be of type -BinaryOperatorKey-0xoooo000D0xoooo000AThe 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).0x000D0x000AShouldTerminate/_/18/Text = For query expression0xoooo000D0xoooo000A0xoooo000D0xoooo000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0xoooo000D0xoooo000A0xoooo000D0xoooo000Athe key0xoooo000D0xoooo000A0xoooo000D0xoooo000AOrderDate.Year()0xoooo000D0xoooo000A0xoooo000D0xoooo000Awas not found.0xoooo000D0xoooo000A0xoooo000D0xoooo000ALast errorResponse is:0xoooo000D0xoooo000A0xoooo000D0xoooo000AKey OrderDate not found0xoooo000D0xoooo000A0xoooo000D0xoooo000Akey was understood to be of type -OrdinaryKeyPlusFunctionOrQuantile-0xoooo000D0xoooo000AThe 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 expression0xoooo000D0xoooo000A0xoooo000D0xoooo000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0xoooo000D0xoooo000A0xoooo000D0xoooo000Athe key0xoooo000D0xoooo000A0xoooo000D0xoooo000AOrderDate.Year()0xoooo000D0xoooo000A0xoooo000D0xoooo000Awas not found.0xoooo000D0xoooo000A0xoooo000D0xoooo000ALast errorResponse is:0xoooo000D0xoooo000A0xoooo000D0xoooo000AKey OrderDate not found0xoooo000D0xoooo000A0xoooo000D0xoooo000Akey was understood to be of type -OrdinaryKeyPlusFunctionOrQuantile-0xoooo000D0xoooo000AThe 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).0x000D0x000AShouldTerminate/_/18/Text = For query expression0xoooo000D0xoooo000A0xoooo000D0xoooo000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0xoooo000D0xoooo000A0xoooo000D0xoooo000Athe key0xoooo000D0xoooo000A0xoooo000D0xoooo000ASalesAmount0xoooo000D0xoooo000A0xoooo000D0xoooo000Awas not found.0xoooo000D0xoooo000A0xoooo000D0xoooo000ALast errorResponse is:0xoooo000D0xoooo000A0xoooo000D0xoooo000AKey SalesAmount 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 expression0xoooo000D0xoooo000A0xoooo000D0xoooo000APIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount0xoooo000D0xoooo000A0xoooo000D0xoooo000Athe key0xoooo000D0xoooo000A0xoooo000D0xoooo000ASalesAmount0xoooo000D0xoooo000A0xoooo000D0xoooo000Awas not found.0xoooo000D0xoooo000A0xoooo000D0xoooo000ALast errorResponse is:0xoooo000D0xoooo000A0xoooo000D0xoooo000AKey SalesAmount 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).0x000D0x000AStrCurrentType = DimCustomer.Name+','+DimCustomerId0x000D0x000AExecuteOne/_/18/CountAfter = 20x000D0x000AExecuteOne/_/18/Finish = 2024-05-18 22:03:06.0460x000D0x000AExecuteOne/_/18/ElapsedTime = 00:00:00.0040x000D0x000AExecuteOne/_/18/Text = ------------------------------------------------------
CreateHints = True
CurrentStrictness = ON
Limit = 1000
Queries = PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount
StrCurrentType = DimCustomer.Name+','+DimCustomerId
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: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-05-18 22:03:06.050 UTC