I need some basic help with SSAS 2012. I have my employees dimension. Here is an example:
Here is my hierarchy, the default one when creating the dimension:
My problem is that when querying the cube through excel, when showing only the name, it appears twice. I know it has two different IDs, but I am not showing the ID, just the Name in the columns and a value in the Metrics. It appears like this:
How do I make it group correctly?
Thanks
Change the KeyColumns of the Employee Code attribute to just the Employee Code field (the column called Name on your table). Including Employee Key as the key in the Employee Code attribute is the issue. It should just be in the KeyColumns for the EMPE KEY attribute.