SSAS/Kimball : building a multivalue dimension construction in SSAS
During the development of a dashboard for a customer i've a awkward problem. The situation is like this: There are events in the every daily business (fact) and these events can happen on certain locations (physical) locations. These locations can be shared by different (logical) departments. So conceptually you have something like this: