[ROOT]  dt  DimEmployee  SELECT%20Name,%20ParentEmployee.Name,%20ChildEmployee.Name.Count()%20AS%20DirectSubordinates  ORDER%20BY%20DirectSubordinates%20DESC  THEN%20BY%20Name  TITLE Employees with Supervisors and Subordinates  

ERROR:

At hierarhical level dt/DimEmployee, key 'SELECT%20Name,%20ParentEmployee.Name,%20ChildEmployee.Name.Count()%20AS%20DirectSubordinates' not found

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

Start of query expression 'SELECT%20NAME,%20PARENTEMPLOYEE.NAME,%20CHILDEMPLOYEE.NAME.COUNT()%20AS%20DIRECTSUBORDINATES' 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

Edit

Generated 2024-04-18 01:09:43.000 UTC