dbTalk Databases Forums  

MDX2005 fiter a set on member property

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


Discuss MDX2005 fiter a set on member property in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
=?Utf-8?B?SmFtZXMgSm9uZXM=?=
 
Posts: n/a

Default 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

Reply With Quote
  #2  
Old   
Dennebom
 
Posts: n/a

Default Re: MDX2005 fiter a set on member property - 06-06-2006 , 09:20 AM






Hi JJ

I want to now how you did this in 2000
See my post in this group. Maybe you can help me.

http://groups.google.nl/group/micros...2e965e85909f4f

thnx
D.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.