Forum Discussion
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
- v-angzheng-msft
Community Support
Could you please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion?