I am creating a parent-child hierarchy in my dimension. The AdventureWorks2012DW sample database is used. I have set the ParentEmployeeKey, NameColumn property to LastName as per the wrox sql server 2012 book. I have attached the Dimension Browser Image.enter image description here

I am getting the Employee Key instead of LastName


I just had to change the Employee Display NameColumn to LastName. And it worked!!! Thanks!!

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.