I have kind of a fundamental design question: In my DWH are 2 tables TICKET and EMPLOYEE. EMPLOYEE is referenced by TICKET 2 times: TICKET_OWNER_ID and TICKET_ASSIGNED_TO_ID.
I have created a Ticket and a Employee dimesion in my SSAS Project. The Ticket Dimension should no have two atrributes: Owner and Assigned To. I can create the attributes by dragging the EMPLOYEE.NAME column from the DSV window into the attributes
list but there is now to specify which relation will be used.
And of course I get pretty intresting results when I process the dimension.
I could create a named query in the DSV selecting * from EMPLOYEE and create a second Employee dimension but is that the only way I can get this to work ?
View Complete Post