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

AllLogEntriesForThisQuery

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

ERROR:

Query expression

AllLogEntriesForThisQuery

failed to parse with the following error response:

Start of query expression 'ALLLOGENTRIESFORTHISQUERY' not recognized. Must start with one of

----, AGGREGATE, ALL, CACHE, COMMENT, DATASTORAGE, HINT, LIMIT, LOG, ORDER (as in (OrderBy), PIVOT, REL, SELECT, SELFCREATE, SHUFFLE, SKIP, STRICT, TAKE, THEN (as in (ThenBy), TITLE, WHERE

Last query expression to successfully parse was 'PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount'.

(NOTE. After the first valid QueryExpression, all following items in the request must also be valid query expressions)


Generated 2024-06-02 04:22:01.241 UTC