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 ...
Need Help
Tips and Tricks
  • 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 

     

amitchandak's avatar
amitchandak
Super User
5 years ago

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
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