How to write an "all member formula" without breaking visual total

[Elyo Ravuna]

Hello,

I need to write an "all member formula" without breaking visual totals of
Analysis Services 2008.

Without any rollup function, the following query works perfectly:

select {MyDim.MyMember,MyDim.All} on 0 -->MyDim.All shows visual totals
from (select {MyDim.MyMember} on 0 from MyCube)

However, if I define the "all member formula" in the calculations section of
the cube,

CALCULATE;
MyDim.All = aggregate(MyDim.Children);

Then, the very same query doesn't give visual totals any more:

select {MyDim.MyMember,MyDim.All} on 0 -->visual totals is now broken
from (select {MyDim.MyMember} on 0 from mycube)

How can I write a custom rollup formula for the ALL level without breaking
visual totals?

Best regards.

Elyo Ravuna
Avnet Technology Solutions - Turkey

[Charles Wang [MSFT]]

Hi Elyo,
This is a quick note to let you know that we are observing this issue now
and will update you as soon as possible. Thank you for your patience.

Best regards,
Charles Wang

[Charles Wang [MSFT]]

Hi Elyo,
Based on our internal discussions, unfortunately finally I got the
confirmation that currently this is a by design limitation. We suggest that
you submit a feedback to our product team at
https://connect.microsoft.com/sql.

Best regards,
Charles Wang