/ dt / FactInternetSale / WHERE%20DimCurrency.AlternateKey%20=%20'AUD' / PIVOT%20DimCustomer.Name+','+DimCustomerId%20BY%20OrderDate.Year()%20SUM%20SalesAmount / ORDER BY 2020 / TAKE 1000
TAKE 1000
[ROOT] dt FactInternetSale WHERE%20DimCurrency.AlternateKey%20=%20'AUD' PIVOT%20DimCustomer.Name+','+DimCustomerId%20BY%20OrderDate.Year()%20SUM%20SalesAmount ORDER BY 2020 TAKE 1000
ERROR:
At hierarhical level dt/FactInternetSale, key 'WHERE%20DimCurrency.AlternateKey%20=%20'AUD'' not found
In case you attempted to supply a QueryExpression, this error message may be of help:
Start of query expression 'WHERE%20DIMCURRENCY.ALTERNATEKEY%20=%20'AUD'' 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-05-06 03:25:57.615 UTC