Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 50 branches.
And also,If Product Manger login into application appropriate product data shown to Product Mangers.
I want to write a section access for this data model.Please help me
Note: In Product Master table 3000+ products available.
Whether it is possible or not...
Any Idea????????