Hi,

I need to write a custom rollup formula . My requirement is , I need to
apply this formula after a particulardate like june2003. My actual
formula is
iif(FORMAT([Date].[Fiscal Month SC].currentmember.Name,"YYYYMM")
<"200406",CalculationPassValue([Product
Line.Ctg].CurrentMember.DataMember, 0),RollupChildren([Product
Line].[Ctg].CurrentMember,[Product
Line].[Ctg].CurrentMember.Properties("+")))

I'm testing it using

iif(FORMAT([Date].[Fiscal Month SC].currentmember.Name,"YYYYMM")
<"200406",CalculationPassValue([Product
Line.Ctg].CurrentMember.DataMember, 0),1) with out including
rollupchildren. This is working for me with that level only and if i
drill to the upper level its not owrking for me and if select any month
in 2003 then also its not working..I know i'm wrong with the format
function..

could anyone plz help me to correct this one.


and regarding the rollupchildren unary operator is not working for me
even after i make my dimension write enable.i tried creating a new
column but its giving an error msg to me like cannot connect to oracle.
if at all i created the unary operator, customrollupformula for the
dimension is disabled..some times its giving a msg like "Not a valid
parent child relation".do i need to do it in some other way ??

Thanks in advance

Neo

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

Do you really have member property called "+" ? I don't think yon create
member property with such name...

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

I think i'm just using a unary operator there .

http://msdn.microsoft.com/library/de.../en-us/olapdma
d/aghtdimopt_6t2m.asp

http://msdn.microsoft.com/library/de.../en-us/olapdma
d/aglevels_344z.asp

ok, I think i must use (unary_operator) instead of (+).

But i'm stuck up in my first query itself.. i couldnt apply the
condition in the higher levels.. its not working for me in higher
levels. i'm facing a big problem with my date dimension.. its hierarchy
is year, quarter, month . my query is working fine in the year level and
in the month level but its not working with the quarter level ...and i
think i need to make some changes to the logic too.. cos its working for
2004 only... if its for 2003, then its not working.

Any suggestion ???
Neo

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