Hi Elad,

Thanks for your help for calculating my cumulative percentage. Now i had
a problem with a custom rollup.
I need to get the values calculated condition in the customerollup in
the dim level.In my cube date,product parent child dims and3 measures
are present.The idea is it has to calculate the aggregate at heigher
levels in the dim based on the date condition.For example in my prod dim
it has one level,In my Date dim it has 3 diff levels like
YEAR,QUARTER,MONTH.i need to to get the values at heiger levels in the
prod based on the time period like for data < Oct2003 the custom rollup
should be
(Product Line.Ctg].CurrentMember.DataMember, 0).For the data > 2003 Oct
the custom rollup should be rollup from the children
in the dimension.I am giving the following syntax.but its not working
for heiger levels(like in the qurter level)


iif(FORMAT([Date].[Fiscal Month SC].currentmember.Name,"YYYYMM")
<"200410",CalculationPassValue([Product
Line.Ctg].CurrentMember.DataMember, 0),RollupChildren([Product
Line].[Ctg].CurrentMember,[Product
Line].[Ctg].CurrentMember.Properties("+")))

the above custom rollup i am giving in the product dim level.its not
workin properly.

Any suggestion to the above problem!

Thanks in advance.

bye,

Sunil.

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