I have build a report for Sales and Stock for different group of users, using section access whom ever log-in to the system data will be reduced to given access and that is how data model is also designed.
now the challange is we want to see all the items from stock table in this sales and stock report. having said that we have also implemented Section Access on this application, when ever user login to the system, user/manager can see only those sales which belongs to them and so it will also reduce stock data (assosiative model).
my requirment is even though user login to the system we want to see all item stock in report irrespective of sales items.
- duplicate data and in the the duplicate lines remove sales information, then link to a standard code. Then give the standard code to all users in Section access. So a user will see HIS sales' data and ALL stock's data.
- change your model to separate sales and stock, sales are linked to a section access code on which you can apply section access, stock are linked to a standard code which is given to all users
- change your model to separate sales and stock in 2 distinct tables. Only the sales table has a section access. The 2 tables are linked on a key which is the concatenation of all dimension.