Hi,

Is there a way to determine what time period a member represents?

Thanks

If you're using AS 2005, the value of members of a time hierarchy can be
of type date, as in Adventure Works:

'[Date].[Date].CurrentMember.MemberValue'

select {[Measures].[DateVal]} on 0,
Tail([Date].[Date].[Date].Members, 10) on 1
from [Adventure Works]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Thanks Deepak,

And what if I'm using Analysis Services 2000?

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

With AS 2000, since there is no official "member value", I'm not aware
of one standard solution. Some of the options that I've seen are:

- Parse time member name into date, using VBA functions
- Add a specific Member Property to hold a date string
- Use the MDX Rank() function for relative position


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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