MDX2005 fiter a set on member property -
06-01-2006
, 10:36 AM
Hi,
In 2000 I ofter created YTD/MAT measures by filtering the time dimension on
a member property called current. I am trying to utilise the same
functionality in 2005 but can not get it to work.
The problem seems that you need now to use the properties function with a
member rather than a level. ie.
In 2000 it would be
filter(timedim.week.members,timedim.properties("cu rrent")="1").item(0))
This same syntax in 2005 will return an error stating that properties must
be used with a member rather than a level
I woul really appreciate any help on this or another way of creating YTD
type measures that don't require a user to make time selection.
Thanks,
JJ |