Hi again,

I have found that a drill through action when I'm filtering on a many-many
dimension return all rows associated to the "all member" against this
dimension instead-of rows associated to the selected member of the many-many
dimension only.

is it a bug?
or a known limitation?

thanks.

Jerome.

Jerome,

it should be work.
Probably you defined the many-to-many dimension relationship without
completing the relations between the intermediate measure group and all
other dimensions.
You can read my paper (http://www.sqlbi.eu/manytomany.aspx) where I
explain a lot of scenario where I use this technique, and there is a
specific example with drill-through working as you expected.
If you have further questions, you can reach me by mail (see in the
paper), by newsgroup or by support forum on www.sqlbi.eu (there is a
specific forum on many-to-many dimensional modeling).

Marco Russo
http://www.sqlbi.eu
http://www.sqljunkies.com/weblog/sqlbi

Jeje wrote:

you are right

after a better look at my resultset, I found that the drill works fine and
is applyed, in fact more rows are returned due to the particular set of
dimension used.
Its wy at the first look I think the result was bad, but its not the case.


"Marco Russo" <marco.russo (AT) loader (DOT) it> wrote