Forum Discussion

eegarlepp's avatar
eegarlepp
Frequent Visitor
7 years ago

Multiple Slicers filtering 2 tables when only one active relationship can be set

Looking for some help with a problem I have that I have seen some community posts that I tried to no avail. Thank you ahead of time!

 

Have 3 tables - OPPTY, DATE, QUOTA

  1. DATE Table(not shown in pic but is pretty standard) that has an Active relationship to my OPPTY Table via the DATE columns in each
  2. QUOTA Table that has an Active relationship to my OPPTY Table via the AREA and OPPORTUNITY_AREA_C columns. 

Have 3 Slicers

  1. FISCAL QUARTER Slicer that can filter the OPPTY Table
  2. OPPORTUNITY_OWNER_MANAGER_c Slicer that can filter the OPPTY Table
  3. OPPORTUNITY_AREA_c Slicer that can filter both the OPPTY and QUOTA Tables

 

Need the 3 Slicers to filter both the OPPTY and QUOTA Tables.

I could set up different active relationships amongst the three tables and slicers and they would work but because I can't have multiple active relationships between these tables as they are connected already I am not able to. 

 

 

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    eegarlepp - It looks like your problem may be the bi-directional relationship between opp and quota. Does it need to be bi-directional? 

    Cheers!

    Nathan

    • eegarlepp's avatar
      eegarlepp
      Frequent Visitor
      7 years ago

      Thanks Anonymous for your response.  In the model are set the direction of those 2 tables from Both, to single and back and nothing. Below is how the relationship of the 2 tables is setup. The cardinality has to be Many to Many due to how the Quota table was created which was by way of unpivoting the original table.

       

       

       

      Hope this helps...