[ROOT] PIVOT%20DimCustomer.Name+','+DimCustomerId%20BY%20OrderDate.Year()%20SUM%20SalesAmountController
ERROR:
At hierarhical level [ROOT], key 'PIVOT%20DimCustomer.Name+','+DimCustomerId%20BY%20OrderDate.Year()%20SUM%20SalesAmountController' not found
In case you attempted to supply a -QueryExpression-, this error message may be of help:
Start of query expression 'PIVOT%20DIMCUSTOMER.NAME+','+DIMCUSTOMERID%20BY%20ORDERDATE.YEAR()%20SUM%20SALESAMOUNTCONTROLLER' 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 17:46:47.926 UTC