Dear All,
| | | | | | | | |
Product | | | | | | | Branch | |
| | | | Sales Fact table | | | | |
Product_Code | | | | Fact_table | | | Branch_code | |
Product_Name | | | | Product_Code | | | Branch_Name | |
Product_Group | | | | Branch_code | | | | |
Product_Desc | | | | Customer_No | | | | |
Product_Manger | | | | Company_code | | | | |
| | | | KPI_Qty | | | | |
| | | | KPI_Value | | | | |
Customer | | | | KPI_Net Profit | | | Company | |
| | | | | | | | |
Customer_No | | | | Busniess Plan fact Table | | | Company_code | |
Customer_Name | | | | Concatenate with (Sales Table) | | | Company_Name | |
| | | | ItemGroup | | | | |
| | | | Customer_No | | | | |
| | | | Branch_code | | | | |
| | | | Company_code | | | | |
| | | | KPI_Target | | | | |
| | | | KPI_Potential | | | | |
The above is my data model.
This application is about Sales Analysis. If Branch Manger login into application data has to filter and appropriate branch data shown to the branch mangers.
Note: In Branch Master table we have 60 branches
And also,If Product Manger login into application appropriate product data shown to Product Mangers.
Note: In Item Master table we have more than 3000+ products
I want to write a section access for this data model.Please help me