Forum Discussion
Visual to include values from 2 databases
Yes, this is a standard feature. Use the data model view to link the tables together. Then you can add the needed columns to the visual.
your "employeedb" table will act as the dimension table because each user appears there only once, and your "callogdb" table will act as the fact table as you can have from zero to many calls per user.
The relationship will be 1:* from employeedb to callogdb, linked by the usernumber.
Super Useryour "employeedb" table will act as the dimension table because each user appears there only once, and your "callogdb" table will act as the fact table as you can have from zero to many calls per user.
The relationship will be 1:* from employeedb to callogdb, linked by the usernumber.
Ok, I have that now. Should I just be able to drag the field of Username from EmployeesDB onto the visual that already had the fields from the calllogsdb? When I do that, it just repeats the username's from employeeDB over and over again instead of matching the usernames to the correct instance on the visual.
Thank you,
