Hi, MDX gurus,

I have a unexplainable problem with pretty easy MDX.

Following MDX queries

//
select
Filter([Date].[Date].members,
[Date].[Date].CurrentMember.MemberValue = VBA![dateadd]("yyyy", -2,
VBA![Date]()) )
on 0,
{} on 1
from [Adventure Works]
//
select
Filter([Date].[Date].members,
[Date].[Date].CurrentMember.MemberValue = CDate("11.07.2004"))
on 0,
{} on 1
from [Adventure Works]

provide the same result as expected.



This query
//
select
Filter([Date].[Calendar].[Month].members,
[Date].[Date].CurrentMember.MemberValue = CDate("11.07.2004"))
on 0,
{} on 1
from [Adventure Works]

returns as expected one member

but this query
select
Filter([Date].[Calendar].[Month].members,
[Date].[Date].CurrentMember.MemberValue = VBA![dateadd]("yyyy", -2,
VBA![Date]()) )
on 0,
{} on 1
from [Adventure Works]

retuns nothing. This is strange, isn't it?
Can anybody explain it?

Thanks in advance,

Vladimir Chtepa

Hi Vladimir,

I can't explain the discrepancy, but am wondering why you say that:

//
select
Filter([Date].[Calendar].[Month].members,
[Date].[Date].CurrentMember.MemberValue = CDate("11.07.2004"))
on 0,
{} on 1
from [Adventure Works]

returns as expected one member

Since the [Date].[Date] attribute is at a finer granularity than
[Date].[Calendar].[Month], I would expect the [All] member to be the
[Date].[Date] current member, as in this query; so I don't understand
how your query finds a match:

[Date].[Date].CurrentMember.MemberValue
select
{[Measures].[DateValue]} on 0,
[Date].[Calendar].[Month].members on 1
from [Adventure Works]
---------------------------------------
DateValue
July 2001 All Periods
August 2001 All Periods
September 2001 All Periods
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Why are you woundering from my words?

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote