(SQL Server 2005)
I have a customer data warehouse table that I am loading into a customer dimension. Each row in the warehouse has a unique integer key. It is possible to have multiple rows with the same customer name. Each row will have an account code
and an alternate account code. Besides the key field, Name + Account + Alternate is what makes a row unique.
Once I process the table into the warehouse it looks like I am only getting one entry in the dimension based on customer name. It is difficult to browse dimensions and tell exactly what is there. I've tried setting up a plain demision and
also adding Account code and Alternate account codes as attribute relations under Name. I've also tried a hierarchy with Name -> Account -> Alt Account.
I have a customer with 2 account codes and multiple Alternate codes - 29 rows in the warehouse. When I browse I only get one result for name - I want to see 29 names all the same. Do I need to set up the dimension somehow to use Name+Account+Alternate
as the key? Currently I am using the warehouse key field as the key.
View Complete Post