hi folks,
I was wondering if there is currently another method to join smaller fact tables to common dimensions (say "Employees") whereas when looking at the smaller fact tables, the common dimension can surface a smaller universe of the particular dimension (say "Employees"), other than the old,fashioned way of instantiating another dimension, by a different name?
Reason being, I have large fact tables with the entire universe of "Employees" however also smaller ones that deal with just a fraction of the Employees universe, but would like to keep the dimension name consistent (preferably the same) for the small fact tables also.
many thanks,
Cos