/ dt / FactResellerSale / PIVOT%20DimReseller.FirstOrderYear%20BY%20DimReseller.ProductLine / ORDER BY DimReseller.FirstOrderYearId

ORDER BY DimReseller.FirstOrderYearId

[ROOT]  dt  FactResellerSale  PIVOT%20DimReseller.FirstOrderYear%20BY%20DimReseller.ProductLine  ORDER BY DimReseller.FirstOrderYearId  

ERROR:

At hierarhical level dt/FactResellerSale, key 'PIVOT%20DimReseller.FirstOrderYear%20BY%20DimReseller.ProductLine' not found

In case you attempted to supply a QueryExpression, this error message may be of help:

Start of query expression 'PIVOT%20DIMRESELLER.FIRSTORDERYEAR%20BY%20DIMRESELLER.PRODUCTLINE' 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

Use this link to see available keys at this level:

FactResellerSale

Generated 2024-04-29 02:15:39.562 UTC