Top Tip: How to use the same dimension twice on one fact table with SQL Server 2000 Analysis Services

  • Article

I’m grateful to Cristian Petculescu for this Top Tip: How to use the same dimension twice on one fact table with SQL Server 2000 Analysis Services.

To use the same dimension twice, against one fact table, you essentially use the same dimension table only with a new alias to reference it by. To do this copy the dimension (right click it in Analysis Services Manager) and then paste it back in again. At this point it will tell you you already have a dimension by that name, so you edit the name it presents in the dialog box to a new name (thereby creating an alias).

Now in SQL Server 2005 it will let you do this with the same dimension natively without the alias.