Hi all
Please help me on this expression:

iif(isleaf([book].currentmember),[Measures].[Pages]/
[Measures].[Books],sum([book].children,[measures].[page]))

Hope this expression explains my requirement(sum of
children).. this is working fine.. But if keep a parent-
child dimension on the row axis instead of [book].. the
system sinks.. its taking a lot of time to generate the
data, around 15 minutes.. The parent-child dimension has 5
levels..

Can anyone please help me on this.. how to get it fast??

Thanks in advance

Guru

Difficult to tell where your problem is without the query that is slow. But
here are a couple ideas:
- Give the calculation a non empty behavior. Often the non empty key word is
used in queries - and you'll spend a lot of time doing useless calculations.
- Do you really need to sum the children when you're off the leaf level?
Doesn't sum([book].children,[measures].[page]) = [measures].[page]?

--
This posting is provided 'AS IS' with no warranties, and confers no rights.

"guru" <anonymous (AT) discussions (DOT) microsoft.com> wrote