Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

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

  • Anonymous's avatar
    Anonymous
    5 years ago

    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 

     

2 Replies

  • 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's avatar
      Anonymous
      Not applicable

      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