dbTalk Databases Forums  

Re: Drill Through with Semi Additive measures

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Re: Drill Through with Semi Additive measures in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: Drill Through with Semi Additive measures - 08-18-2003 , 11:14 PM






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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.