I am trying to write a type of movement function that works with the timedim.
here is what i have.....
iif([TimeDim].CurrentMember.Count>0,
[%ACCOUNT%]-([%ACCOUNT%],[TimeDim].PrevMember),
[%ACCOUNT%]-([%ACCOUNT%],[TimeDim].Parent.PrevMember)
)

I am currently getting this error..
cannot convert member to Tuple - in a <dimension>.<property> function

Assuming that there is a measure like Count (which isn't clear from the
limited info provided), then maybe:

[%ACCOUNT%]-([%ACCOUNT%],[TimeDim].PrevMember),
[%ACCOUNT%]-([%ACCOUNT%],[TimeDim].Parent.PrevMember)
)

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

As Deepak says it is not entirely clear what you are trying to do, if
you are trying to detect if the current time member has children then
the following might work.

[%ACCOUNT%]-([%ACCOUNT%],[TimeDim].PrevMember),
[%ACCOUNT%]-([%ACCOUNT%],[TimeDim].Parent.PrevMember)
)
Although if that were the case I would suspect you are trying to check
whether you are at a specific level in which case the following is
probably a better way to go.

[%ACCOUNT%]-([%ACCOUNT%],[TimeDim].PrevMember),
[%ACCOUNT%]-([%ACCOUNT%],Ancestor([TimeDim].CurrentMember, Month))
)
--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Can't believe I overlooked Children!

"Darren Gosbell" wrote: