< ORDER BY OrderDate.YearMonth()Id
4 items
Query was prematurely terminated
For query expression
ORDER BY OrderDate.YearMonth()Id
the key
OrderDate.YearMonth()Id
was not found.
Last errorResponse is:
Irrelevant to call TryGetP for this class (PValue<Boolean>). Parameters: k: OrderDate.YearMonth()Id (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.
CompoundKey.errorResponse: Invalid ForeignKey because of: Potential foreign key traversals 'OrderDate.YearMonth()Id' was not understood, starting from initialType 'PRich'.
Invalid MemberEntityKey because of: Property 'OrderDate' not defined in schema for 'PRich' (enum 'PRichP.OrderDate' does not exist,
and also
EntityMethodKey 'TryGetOrderDate' not defined for PRich
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, DimAccount, DimCurrency, DimCustomer, DimDepartment, DimEmployee, DimGeography, DimOrganization, DimProduct, DimProductCategory, DimProductSubcategory, DimPromotion, DimReseller, DimSalesReason, DimSalesTerritory, FactCallCenter, FactCurrencyRate, FactFinance, FactInternetSale, FactInternetSaleReason, FactProductDescription, FactResellerSale, FactSalesQuota, FactSurveyResponse
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).
ExecuteOne/_/47/Start = 2024-05-03 13:53:34.114
ExecuteOne/_/47/Query = ORDER BY OrderDate.YearMonth()Id
ExecuteOne/_/47/CountBefore = 4
ShouldTerminate/_/47/Text = For query expression0x000D0x000A0x000D0x000AORDER BY OrderDate.YearMonth()Id0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000AOrderDate.YearMonth()Id0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AIrrelevant to call TryGetP for this class (PValue0x003CBoolean0x003E). Parameters: k: OrderDate.YearMonth()Id (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 ForeignKey because of: Potential foreign key traversals 'OrderDate.YearMonth()Id' was not understood, starting from initialType 'PRich'.0x000D0x000AInvalid MemberEntityKey because of: Property 'OrderDate' not defined in schema for 'PRich' (enum 'PRichP.OrderDate' does not exist,0x000D0x000Aand also0x000D0x000AEntityMethodKey 'TryGetOrderDate' not defined for PRich0x000D0x000A0x000D0x000A0x000D0x000AThe 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, FactSurveyResponse0x000D0x000A0x000D0x000ASome 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 expression0x000D0x000A0x000D0x000AORDER BY OrderDate.YearMonth()Id0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000AOrderDate.YearMonth()Id0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AIrrelevant to call TryGetP for this class (PValue0x003CBoolean0x003E). Parameters: k: OrderDate.YearMonth()Id (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 ForeignKey because of: Potential foreign key traversals 'OrderDate.YearMonth()Id' was not understood, starting from initialType 'PRich'.0x000D0x000AInvalid MemberEntityKey because of: Property 'OrderDate' not defined in schema for 'PRich' (enum 'PRichP.OrderDate' does not exist,0x000D0x000Aand also0x000D0x000AEntityMethodKey 'TryGetOrderDate' not defined for PRich0x000D0x000A0x000D0x000A0x000D0x000AThe 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, FactSurveyResponse0x000D0x000A0x000D0x000ASome 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).
ExecuteOne/_/47/CountAfter = 4
ExecuteOne/_/47/Finish = 2024-05-03 13:53:34.116
ExecuteOne/_/47/ElapsedTime = 00:00:00.001
ExecuteOne/_/47/Text = ------------------------------------------------------
Generated 2024-05-03 13:53:34.455 UTC