Using Many-to-one relationship in a drill-through

[Anonymous]

Hi,

I need to create a drill-through between two tables, joined by many-to-on relationship. The master table contains the "many" records, while the "detail" table contains single row with lot of attibutes. 

After applying the join column as the drill-through column, the "detail" table always shows all the existing records, it simply does not filter by the drill through value

If I change the roles, if I want to do a drill through from the second table on to the first, based on the same column, the drill through works perfectly, it shows the expected rows, the ones that fullfill the drill through filter.

Any ideas what I might be doing wrong?

Thanks

Viktor

[amitchandak]

@Anonymous , I doubt the link column in visual and link column is table is not same. Some join problem.

Can you share data model?

[Anonymous · Accepted solution]

Thanks Amitchandak for the quick reply. Actually, the join was fine, but after double-and triple checking I found the problem (or at least I found a solution that works for me 🙂 )

If the cross-filter direction is set to "both" then the drill through works as expected.

Thanks 

Viktor