Forum Discussion
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...
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.
lbendlin
Super User
Super UserThis generally depends on the visual you are using, but keep in mind that measures are computed for each cell of the visual, including the data cells, the row and column totals, and the grand total. That allows you to influence what to show where (or not to show, by returning BLANK() ).