Forum Discussion

knight4life's avatar
knight4life
Regular Visitor
5 years ago
Solved

Visual to include values from 2 databases

I am trying to create a report function to analyze our phone system call logs. I have most of it already configured with 1 Table visual that includes User Number, placed calls, missed calls, received...
  • lbendlin's avatar
    lbendlin
    5 years ago

    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.

     

     

  • lbendlin's avatar
    lbendlin
    5 years ago

    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.

lbendlin's avatar
lbendlin
Super User
5 years ago

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.

 

 

knight4life's avatar
knight4life
Regular Visitor
5 years ago

 if I want to pull the username from EmployeeDB to display on the corresponding row of my visual do I create a many to one relationship between the User Number? Here is an example of my data:

 

EmployeeDB

UserNumber: 01

UserName: user 1

 

CallLogDB

UserNumber: 1

CallDuration: 05

CallDirection: Placed

 

Visual will show UserNumber, CallDuartion, and CallDirection, but I also need it to show the corresponding username.