Newbie MDX Date

#1

In TSQL, we can select data in a specified date range,
such as (DB:Northwind)

SELECT * FROM Employees
WHERE Hiredate > ='01/01/1988'
AND Hiredate < ='12/31/1998'

How to define the date range in MDX in the date demension:
.. > ='01/01/1988'
.. <='12/31/1998'

#2

specify a set using the range operator which separates two tuples using a
colon ':'

{[Time].[1998]:[Time].[2003]}

"John Chen" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

In TSQL, we can select data in a specified date range,
such as (DB:Northwind)

SELECT * FROM Employees
WHERE Hiredate > ='01/01/1988'
AND Hiredate < ='12/31/1998'

How to define the date range in MDX in the date demension:
.. > ='01/01/1988'
.. <='12/31/1998'

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

Newbie MDX Date

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

Newbie MDX Date - 12-05-2003 , 11:27 AM

Re: Newbie MDX Date - 12-05-2003 , 11:38 AM