MDX: select date member property

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

--
23 May 2006 03:01 AM
Hello,

Example:

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.
PaulMcKibben
New Member
New Member

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


Acceptable Use Policy
---