Using Foodmart, I need to display all Stores with some detailed information
and Unites Shipped based on Quarters. Here's a list of the items I need:

Columns:
"1998 Q1 Units Shipped"
"1998 Q2 Units Shipped"
"1998 Q3 Units Shipped"

Rows:
"Store City"
"Store Name"
"Store SqFt"

Here's what I got so far:
SELECT
{[Measures].[Units Shipped]} ON COLUMNS,
NON EMPTY [Store].[Store Name].MEMBERS DIMENSION PROPERTIES
[Store].[Store Name].[Store Sqft] ON ROWS
FROM
Warehouse


-----------------------------------
Any help will be greatly appreciated.
Thanks

Francisco Alvarado

Hello Francisco,

You could try the following MDX:

SELECT
{[Time].[1998].[Q1], [Time].[1998].[Q2],[Time].[1998].[Q3]} ON COLUMNS,
NON EMPTY [Store].[Store Name].MEMBERS DIMENSION PROPERTIES
[Store].[Store Name].[Store Sqft] ON ROWS
FROM
Warehouse
where [Measures].[Units Shipped]

Hope this is helpful. Have a great day!

Thanks & Regards,

Peter Yang
MCSE2000, MCSA, MCDBA
Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security

================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------

Peter,

This is very very close to what I need.
Because of a very specific need I have to run this MDX query thru a Stored
Procedure. When I do, the only thing left from the store information is the
"Store SqFt". Is there any way to also get the "Store City" and the "Store
Name"?
You can run this in Query Analyzer to see what I mean.

SELECT a.* FROM OpenRowset('MSOLAP','DATASOURCE=olapdev1; USER ID=;
PASSWORD=;Initial Catalog=[Foodmart 2000];',
'
SELECT
{[Time].[1998].[Q1], [Time].[1998].[Q2],[Time].[1998].[Q3]} ON COLUMNS,
NON EMPTY [Store].[Store Name].MEMBERS DIMENSION PROPERTIES
[Store].[Store Name].[Store Sqft] ON ROWS
FROM
Warehouse
where [Measures].[Units Shipped]
') as a
go

Any additional help will be greatly appreciated




"Peter Yang [MSFT]" wrote:

Hi Francisco and Peter,

This version of Francisco's Foodmart SQL query returns the Store City
and Store Name as well, though the column names in Query Analyzer is
[Store].Name] for both:

PASSWORD=;Initial Catalog=[Foodmart 2000];',
'
SELECT
{[Time].[1998].[Q1], [Time].[1998].[Q2],[Time].[1998].[Q3]} ON COLUMNS,
NON EMPTY [Store].[Store Name].MEMBERS DIMENSION PROPERTIES
[Store].[Store City].[Name],
[Store].[Store Name].[Name],
[Store].[Store Name].[Store Sqft] ON ROWS
FROM
Warehouse
where [Measures].[Units Shipped]
') as a
go

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!