Also, from a design perspective, I would have only one PHYSICAL dimension for the airport and use role playing dimensions.....one for the departure city and one for the arrival city. I cannot tell if that's what you did here on not.

Also, from a design perspective, I would have only one PHYSICAL dimension for the airport and use role playing dimensions.....one for the departure city and one for the arrival city. I cannot tell if that's what you did here on not.

As far as I can tell, there is only one physical dimension (DimCity).How can I tell if these are 'role playing' dimensions?

If you just wanted one cell to display as an answer, I would put the destination city member of Seattle and the departure city member of Seattle in the WHERE clause and just ask for the FlightTime aggregate on columns.

sneumersky (1/31/2014)If you just wanted one cell to display as an answer, I would put the destination city member of Seattle and the departure city member of Seattle in the WHERE clause and just ask for the FlightTime aggregate on columns.

It all depends on what you want as row and column headers.

Good point.Assume I want the following, as column headers:

DateDeparture CityArrival CityTime In Flight

As I mentioned, it's sort of a line/detail report - there's not much analysis going on.

sneumersky (1/31/2014)If you just wanted one cell to display as an answer, I would put the destination city member of Seattle and the departure city member of Seattle in the WHERE clause and just ask for the FlightTime aggregate on columns.

It all depends on what you want as row and column headers.

Good point.Assume I want the following, as column headers:

DateDeparture CityArrival CityTime In Flight

As I mentioned, it's sort of a line/detail report - there's not much analysis going on.