Hi all
is there nay alternative for the following calculated
member expression:
Sum([dimension].children,[measures].[measure1])

I ve used this to calculate the distinct sum for any given
parent. The problem is, when i try to view data, system
hangs and the processor usage is shown as 100% for a long
time...

Can anyone please suggest me for better performance
alternatives??

Thanks in adavance

Guru

what is your aggregation schema?
have you optimized your "childrens" dimension to "lower-level only" ?
In this case AS aggregates only the lower level in your dimension and then
your formula is optimized because AS will use aggreagated data.

"Guru" <shyam_chatty (AT) excite (DOT) com> a écrit dans le message de news:
169201c4a7bb$77dc5d70$a301280a (AT) phx (DOT) gbl...