Whenever we enable drill mode, drills get enabled both on dimension and measures. I want drill only on dimensions and not on measure. One way is to create a variable over each measure. and using the variable instead of universe object. But this is too hectic. I don’t want to use this option. Any other way to enable drill only on dimensions and not on measures.
Thanks
avbaby 
(BOB member since 2009-05-09)
hi!
good day! i’m a beginner of BOBJ. my colleague told me to use nodrillfilter() function once i encountered this same problem.
ex. nodrillfilter([measure]).
hope it help…
artrecamara 
(BOB member since 2009-07-22)
Hi,
you can also use following :
=if(1=1;[measure])
mkgupta 
(BOB member since 2009-05-14)
Hello,
it also works to multiply the measure object with 1 or to add 0 to it.
Greetings,
Philipp
Philipp Dopjans (BOB member since 2009-09-10)
thnx for your answers. all the replies will resolve the problem. I know that by doing any operation on a universe object, drill can be removed from measure values. Is there any option available to disable this directly without doing workaroaunds. Secondly, my question is wats the logic behind providing drill on a number. For example, if i am clicking on any figure, say 100 and going to next level which is not related to 100, then whats the relevance of having drill on the measure.
avbaby (BOB member since 2009-05-09)