Hi,

I have added a new measure group with only 1 hidden measure on it.
the purpose of this measure group is to allow me to drill on a different
table then the fact table.

but if the measure is hidden I can't execute the drillthrough, in fact there
is nothing returned.
if the measure is visible in the cube then the drill works fine.

My non working query:
drillthrough select

(dimension1.member,dimension2.member....) on 0

from <mycube>

where ([Measures].[HiddenMeasure])

My working query:
drillthrough select

(dimension1.member,dimension2.member....) on 0

from <mycube>

where ([Measures].[VisibleMeasure])



what can I do?
is it a bug?

thanks.

Jerome.