/ dt / DimEmployee / WHERE%20Status%20=%20'Current' / AGGREGATE%20Department / ORDER BY _SUM DESC

ORDER BY _SUM DESC

[ROOT]  dt  DimEmployee  WHERE%20Status%20=%20'Current'  AGGREGATE%20Department  ORDER BY _SUM DESC  

ERROR:

At hierarhical level dt/DimEmployee, key 'WHERE%20Status%20=%20'Current'' not found

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

Start of query expression 'WHERE%20STATUS%20=%20'CURRENT'' 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:

DimEmployee

Generated 2024-04-29 07:38:03.419 UTC