[ROOT]  dt  FactResellerSale  WHERE%20DimCurrency.AlternateKey%20EQ%20'CAD'  PIVOT%20OrderDate.Year()%20BY%20DimReseller.ProductLine%20SUM%20SalesAmount  SELECT%20*.TMB()%20AS%20*  ORDER BY OrderDate.Year()Id DESC  

ERROR:

At hierarhical level dt/FactResellerSale, key 'WHERE%20DimCurrency.AlternateKey%20EQ%20'CAD'' not found

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

Start of query expression 'WHERE%20DIMCURRENCY.ALTERNATEKEY%20EQ%20'CAD'' 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

Edit

Generated 2024-04-18 19:21:44.395 UTC