MDX: select date member property

Last Post 28 Jun 2006 12:46 PM by PaulMcKibben. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

23 May 2006 03:01 AM


Dimensions: accounts [accounts].[accountnumber].CurrentMember.Properties("ExpDate")
date, with Year,Querters,Months,Weeks,Days

Pleas don't discus that I use ExpDate as a Property.

Now my question.
I want to select all account numbers that have a ExpDate in the Current selected Month.
I searched the net on the filter function. But I found only examples with hardcoded code in it.
Lik [accounts].[accountnumber].CurrentMember.Properties("ExpDate") = '01011999'

Hope someone can help me.
New Member
New Member

28 Jun 2006 12:46 PM
You might try a AS named set of current month.

Acceptable Use Policy