|
Home > Archive > MS SQL Server OLAP > April 2005 > Dimension header?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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
| |
| Deepak Puri 2005-04-26, 8:24 pm |
| 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:
> 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 ***
>
|
|
|
|
|