where a range of Quarter?

#1

The MDX below can select from one quarter
But if I want to select from a range of quater, say Q1..Q3, how can I do?

------------------MDX----------------------------------------------------
SELECT non empty {(measures.members)} on Columns,
NON EMPTY [Store].members on Rows
FROM [Sales]
where [Time].[1997].[Q1]

#2

Create an aggregate member with the range and use the member in the slicer
dimension.

WITH MEMBER [Time].[1997Q1thruQ3] AS 'Aggregate({
[Time].[Q1]:[Time].[Q3] } )'
SELECT NON EMPTY { [Measures].Members } ON COLUMNS,
NON EMPTY [Store].Members ON ROWS
FROM [Sales]
WHERE ( [Time].[1997Q1thruQ3] )

"ad" <ad (AT) wfes (DOT) tcc.edu.tw> wrote

Quote:

The MDX below can select from one quarter
But if I want to select from a range of quater, say Q1..Q3, how can I do?

------------------MDX----------------------------------------------------
SELECT non empty {(measures.members)} on Columns,
NON EMPTY [Store].members on Rows
FROM [Sales]
where [Time].[1997].[Q1]

#3

Thank!
Your answer is great!

"Martin Mason" wrote:

Quote:

Create an aggregate member with the range and use the member in the slicer
dimension.

WITH MEMBER [Time].[1997Q1thruQ3] AS 'Aggregate({
[Time].[Q1]:[Time].[Q3] } )'
SELECT NON EMPTY { [Measures].Members } ON COLUMNS,
NON EMPTY [Store].Members ON ROWS
FROM [Sales]
WHERE ( [Time].[1997Q1thruQ3] )

"ad" <ad (AT) wfes (DOT) tcc.edu.tw> wrote in message
news:uxwv$hhnEHA.324 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
The MDX below can select from one quarter
But if I want to select from a range of quater, say Q1..Q3, how can I do?

------------------MDX----------------------------------------------------
SELECT non empty {(measures.members)} on Columns,
NON EMPTY [Store].members on Rows
FROM [Sales]
where [Time].[1997].[Q1]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

where a range of Quarter?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

where a range of Quarter? - 09-19-2004 , 02:15 AM

Re: where a range of Quarter? - 09-19-2004 , 07:47 PM

Re: where a range of Quarter? - 09-20-2004 , 07:03 AM