Hi,

I have a cube with a dimension which is a PARENT-CHILD hierarchy. As an
analogous concept that we can all understand, think of an Employee and
Manager hierarchy. The Employee table has a column called ManagerID.
The Managers themselves exist in the Employee table with an Employee
ID.

I have developed a cube which has a dimension that shows this
hierarchy. But my PROBLEM is that the display in the client tools shows
the Employee IDs instead of Employee Names. I have added the Enmployee
Name as an additional attribute in the dimension, but the SQL Browser
(or any other client display tool I have used) displays the key filed
of Employee ID in the hierarchy, which is meaningless to an end-user,
who instead is interested in looking at Employee Names and the names of
the their supervisors.

How can/should I develop the SQL Server Analysis service cube
dimensions so that I can get the display to have names instead of IDs?

Any help or direction would be tremendously appreciated!

Thanks!

You can examine how the Employee dimension is configured in Adventure
Works (if you're using AS 2005). For AS 2000, the Foodmart database
includes the Employees parent-child dimension. In either case, Employee
Names rather than ID's are displayed when browsing, as desired by you.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***