|
Home > Archive > MS SQL Server OLAP > December 2005 > MDX Query and Foodmart2000 Cube Question
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]
| Author |
MDX Query and Foodmart2000 Cube Question
|
|
| john.r.carter@bankofamerica.com 2005-12-30, 8:23 pm |
| I am trying to get this query to work against the foodmart2000 cube.
Can anyone help me w/ it? I would like three dimensions on rows.
SELECT { [Measures].[Unit Sales],[Measures].[Store
Sales],[Measures].[Store Sales Net] } ON COLUMNS,
{[Product].[Product Family].Members,[Gender].[Gender].Members,[Marital
Status].[Marital Status].Members} on ROWS
FROM [Sales]
Thanks in advance,
John C
| |
|
| Try this one, i hope this will solve your problem
---------------------------------------------------------------------------------------------------------------
SELECT
{
[Measures].[Unit Sales],[Measures].[Store Sales],[Measures].[Store
Sales Net]
} ON COLUMNS,
{
Crossjoin( Crossjoin([Product].[Product
Family].Members,[Gender].[Gender].Members ) ,[Marital Status].[Marital
Status].Members )
}
ON ROWS
FROM [Sales]
---------------------------------------------------------------------------------------------------------------
Faraz
|
|
|
|
|