Role playing dimensions with SSAS
Role playing dimensions in SSAS are very useful. Lets say you have a fact table with LandingPagePathId, ExitPagePathId, PagePathId. Now in your database you only need to have one dimension table dPath. All your paths are then stored in the same table. We only need to have one […]