Dear All,
| Reduction Table | | Site_Master | | Fact_Table |
| | | | | |
| Branch_Name | | Site_ID | | Site_ID |
| SA_Section | | Branch_Name | | Cust_ID |
| | | | | Emp_ID |
| | | | | Qty |
| | | | | Value |
| | | | | |
| Executive | | | | |
| | | | | |
| Emp_ID | | | | |
| Branch_Name_Executive | | | | |
Above is my data model
I have used one reduction table based on Branch Name.
Same branch name column is referred in 2 tables (Site_Master, Executive)
In Executive table i have changed name as Branch_Name_executive to avoid synthetic key
My Reduction table works fine
But When i used Branch_Name_executive column in front-end the column shows NULL
I don't know why. Need your Help
