I need to create a custom dimension to determine if an employee was in
training or not when displaying their statistics.

Basicly I have 7 cubes that roll into 1 virtual cube. Each of the
cubes has different types of data, but 3 dimensions are shared
throughout.

On my "Employee" table I have the following fields:

Site
Employee Name
Employee ID
Trainer Name
Training Start
Training End

This table is used for the Hierarchy dimension (as we are wanting to
view stats based off of trainer, not supervisor).

I also have my time dimension (Year, Month, Day and Year, Weekending,
Day).

I know that I could easily do this by creating a view, then using a
case statement within that view, to do this. I do not want to have to
go that route. We have approx 5000 employees and years of data to
review.

Is there a way to create dimension that takes the date value from my
time dimension and determines if that employee was in or out of
training (based on the start and end dates from the employee table)?

Thanks