Hi,
Suppose I have to design a datamart for a transportation company. I want to trace the quantity of passengers moving from place to place, using my buses.
My fact table will have one row for each trip of my buses. Will look like:
- Date_ID (from date dimension)
- Origen city (from Region dimension)
- Destination city (again from Region dimension)
- Quantity of pasengers (this is my measure)
But both Origen city and Destination city refer to the same REGION Dimension and I would like to know how to tell Analysis Services to deal with two dimensions which are really the same but twice.
I did two separate views pointing to the same REGION table and that seems to work, but isn't really awful ?
Any clue would be appreciated.
Thank you.
//jcoira
Suppose I have to design a datamart for a transportation company. I want to trace the quantity of passengers moving from place to place, using my buses.
My fact table will have one row for each trip of my buses. Will look like:
- Date_ID (from date dimension)
- Origen city (from Region dimension)
- Destination city (again from Region dimension)
- Quantity of pasengers (this is my measure)
But both Origen city and Destination city refer to the same REGION Dimension and I would like to know how to tell Analysis Services to deal with two dimensions which are really the same but twice.
I did two separate views pointing to the same REGION table and that seems to work, but isn't really awful ?
Any clue would be appreciated.
Thank you.
//jcoira