Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Interaction between matrix tables

I have two matrix visuals that have a relationship using a bridge table on one common field. When I select one of the records on Matrix A, it does not filter/highlight the record on Matrix B. I've ch...
Need Help
  • mwimberger's avatar
    mwimberger
    6 years ago

    Hi Anonymous 

     

    From what I can gather from your description there are two reasons it might not filter as you expect

    1) Filter directions on the bridge table 

    2) making sure you have the row / column lookup values in the matrix set to the bridge (dim)  table and not the other fact tables

     

    Here is a link with a very simple example of a bridge using filter directions and using the Bridge (Dim) table as the filterable rows:

     

     

    Hope this helps and Happy New Year!

     

    Manfred

  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks everyone for the suggestions. Unfortunately there's no way I can remove the sensitive data and still share it. I missed adding the processors names in values along with the NetworkID to rows. It's working fine.

     

    A happy new year to all..!

     

mwimberger's avatar
mwimberger
Resolver II
6 years ago

Hi Anonymous 

 

From what I can gather from your description there are two reasons it might not filter as you expect

1) Filter directions on the bridge table 

2) making sure you have the row / column lookup values in the matrix set to the bridge (dim)  table and not the other fact tables

 

Here is a link with a very simple example of a bridge using filter directions and using the Bridge (Dim) table as the filterable rows:

 

 

Hope this helps and Happy New Year!

 

Manfred

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks everyone for the suggestions. Unfortunately there's no way I can remove the sensitive data and still share it. I missed adding the processors names in values along with the NetworkID to rows. It's working fine.

     

    A happy new year to all..!