hi,
my date dimension has parent child relation. The levels are year,
quarter and month. I'm applying a custom rollup condition ..its working
on year and month. But its ignoring the quarter level. I think its
because my quarter format is "2004Q1".Thats y it may not be recognizing
"Q". How can i change my query to recognize the quarter level too.This
is my query:

YEAR AND MONTH WRKING:
iif([Date].[Fiscal Month SC].CurrentMember.Level.Ordinal <=
[Date].[Fiscal Month SC].[Level 05].Ordinal,iif(FORMAT([Date].[Fiscal
Month SC].currentmember.Name,"YYYYMM")
<"200406",CalculationPassValue([Product
Line.Ctg].CurrentMember.DataMember, 0),0.4),0.1)

Thanks for any suggestions.

Neo

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!