Hi,
I'm a MDX newbie and trying to define a simple MDX-select statement. Is it
possible to add dimension and level headers on top of the matrix, like in
typical Excel pivot tables?

thanks in advance
KM

What OLAP client tool are using to display MDX query results (since
result formatting depends, to some degree, on the client)? Also, can you
be more specific about the desired layout, like giving an example from
Foodmart?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

The "client" tool is Reporting Services and the example could be the Foodmart
sample within Reporting Services. If you look to the result, the dimension on
the row has no "headers" like e.g. "Product". To be sure, here is the
MDX-query used by the sample:

SELECT { [Measures].[Store Sales], [Measures].[Store Cost] } ON COLUMNS,
{ Descendants([Product].[All Products], [Product].[Brand Name], LEAVES) }
ON ROWS,
{ Time.[1997].[Q1],Time.[1997].[Q2],Time.[1997].[Q3],Time.[1997].[Q4] } ON
PAGES
FROM Sales

"Deepak Puri" wrote: