I have a flight Dimension
Where Flight dimension is the following hierachy
Origin
Destination
FlightNumber

SELECT {[Measures].[Bookings]} ON COLUMNS
, { Descendants([Flight].[All Flight],3)} ON ROWS
FROM [FlightFact]
WHERE [DepartureDate].[Date Value].&[3/1/2004]


I would like to display in Columns
the full hiearchy plus the booking measure:
LAX DEN 100 136

anyone point me in the right direction. I would like to avoid using Calculated measures

Try using PROPERTIES

SELECT {[Measures].[Bookings]} ON COLUMNS
, { Descendants([Flight].[All Flight],3)}
PROPERTIES [Flight].[Origin].Name, [Flight].[Destination].Name,
[Flight].[FlightNumber].Name
ON ROWS
FROM [FlightFact]
WHERE [DepartureDate].[Date Value].&[3/1/2004]

The properties keyword does not work in the MDX sample app, but it
does return the column values using OleDb

Mark


"Jason" <anonymous (AT) discussions (DOT) microsoft.com> wrote