/ dt / PIVOT OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount / UseCache
UseCache
[ROOT] dt PIVOT OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount PIVOT OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount
ERROR:
Query expression
UseCache
failed to parse with the following error response:
Start of query expression 'USECACHE' 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 OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount'.
(NOTE. After the first valid QueryExpression, all following items in the request must also be valid query expressions)
Generated 2024-09-28 22:28:39.272 UTC