[ROOT]  dt  FactResellerSale  PIVOT%20DimSalesTerritory.Name+'_'+DimCurrency.Name%20BY%20OrderDate.Year()%20SUM%20SalesAmount  TITLE Reseller sales pr Sales territory country and year (note inclusion of currency for 'safety' reasons)  

ERROR:

At hierarhical level dt/FactResellerSale, key 'PIVOT%20DimSalesTerritory.Name+'_'+DimCurrency.Name%20BY%20OrderDate.Year()%20SUM%20SalesAmount' not found

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

Start of query expression 'PIVOT%20DIMSALESTERRITORY.NAME+'_'+DIMCURRENCY.NAME%20BY%20ORDERDATE.YEAR()%20SUM%20SALESAMOUNT' 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-03-28 12:27:53.901 UTC