MDX Sample Query CrossJoin

[Angela666]

I was reading the MDX Essentials tutorial on CrossJoin. The author showed the following crossjoin example:
http://www.databasejournal.com/img/DJ_MDX18-002.jpg

Can anyone tell me how I would instead do the following?

	CA	OR	WA
Q1	9,616	14,890	20,557
Q2	13,107	16,462	20,931
Q3	16,052	16,404	14,984
Q4	17,351	11,222	26,919

The numbers represent the Units Shipped (same as example) but the rows show the quarters and the columns show the states.

[Island1]

Hi:

Try this:

-- Example Angela Query

SELECT

CROSSJOIN(

{[Warehouse].[Country].[USA].Children},

{[Measures].[Units Shipped]})

ON COLUMNS,

{[Time].[Year].[1998].Children}

ON ROWS

FROM

[Warehouse]

Again, from the FoodMart 2000 AS DB.

Let us know how it goes ...

Bill

[Island1]

Just wondering if I understood the requirement ...

Bill

[Angela666]

That worked great, thanks Bill.

[Island1]

Be sure to let us know how things are going - and if you need further help within the integrated MS BI solution.

Bill