[ROOT]  PIVOT%20OrderDate.YearMonth()%20BY%20DimCurrency.AlternateKey%20SUM%20SalesAmountController  

ERROR:

At hierarhical level [ROOT], key 'PIVOT%20OrderDate.YearMonth()%20BY%20DimCurrency.AlternateKey%20SUM%20SalesAmountController' not found

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

Start of query expression 'PIVOT%20ORDERDATE.YEARMONTH()%20BY%20DIMCURRENCY.ALTERNATEKEY%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:

[ROOT]


Generated 2024-04-27 09:47:30.028 UTC