I have a simple query

SELECT [Measure].[Measure 1], [Measure].[Measure 2] ON 0,
{[Brand].[Brand A], [Brand].[Brand B]} ON 1
FROM Cube

that outputs a table

BRAND - Measure 1 - Measure 2
Brand A - 100 - 200
Brand B - 50 - 150

But I want it to look like this

MEASURE - Brand A - Brand B
Measure 1 - 100 - 50
Measure 2 - 200 150

Any ideas how to do this?

Thanks

Denver

Sorry I am not being an idiot its to do with Reporting Services

This query works in the last version

SELECT ({[Brand].[Brands].[BrandFamily].&[89],
[Brand].[Brands].[BrandFamily].&[22]}) ON 0,
UNION([Measures].[Consider To Buy], [Measures].[Dislikes]) ON 1
FROM [Brand Equity Consumer]

But not in this version

Anyone know why and is there anyway around it?

Denver

Probably you're using the Analysis Services Provider, which only allows
measures on the columns of an MDX query. You can still use the original
OLE DB for OLAP Provider from RS 2000 days - this will allow measures on
rows, but doesn't directly support MDX parameters (you have to build the
query as an expression, like with RS 2000):

http://spaces.msn.com/cwebbbi/blog/cns!7B84B0F2C239489A!412.entry
In RS2005 you are always forced to put the Measures dimension on the
columns axis in your queries if you're using a data source of type
'Microsoft SQL Server Analysis Services' (you can still get the glorious
AS/RS2K experience if you use an OLEDB connection instead along with the
AS OLEDB Provider).
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***