Yes, it’s definitely doable. I use this technique regularly in my reports, though it often requires some level of denormalization of the dimension tables. The other way to accomplish this is through the use of bidirectional relationships, though that is definitely NOT a recommended approach. Please see the thread below for more information on this issue, including an excellent article on the perils of bidirectional relationships.