Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  Parent-child employee dimension MDX

Author  Topic  boilerAZ Starting Member 1 Post Posted - 2012-02-24 : 11:53:07 I have an Employee Dimension that is a parent-child that is very similar to the AdventureWorks, with an EmployeeKey and a ManagerKey. This contains all of the employees for the company, spread across multiple divisions. Note the division and group names are not in the dimension (or source data :-() I am trying to create a name set for a Sales Team that starts at an employee (Jane Smith). I tried using the Descendants Function, but it breaks the parent child relationship and just creates a list. Descendants([Owner].[Employees].[Jane Smith]) I would like to have the named set start with Allison and contain her employees, but still retain the parent/child relationship. Any advice? Amy