How can I add drill down to the HOUR using the relationship between my tables?

[ERing]

I am analyzing some call data and I'd like to be able to drill down to the hour level to see what hours calls are coming in. I've created a Date_Table and have a realtionship to DIM_C based on CALL_DATE. The DIM_C table also has a CALL_HOUR field that provides the hour of each call.

Do I need to have an hour column present in my Date_Table or can I simply add the CALL_HOUR to the X-axis well of my visuals? My concern is that the fields from the X-axis would be coming from two different tables and I'm not sure if that will allow the drill down to work correctly.

[parry2k]

@ERing add a time dimension at the granularity you want to see your data, I guess it is an hourly, set relationship with your transaction table and you can use hour from this new dimension in the well after the date and you will able to drill down to the hourly level.

[ERing]

@parry2k This is how I have it currently set up.

Does it matter that the Year, Quarter, Month, Week, & Date fields in the a-axis well are coming from the Date_Table while the Hour field is coming from my transaction table? I have a relationship between my transaction table and my Date_Table.