how to drill on MEASURE ???

hi all

i was wondering if it is possible to use drill down on MEASURE if it is NOT created locally???


rola_jutt (BOB member since 2005-09-29)

If you mean, to split a calculation into it’s components… No.

Drilling in general doesn’t make sense on measures. You drill on dimensions. Drilling is about hierarchies of dimensions.


Steve Krandel :us: (BOB member since 2002-06-25)

thank you mr Krandel for your reply,

thats correct it does not make sense, but lets say we have a MEASURE by the name COUNT(of customers ), wat if we want to see the names of customers whose count is this… using drill mode???


rola_jutt (BOB member since 2005-09-29)

Lets say you have count of customers in a particular region. Then you might want to drill on region to show the customers associated with a particular region instead of trying to drill on the count.

Hope this makes sense.


Prateek Shah :india: (BOB member since 2005-07-24)

You should be looking at the OpenDocument function, see this topic for starters


Andreas :de: (BOB member since 2002-06-20)