/ dt / FactInternetSale / WHERE DimCurrency.AlternateKey EQ 'USD' / PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount / Queries

Queries

[ROOT]  dt  FactInternetSale  WHERE DimCurrency.AlternateKey EQ 'USD'  WHERE DimCurrency.AlternateKey EQ 'USD'   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   

ERROR:

Query expression

Queries

failed to parse with the following error response:

Start of query expression 'QUERIES' 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 2025-12-21 05:51:29.039 UTC