Hi All & Deepak,

In my cube 3 dims like product,support,time and 2
measures.I am getting the correct values(sum) for the last
child for all those dim.As the defalut aggrn for measures
sum want to get correct avg for the above heirarchy's from
the last child.Here the other thing is my prod dim is the
parent child relation.In that 3,4 levels are there.Like
for prod dim heirarchy first NO1-->N2-->KL
NO1-->N2-->AK
In the above the last KL,AK are child from the
dim.N2,NO1 are the parent which is having self values.
so when i select last leaf(KL,AK) its correct but if i
select N01,N2(heigher level heirarchy's its not giving the
correct value of avg for measures.for getting avg for all
measures i am creating the calc cell as follows:

calculation sub cube:[Measures].Members
calculation condition:Measures.CurrentMember is [Measures].
[Upper Limit]Or Measures.CurrentMember is [Measures].
[Goal]
calculation value:
CalculationPassValue([Measures].CurrentMember
/[Measures].[Goal Count], -1, RELATIVE)

The calc cell is giving correct avg for measures.but if i
use the prod line(parent child) its giving wrong avg
measures.can you suggest??

When you say: "the parent which is having self values", can you clarify
whether you mean that, for the Prod dimension,
nonleaf members can have associated data; and if so:
are the data members visible or hidden?


- Deepak

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