/ 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)
TITLE Reseller sales pr Sales territory country and year (note inclusion of currency for 'safety' reasons)
[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:
Generated 2024-04-28 12:33:12.048 UTC