Forum Discussion

vimala's avatar
vimala
Frequent Visitor
5 years ago

Cascading Bridge table drops Quota rows when sales does not exist

Hi ,

 

I have two fact tables

1.Sales detail table (at invoice line level)

2.Quota (at sales group and Territory level)

 

Cretaed the following Bridge tables

1. InvoicelinktoTerritory to connect between Sales Fact and TM-RM Dim table(which has all sales territory-salesgroup-rep details)

2. created another master Bridge table to make connection between Quota and TerritorySalesGroupDim, since TM-RM dim does not have all TerritorySalesGroup(it has territory-salesgroup combination related to sales alone)

 

Both Facts are connected to common calendar.

 

The issue is when i do drop Sales and Quota for Sales group it all works fine meaning even if no sales  avilable for the date , i get quota populated in my visual. But the moment i pull sales rep name from TerritorySalesgroup dim table where (territorysalesgroup does not exist for that quota's territorySalesGroup), visual drops of the quota rows.

 

See the relationships between them

1 Reply

  • Could you please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion?