PDA

View Full Version : .descendants ???



uramisten
06-12-2003, 02:42 AM
I keep getting the following error:
no function matches signature '<Member>.descendants
when I try to do any query with a .descendents part to it.
eg: Time - I can query anything from [Time], down to [Time].[2002].[Q3].[8]
as in :
select {[Time].[2002].[Q3].[8]}on columns,
{[Benchmark]} on rows
from [TB]
but I can't do : [Time].[2002].descendants to get multiple columns... what am I missing? I am using a time_by_day table almost as in the foodmart example, and the time dimension as from the Foodmart.xml (for time_by_day) but without the text info for weekdays (eg 'monday' etc). I am having this problem with all my dimensions.. .. :((
Help!!
Thnx
Ati

jhyde
06-12-2003, 05:13 AM
The Descendants function requires function syntax, not property syntax. You should write
DESCENDANTS([Time].[2002].[Q3].[8])
See
http://msdn.microsoft.com/library/en-us/olapdmad/agmdxfunctions_5iib.asp