I found this mdx query online. It's a good start for what I need, but I
want some extra columns.
This code gets me the "Store Sqft" but I also need "Store City" and
"Store Name" in the same result set. I also need the "Units Shipped"
measure but accross Quarters.
So basically I need to see
"Store City" | "store name" | "store sqft" | "[2002][Q1] Units Shipped"

SELECT
{[Measures].[Units Shipped]} ON COLUMNS,
NON EMPTY [Store].[Store Name].MEMBERS DIMENSION PROPERTIES
[Store].[Store Name].[Store Sqft] ON ROWS
FROM
Warehouse


-----------------------------------
Any help will be greatly appreciated.
Thanks

Francisco Alvarado