One alternate approach would be to create a dummy measure, and then put over
it a calculated cell with the same expression that you would've put
otherwise into calculated measure. Actually, you probably can even improve
it, by applying such calculated cell over the original measure, and
excluding the areas where the measure is additive.
--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
"Niraj Tenany" <ntenany (AT) hotmail (DOT) com> wrote
Quote:
Hello all:
As you know that in order to avoid summing of inventory data,
calculated measures need to be created. However, once calculated
measures are created, we loose the ability to do drill through on the
calculated measure. I would appreciate if you could advice of an
alternate approach to get to additional attributes in the fact table.
Thanks |